Working with Replication Agent system tables

During installation, Replication Agent creates several system tables on DB2. This chapter contains detailed information about using the Replication Agent system tables on DB2 to coordinate bulk materialization and mark tables for replication. Use this chapter for the following tasks:

The SQLINIT member, located in the hlq.JCL data set, contains a set of example SQL statements that you can use to create the LTMOBJECTS table in a DB2 system.

The LTMADMIN user (this identifier was recorded during installation, on section 1 of the Replication Agent Installation Worksheet) should insert and delete rows into the LTMOBJECTS table representing tables marked for replication.

LTMOBJECTS tracks the DB2 tables marked for replication.