The following table provides a list of tables used at the control
server.
Table 33. Quick Reference for Tables Created at the Control Server during IBM Replication Processes
| Table name | Internal name and Description | See page |
|---|---|---|
| Apply trail table | ASN.IBMSNAP_APPLYTRAIL
Records a history of updates performed against subscriptions. This table is a repository of diagnostics and performance statistics that can be used to audit update activity. | "Apply Trail Table" |
| Subscription columns table | ASN.IBMSNAP_SUBS_COLS
Contains information on the common subscription columns being copied in a subscription. | "Subscription Columns Table" |
| Subscription events table | ASN.IBMSNAP_SUBS_EVENT
Contains information on the events being copied in a subscription. | "Subscription Events Table" |
| Subscription set table | ASN.IBMSNAP_SUBS_SET
Ensures that each set name is used only once for every Apply qualifier. | "Subscription Set Table" |
| Subscription statements table | ASN.IBMSNAP_SUBS_STMTS
Contains information on the statements being copied in a subscription. | "Subscription Statements Table" |
| Subscription targets member table | ASN.IBMSNAP_SUBS_MEMBR
Contains information on the target members being copied in a subscription. | "Subscription Targets Member Table" |
| Row-replica target list table
(Microsoft Jet specific) | ASN.IBMSNAP_SUBS_TGTS
Maintains the names of the row-replica tables. | "Row-Replica Target List Table (Microsoft Jet Specific)" |
| Subscription schema changes table
(Microsoft Jet specific) | ASN.IBMSNAP_SCHEMA_CHG
Used to signal one of the following modifications to a subscription:
| "Subscription Schema Changes Table (Microsoft Jet Specific)" |