Troubleshooting
Problem
Receiving the error during summarizing the warehouse data: The name of the object to be created is identical to the existing name "<warehouse table>" of type "TABLE".. SQLCODE=-601, SQLSTATE=42710, DRIVER=3.67.27
Symptom
== 6031 t=work1 SQLException occured. SQL State = 42710 , SQL Error Code = -601
== 6032 t=work1 com.ibm.db2.jcc.am.SqlSyntaxErrorException: The name of the object to be created is identical to the existing name "<warehouse table name>" of type "TABLE".. SQLCODE=-601, SQLSTATE=42710, DRIVER=3.67.27
at com.ibm.db2.jcc.am.gd.a(gd.java:749)
at com.ibm.db2.jcc.am.gd.a(gd.java:66)
at com.ibm.db2.jcc.am.gd.a(gd.java:135)
at com.ibm.db2.jcc.am.so.b(so.java:2430)
at com.ibm.db2.jcc.am.so.c(so.java:2413)
at com.ibm.db2.jcc.t4.ab.l(ab.java:406)
at com.ibm.db2.jcc.t4.ab.a(ab.java:62)
at com.ibm.db2.jcc.t4.o.a(o.java:50)
at com.ibm.db2.jcc.t4.ub.b(ub.java:220)
at com.ibm.db2.jcc.am.to.pc(to.java:3415)
at com.ibm.db2.jcc.am.to.b(to.java:4380)
at com.ibm.db2.jcc.am.to.hc(to.java:782)
at com.ibm.db2.jcc.am.to.executeUpdate(to.java:760)
at com.tivoli.twh.ksy.db.WHPreparedStatement.executeUpdate(WHPreparedStatement.java:810)
at com.tivoli.twh.ksy.agg.AggTable.createInDatabase(AggTable.java:1010)
at com.tivoli.twh.ksy.agg.RawTable.setupAggregationTables(RawTable.java:2575)
at com.tivoli.twh.ksy.agg.RawTable.createAggregatesAndPrune(RawTable.java:3551)
at com.tivoli.twh.ksy.agg.RawTable.executeWork(RawTable.java:5067)
at com.tivoli.twh.ksy.agg.Worker.run(Worker.java:86)
Cause
May be two SY agents trying to summarize the same table
Environment
AIX, Linux and Windows
Diagnosing The Problem
Check the default RAS1 log of Summarizing and Pruning Agent
Resolving The Problem
This could be due to two Summarizing and Pruning (SY) agents pointing to the same warehouse da
Was this topic helpful?
Document Information
Modified date:
04 September 2018
UID
ibm10730267