The following table provides a list of tables used at the source
server.
Table 40. Quick Reference for Tables Used at the Source Server during DB2 DataPropagator Processes
| Table name | Internal name and Description | See page |
|---|---|---|
| Apply-qualifier-cross-reference table (AS/400 specific) | ASN.IBMSNAP_AUTHTKN
Contains information to support update-anywhere. | "Apply-qualifier-cross-reference table (AS/400 specific)" |
| Capture enqueue table
(VM and VSE specific) | ASN.IBMSNAP_CCPENQ
Used to ensure that only one Capture program is running per database. | "Capture enqueue table (VM and VSE specific)" |
| Change data table | CD
A staging table that contains changed data information. Created when a replication source is defined. | "Change data table" |
| Critical section table | ASN.IBMSNAP_CRITSEC
Used to prevent circular replication for update-anywhere subscriptions. | "Critical section table" |
| Pruning control table | ASN.IBMSNAP_PRUNCNTL
Coordinates synchpoint updates by allowing the Apply program to communicate with the Capture program and coordinates pruning of tables. There is one pruning control table at each source server and one row per source-to-target copy. | "Pruning control table" |
| Prune lock table | ASN.IBMSNAP_PRUNE_LOCK
Used to serialize the access of staging tables during a cold start or retention limit pruning. | "Prune lock table" |
| Register table | ASN.IBMSNAP_REGISTER
Contains information about replication sources, such as the names of the replication source tables, their attributes, and their corresponding CD and CCD table names. | "Register table" |
| Register extension table (AS/400 specific) | ASN.IBMSNAP_REG_EXT
An extension of the replication source table, ASN.IBMSNAP_REGISTER. Contains additional information about replication sources, such as the journal name and the remote source table's RDB entry name. | "Register extension table for AS/400" |
| Register synchronization table | ASN.IBMSNAP_REG_SYNCH
When replicating from a non-IBM data source, an update trigger on this table initiates an update of the SYNCHPOINT value for all the rows in the register table before the Apply program reads the information from the register table. | "Register synchronization table" |
| Trace table | ASN.IBMSNAP_TRACE
Contains Capture program audit trail information. | "Trace table" |
| Tuning parameters table | ASN.IBMSNAP_CCPPARMS
Contains parameters that you can modify to control the performance of the Capture program. | "Tuning parameters table" |
| Unit-of-work table | ASN.IBMSNAP_UOW
Contains information about committed transactions. Used to maintain transaction consistency. | "Unit-of-work table" |
| Warm start table | ASN.IBMSNAP_WARM_START
Contains information that enables the Capture program to resume capturing from the point in the log or journal where it last stopped. For AS/400 platforms, this table is used to determine the starting time of the RCVJRNE (Receive Journal Entry) command. | "Warm start table" |