Check the LTMOBJECTS table for error information

You can examine the contents of the LTMOBJECTS system table on DB2 to determine causes of replication errors.

Steps To check the contents of the LTMOBJECTS table

  1. Execute a SELECT * on the ERROR_CODE column in the LTMOBJECTS system table on DB2 using the following syntax:

    SELECT ERROR_CODE FROM LTMADMIN.LTMOBJECTS
    

    where LTMADMIN is the LTMADMIN user ID you recorded on the Replication Agent Installation Worksheet during installation.

  2. If the column ERROR_CODE contains a value other than zero, check the contents of message LEX0047. This message contains information about the table containing the error, and the type of error that stopped replication on that table.

See also