Troubleshooting
Problem
Customer migrated their APM DB from db2 v10.5.0.10 to db2 v11.1.4.5. However, the KSY service is not able to aggregate and prune all tables.
Symptom
The errors below were seen in the sy log:
== 10269 t=work3 EXCEPTION: Failed to run worker
== 10270 t=work3 Database Connection verified as available for Requestor: Worker, Thread: work3
== 10271 t=work4 EXCEPTION: Failed to execute the asynchronous partition detach stored procedure
== 10272 t=work4 EXCEPTION: com.tivoli.twh.ksy.core.KSYException: Failed to prune partitions
at com.tivoli.twh.ksy.agg.RawTable.prunePartitions(RawTable.java:4114)
at com.tivoli.twh.ksy.agg.RawTable.createAggregatesAndPrune(RawTable.java:3687)
at com.tivoli.twh.ksy.agg.RawTable.executeWork(RawTable.java:5078)
at com.tivoli.twh.ksy.agg.Worker.run(Worker.java:86)
Caused by: com.tivoli.twh.ksy.core.KSYException: com.ibm.db2.jcc.am.SqlException: An error occurred during implicit system action type "3". Information returned for the error includes SQLCODE "-551", SQLSTATE "42501" and message tokens "DB2APM|CREATE PROCEDURE|ITMUSER.WAITFORDETACH".. SQLCODE=-727, SQLSTATE=56098, DRIVER=3.69.24
at com.tivoli.twh.ksy.agg.RawTable.asynchronousPartitionDetach(RawTable.java:4482)
at com.tivoli.twh.ksy.agg.RawTable.detachDB2Partition(RawTable.java:4394)
at com.tivoli.twh.ksy.agg.RawTable.prunePartitions(RawTable.java:4063)
... 3 more
Caused by: com.ibm.db2.jcc.am.SqlException: An error occurred during implicit system action type "3". Information returned for the error includes SQLCODE "-551", SQLSTATE "42501" and message tokens "DB2APM|CREATE PROCEDURE|ITMUSER.WAITFORDETACH".. SQLCODE=-727, SQLSTATE=56098, DRIVER=3.69.24
at com.ibm.db2.jcc.am.gd.a(Unknown Source)
== 10270 t=work3 Database Connection verified as available for Requestor: Worker, Thread: work3
== 10271 t=work4 EXCEPTION: Failed to execute the asynchronous partition detach stored procedure
== 10272 t=work4 EXCEPTION: com.tivoli.twh.ksy.core.KSYException: Failed to prune partitions
at com.tivoli.twh.ksy.agg.RawTable.prunePartitions(RawTable.java:4114)
at com.tivoli.twh.ksy.agg.RawTable.createAggregatesAndPrune(RawTable.java:3687)
at com.tivoli.twh.ksy.agg.RawTable.executeWork(RawTable.java:5078)
at com.tivoli.twh.ksy.agg.Worker.run(Worker.java:86)
Caused by: com.tivoli.twh.ksy.core.KSYException: com.ibm.db2.jcc.am.SqlException: An error occurred during implicit system action type "3". Information returned for the error includes SQLCODE "-551", SQLSTATE "42501" and message tokens "DB2APM|CREATE PROCEDURE|ITMUSER.WAITFORDETACH".. SQLCODE=-727, SQLSTATE=56098, DRIVER=3.69.24
at com.tivoli.twh.ksy.agg.RawTable.asynchronousPartitionDetach(RawTable.java:4482)
at com.tivoli.twh.ksy.agg.RawTable.detachDB2Partition(RawTable.java:4394)
at com.tivoli.twh.ksy.agg.RawTable.prunePartitions(RawTable.java:4063)
... 3 more
Caused by: com.ibm.db2.jcc.am.SqlException: An error occurred during implicit system action type "3". Information returned for the error includes SQLCODE "-551", SQLSTATE "42501" and message tokens "DB2APM|CREATE PROCEDURE|ITMUSER.WAITFORDETACH".. SQLCODE=-727, SQLSTATE=56098, DRIVER=3.69.24
at com.ibm.db2.jcc.am.gd.a(Unknown Source)
Document Location
Worldwide
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSVJUL","label":"IBM Application Performance Management"},"ARM Category":[{"code":"a8m0z000000bmADAAY","label":"APM Server-\u003EAPMUI"}],"ARM Case Number":"TS003947059","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1.4","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]
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.
Was this topic helpful?
Document Information
Modified date:
31 July 2020
UID
ibm16255192