This Replication Agent system table is stored on DB2. It tracks the DB2 primary tables marked for replication. The LTMOBJECTS table contains one row for each table that is marked for replication. Replication Extract reads this table at start-up to determine which tables to replicate. When this table changes, Replication Extract dynamically implements the changes.
Table 3-2 describes the contents of the LTMOBJECTS table.
Column name |
Datatype |
Length (bytes) |
Description |
---|---|---|---|
CREATOR |
char not null with default |
8 |
Creator of the table to be replicated. |
NAME |
char not null |
30 |
Name of the table to be replicated. |
QUALIFY |
char not null with default, which is N |
1 |
This column is used to indicate whether the name of the table being replicated is qualified with its creator ID. |
QID |
char not null with default |
32 |
The queue ID at the time of failure. Disregard unless error code is non-zero. Replication Extract makes changes to this column. |
ERROR_CODE |
smallint not null with default |
2 |
The Replication Extract error code. Non-zero means the log extract encountered a problem replicating this table and Replication Agent stopped replication. Replication Extract makes changes to this column. |
REPLICATE_NAME |
char not null with default |
128 |
Blank spaces in this column indicate primary and replicate table names are the same. Edit the entry in this field to assign a different name to the replicate table name. See Chapter 4, “Managing Replication Agent” for more information.
|