APAR status
Closed as program error.
Error description
AliasesCleanupAgent fails to remove orphaned aliases from aliases table when there is huge amount of aliases to remove. The following error occurs in error.log: TopologyBuilder [TopologyBuilderEngineThread$Cleanup@4.0] ERROR agents. AliasesCleanupAgent - Failed to delete orphaned guids in ALIASES table com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-723, SQLSTATE=0 9000, SQLERRMC=S013618.TRG_ALIASES_DEL;-964;57011;, DRIVER=3.63.75 at com.ibm.db2.jcc.am.fd.a(fd.java:682) at com.ibm.db2.jcc.am.fd.a(fd.java:60) at com.ibm.db2.jcc.am.fd.a(fd.java:127) at com.ibm.db2.jcc.am.yn.b(yn.java:2317) at com.ibm.db2.jcc.am.yn.c(yn.java:2300) at com.ibm.db2.jcc.t4.cb.l(cb.java:370) at com.ibm.db2.jcc.t4.cb.a(cb.java:62) at com.ibm.db2.jcc.t4.q.a(q.java:50) at com.ibm.db2.jcc.t4.tb.b(tb.java:220) at com.ibm.db2.jcc.am.zn.lc(zn.java:3314) at com.ibm.db2.jcc.am.zn.b(zn.java:4271) at com.ibm.db2.jcc.am.zn.dc(zn.java:757) at com.ibm.db2.jcc.am.zn.executeUpdate(zn.java:740) at com.ibm.cdb.topomgr.topobuilder.agents.AliasesCleanupAgent.remov eOrp hanedGuids(AliasesCleanupAgent.java:992) at com.ibm.cdb.topomgr.topobuilder.agents.AliasesCleanupAgent.remov eOrp hanedGuidsInAliases(AliasesCleanupAgent.java:933) at com.ibm.cdb.topomgr.topobuilder.agents.AliasesCleanupAgent.run(A lias esCleanupAgent.java:196) .. Or; 2013-06-26 23:10:37,342 TopologyBuilder [TopologyBuilderEngineThread$Cleanup@4.0] ERROR agents.AliasesCleanupAgent - Failed to delete orphaned guids in ALIASES table com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-964, SQLSTATE=57011, SQLERRMC=null, DRIVER=3.63.75 at com.ibm.db2.jcc.am.fd.a(fd.java:682) ..
Local fix
N/A
Problem summary
AliasesCleanupAgent fails to remove orphaned aliases from aliases table when there is huge amount of aliases to remove. The following error occurs in error.log: TopologyBuilder [TopologyBuilderEngineThread$Cleanup@4.0] ERRO agents. AliasesCleanupAgent - Failed to delete orphaned guids in ALIASE table com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-723, SQLSTATE=0 9000, SQLERRMC=S013618.TRG_ALIASES_DEL;-964;57011;, DRIVER=3.63.75 at com.ibm.db2.jcc.am.fd.a(fd.java:682) at com.ibm.db2.jcc.am.fd.a(fd.java:60) at com.ibm.db2.jcc.am.fd.a(fd.java:127) at com.ibm.db2.jcc.am.yn.b(yn.java:2317) at com.ibm.db2.jcc.am.yn.c(yn.java:2300) at com.ibm.db2.jcc.t4.cb.l(cb.java:370) at com.ibm.db2.jcc.t4.cb.a(cb.java:62) at com.ibm.db2.jcc.t4.q.a(q.java:50) at com.ibm.db2.jcc.t4.tb.b(tb.java:220) at com.ibm.db2.jcc.am.zn.lc(zn.java:3314) at com.ibm.db2.jcc.am.zn.b(zn.java:4271) at com.ibm.db2.jcc.am.zn.dc(zn.java:757) at com.ibm.db2.jcc.am.zn.executeUpdate(zn.java:740) at com.ibm.cdb.topomgr.topobuilder.agents.AliasesCleanupAgent.remo eOrp hanedGuids(AliasesCleanupAgent.java:992) at com.ibm.cdb.topomgr.topobuilder.agents.AliasesCleanupAgent.remo eOrp hanedGuidsInAliases(AliasesCleanupAgent.java:933) at com.ibm.cdb.topomgr.topobuilder.agents.AliasesCleanupAgent.run( lias esCleanupAgent.java:196) .. Or; 2013-06-26 23:10:37,342 TopologyBuilder [TopologyBuilderEngineThread$Cleanup@4.0] ERROR agents.AliasesCleanupAgent - Failed to delete orphaned guids in ALIASES table com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-964, SQLSTATE=57011, SQLERRMC=null, DRIVER=3.63.75 at com.ibm.db2.jcc.am.fd.a(fd.java:682) ..
Problem conclusion
The fix for this APAR is contained in the following maintenance packages: | Fix Pack | 7.2.1.0-TIV-ITADDM-FP006
Temporary fix
Comments
APAR Information
APAR number
IV45588
Reported component name
APP DEPENDENCY
Reported component ID
5724N5500
Reported release
721
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-07-15
Closed date
2013-09-30
Last modified date
2013-09-30
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
APP DEPENDENCY
Fixed component ID
5724N5500
Applicable component levels
R721 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSPLFC","label":"Tivoli Application Dependency Discovery Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"721","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
30 September 2013