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
- An updateable target table that is used to replicate data back to the
origin 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 ]