This chapter describes the relational database tables that IBM Replication uses in its copy operations.
Sample CREATE TABLE statements are provided for all tables.
Table 20, Table 21, and Table 22 provide directories to the tables described in this chapter. These tables
list the table names, the internal names, and the reference page number.
Table 20. Quick Reference for Tables Used at the Source Server during IBM Replication Processes
| Table name | Internal name | Refer to |
|---|---|---|
| Capture enqueue table | ASN.IBMSNAP_CCPENQ | "Capture Enqueue Table" |
| Change data table | userid.ASNtimestampCD | "Change Data Table" |
| Critical section table | ASN.IBMSNAP_CRITSEC | "Critical Section Table" |
| Pruning control table | ASN.IBMSNAP_PRUNCNTL | "Pruning Control Table" |
| Register table | ASN.IBMSNAP_REGISTER | "Register Table" |
| Trace table | ASN.IBMSNAP_TRACE | "Trace Table" |
| Tuning parameters table | ASN.IBMSNAP_CCPPARMS | "Tuning Parameters Table" |
| Unit-of-work table | ASN.IBMSNAP_UOW | "Unit-of-Work Table" |
| Warm start table | ASN.IBMSNAP_WARM_START | "Warm Start Table" |
| Warm start table for Capture for VSE and VM | ASN.IBMSNAP_WARM_START | "Warm Start Table for Capture for VSE and VM" |
Table 21. Quick Reference for Tables Created at the Control Server during IBM Replication Processes
| Table name | Internal name | Refer to |
|---|---|---|
| Apply trail table | ASN.IBMSNAP_APPLYTRAIL | "Apply Trail Table" |
| Subscription columns table | ASN.IBMSNAP_SUBS_COLS | "Subscription Columns Table" |
| Subscription events table | ASN.IBMSNAP_SUBS_EVENT | "Subscription Events Table" |
| Subscription set table | ASN.IBMSNAP_SUBS_SET | "Subscription Set Table" |
| Subscription statements table | ASN.IBMSNAP_SUBS_STMTS | "Subscription Statements Table" |
| Subscription targets member table | ASN.IBMSNAP_SUBS_MEMBR | "Subscription Targets Member Table" |
Table 22. Quick Reference for Target Tables
| Table name | Internal name | Refer to |
|---|---|---|
| Base aggregate target table | userid.target_table | "Base Aggregate Target Table" |
| Change aggregate target table | userid.target_table | "Change Aggregate Target Table" |
| Consistent change data target table | userid.target_table | "Consistent Change Data Table" |
| Point-in-time target table | userid.target_table | "Point-in-Time Target Table" |
| Replica target table | userid.target_table | "Replica Target Table" |
| User copy target table | userid.target_table | "User Copy Target Table" |