The following table provides a list of tables used at the target
server.
Table 34. Quick Reference for Target Tables
| Table name | Internal name and Description | See page |
|---|---|---|
| Base aggregate target table | userid.target_table
A target table that contains data aggregated from a source table. | "Base Aggregate Target Table" |
| Change aggregate target table | userid.target_table
A target table that contains data aggregations based on changes from a source table. | "Change Aggregate Target Table" |
| Consistent change data target table | userid.target_table
A join of the change data table and the unit-of-work table. The join step needs to be performed only once for the case of a one-many fan-out snapshot, if the results of a join are stored in the consistent change data target table. | "Consistent Change Data Table" |
| Point-in-time target table | userid.target_table
Indicates a specific commit time from the source server. | "Point-in-Time Target Table" |
| Replica target table | userid.target_table
Contains a primary key identical to the primary key of the user table. | "Replica Target Table" |
| User copy target table | userid.target_table
Identical to a point-in-time table except that the IBMSNAP_LOGMARKER column is not included here. | "User Copy Target Table" |
| Conflict table
(Microsoft Jet specific) | IBMSNAP_<target_name>_CONFLICT
Contains row data for DataPropagator for Microsoft Jet-detected conflict losers. | "Conflict Table (Microsoft Jet Specific)" |
| Error information table
(Microsoft Jet specific) | IBMSNAP_ERROR_INFO
Contains additional information to identify the row-replica table and row that caused an error. | "Error Information Table (Microsoft Jet Specific)" |
| Error messages table
(Microsoft Jet specific) | IBMSNAP_ERROR_MESSAGE
Contains error codes and error messages. There can be more than one row in this table. Depending on the error code, additional information will be available in the error information, error side information, and conflict tables. | "Error Messages Table (Microsoft Jet Specific)" |
| Error side information table
(Microsoft Jet specific) | IBMSNAP_SIDE_INFO
Contains the names of the conflict tables. | "Error Side Information Table (Microsoft Jet Specific)" |
| Key string table
(Microsoft Jet specific) | IBMSNAP_GUID_KEY
Maps the Microsoft Jet table identifiers and row identifiers to primary key values when the following actions occur:
| "Key String Table (Microsoft Jet Specific)" |
| Synchronization generations table
(Microsoft Jet specific) | IBMSNAP_S_GENERATION
Prevents cyclic updates from propagating back to the RDBMS from a Microsoft Jet database. | "Synchronization Generations Table (Microsoft Jet Specific)" |