Incremental sync failing

Technote (FAQ)


Question

Error DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, S

Cause

TADDM Incremental sync failing with DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, S

at java.lang.Thread.run(Thread.java:801)
2009-03-27 12:28:43,563 TopologyManager [RMI TCP
Connection(194)-9.44.36.200] ERROR sql.ShadowQuery -
change_sync creation and/or population failed
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -601, SQLSTATE:
42710, SQLERRMC: CMDB2.CHANGE_SYNC;TABLE
at com.ibm.db2.jcc.a.ig.e(ig.java:1594)
at com.ibm.db2.jcc.a.ig.b(ig.java:1158)
at com.ibm.db2.jcc.c.gb.h(gb.java:217)
at com.ibm.db2.jcc.c.gb.b(gb.java:46)
at com.ibm.db2.jcc.c.w.b(w.java:40)
at com.ibm.db2.jcc.c.vb.e(vb.java:118)
at com.ibm.db2.jcc.a.ig.m(ig.java:1153)
at com.ibm.db2.jcc.a.ig.a(ig.java:1868)
at com.ibm.db2.jcc.a.ig.c(ig.java:520)
at com.ibm.db2.jcc.a.ig.executeUpdate(ig.java:504)
at
com.collation.topomgr.sql.ShadowQuery.executeUpdate(ShadowQuery.java:
350)
at
com.collation.topomgr.sql.ShadowQuery.executeUpdate(ShadowQuery.java:
341)
at
com.collation.topomgr.sql.ShadowQuery.createTable(ShadowQuery.java:57
)


Answer

Found that the change_sync table had 5 million rows left in it.

The change_sync table is a temporary table which holds all the change_history events since the last
sync. It needs to be empty in order for the incremental sync to work.

Two options: drop and recreate or empty out table which could take a sec for 5 million rows

To check to make sure the table is empty, run the following command for DB2

$ db2 "select count(*) from change_sync"

This is fixed in taddm version 7.1.2 IF01. Starting in that version the table will be dropped after the sync compared to being emptied after sync !

To drop and recreate a table one can run the following command for DB2
can the user run:
db2 connect to <db>
db2 "drop table change_sync"
db2 "create table change_sync (field1 char(6))"

Re-run the incremental sync

Product Alias/Synonym

TADDM

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Application Dependency Discovery Manager

Software version:

7.1, 7.1.2

Operating system(s):

AIX

Reference #:

1381025

Modified date:

2011-02-23

Translate my page

Machine Translation

Content navigation