DB2 Replication Guide and Reference
A replication source is a table used as a source for copying data to a
target table. Replication sources can be the following types of
tables:
- User table
- A table created and used (read and updated by an application) outside of
replication. Updates to the table can be captured and copied to a
replication target table.
- Replication target table
- Read-only target tables that have been redefined as sources for
replication.
- Consistent change data (CCD) tables
- A staging table, a target table type that has been redefined as a source
table for staged replication.
- External CCD table
- A consistent change data table that has been populated from an external
source such as an IMS segment.
- Replica table
- A target table that is used to replicate data back to the source
table.
When you define a table as a replication source, a replication source
object is created and a row is inserted into the register control table,
making it available as a source table for replication subscription.
Unless you specify full-refresh copying, the source table is enabled for
change data capture: the table is checked for the Data Capture Changes
option of the CREATE TABLE SQL statement. If it is not already enabled,
the source table is altered to enable the option.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]