LTMOBJECTS table contents

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.

**Table 3-2: *LTMOBJECTS* table schema**
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. Replication Agent does not verify that the entry is a valid table name.