The following table provides a list of tables used at the source
serve.
Table 32. Quick Reference for Tables Used at the Source Server during IBM Replication Processes
| Table name | Internal name and Description | See page |
|---|---|---|
| Capture enqueue table | ASN.IBMSNAP_CCPENQ
Used in the VM and VSE environments to ensure that only one Capture program is running per database. | "Capture Enqueue Table" |
| Change data table | ASN.CDtimestamp
Created while defining replication sources. It contains changed data information. The timestamp in the table name is from the source server; for auto-registered tables, the timestamp is from the target server. | "Change Data Table" |
| Critical section table | ASN.IBMSNAP_CRITSEC
Used as a logical lock between the Capture program and the Apply program for serialization of internal logic. | "Critical Section Table" |
| Pruning control table | ASN.IBMSNAP_PRUNCNTL
Pruning control information for the current source server. There is one pruning control table at each source server and one row per source-to-target copy. This table associates timestamp with log address, allows the Apply program to trigger the Capture program, and coordinates pruning. | "Pruning Control Table" |
| Register table | ASN.IBMSNAP_REGISTER
Contains information about replication sources, such as the names of the replication source tables, their attributes, and their staging table names. | "Register Table" |
| Trace table | ASN.IBMSNAP_TRACE
Contains Capture program audit trail information. Required if the Capture program is installed. | "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
Used to maintain transaction consistency. It is a staging table that contains commit information. The information from this staging table is joined with change information from the change data table to produce consistent, committed changes. | "Unit-of-Work Table" |
| Warm start table | ASN.IBMSNAP_WARM_START
Contains information that enables the Capture program to resynchronize. | "Warm Start Table" |
| Warm start table for Capture for VSE and VM | ASN.IBMSNAP_WARM_START
Contains information that enables the Capture program to resynchronize in the VM and VSE environments. | "Warm Start Table for Capture for VSE and VM" |