Replication Guide and Reference

Database currency

DB2 replication now provides:

LOB support

You can use DB2 DataPropagator to replicate columns with large-object (LOB) data. The Capture program flags information about changed LOB data, but does not copy the LOB data to staging tables. The Apply program copies changed LOB data directly from the source table to the target table. You can replicate LOB data between DB2 for OS/390 servers or between DB2 Universal Database servers for UNIX, Windows, and OS/2 operating systems. If you have DB2 Connect Version 6, you can also copy LOB data between DB2 for OS/390 and DB2 Universal Database servers for UNIX, Windows, and OS/2 operating systems.

ROWID support

DB2 for OS/390 V6 allows you to generate a unique identifier for each row in a table and store that identifier in a ROWID column. Using the ROWID, you can access a particular row without needing to access an index or scan the table space. Usually a ROWID identifies a row in the table that has the ROWID defined. However, by copying ROWID values from the source table to set the target rows with the same ROWID values, you can use the same ROWID value to identify both the source and target row.

Version-independent capture

The Capture program can read the log for DB2 for MVS/ESA V4, DB2 for OS/390 V5, or DB2 for OS/390 V6. Therefore you can run different versions of DB2 in a data-sharing environment, for example during version-to-version migration, and have one Capture program continue to capture transaction-consistent data.

ODBC support

This feature was added in DB2 for OS/390 V5 and updated in V6 to support a new catalog table (SQLProcedureColumns).

Unicode support

Unicode support is built into DB2 DataPropagator for UNIX, Windows, and OS/2 operating systems.

Port to Linux

DB2 DataPropagator V6 was ported to the Linux operating system.

[ DB2 List of Books | Search the DB2 Books ]