IBM Support

Removing a cdr delete table

Question & Answer


Question

If you define a replicate using timestamp resolution, Enterprise Replication (ER) will create shadow delete tables (cdr_deltab) in the syscdr database. Records are insert into these tables by the data sync thread when a row is deleted. As an ER user, you do not need to do any thing for these tables. However, some inconsistencies may leave orphan delete tables in syscdr database. For example, you can get following types of error messages for some inconsistencies in syscdr database: 12:58:19 CDR: Could not drop delete table. SQL code -206, ISAM code -111. Table 'cdr_deltab_000002'. Please drop the table manually. 12:58:19 CDR Grouper: Grouper evaluation )unblocked 12:58:19 CDR Grouper: Grouper evaluation blocked 12:58:19 CDR: Could not drop delete table. SQL code -206, ISAM code -111. Table 'cdr_deltab_000003'. Please drop the table manually. How can you delete an orphan 'cdr_deltab' table?

[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF022","label":"OS X"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"11.5;11.7;12.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
16 June 2018

UID

swg21665871

Page Feedback