When Replication Extract detects an error, it updates the row in the LTMOBJECTS table corresponding to the table you are replicating. At this time, the ERROR_CODE column contains a non-zero number and replication of that table discontinues until you correct the problem.
After you correct the problem, restart replication on the table using one of the following procedures. Sybase recommends using the first procedure.
To restart replication on the primary table using SPUFI
Use SPUFI to issue a DELETE on the LTMOBJECTS table row associated with the primary table.
Use SPUFI to reinsert the row you deleted in step 1 into the LTMOBJECTS table.
In the LTMOBJECTS table:
Set the contents of the ERROR_CODE column to 0.
You can find sample SQL in the SETRPERR member of the hlq.DOCS data set.
Replace the contents of the QID column with blanks (spaces).
“Replication Agent Distribution Tape Contents,” in the Replication Agent for DB2 UDB Installation Guide for OS/390 for information about the SETREPERR member of the hlq.DOCS data set