APAR status
Closed as program error.
Error description
During server startup, the initial status collection may encounter errors related to a missing ASSOCIATIONS view. The problem is timing related and may not occur on every server startup. L2/Customers diagnostics: The Tivoli Storage Manager activity log shows the following messages: ANR1959I Status monitor collecting current data at <time> ANR9999D_3831306406 ReportSQLDiagInfo(dbieval.c:1568) Thread<7>: Missing sqlState=56098, sqlCode=-727 from table. Returning rc = 9994. ANR9999D Thread<7> issued message 9999 from: ANR9999D Thread<7> 000007FEEDAB0825 OutDiagToCons()+155 ANR9999D Thread<7> 000007FEEDAAA75C outDiagfExt()+10c ANR9999D Thread<7> 000007FEED847930 ReportSQLDiagInfo()+2a0 ANR9999D Thread<7> 000007FEED8468F1 DbiEvalSQLOutcomeX()+4f1 ANR9999D Thread<7> 000007FEED822AA3 tbRegExecEx()+4c3 ANR9999D Thread<7> 000007FEED4CB31C csGetLastResultForNode()+2ec ANR9999D Thread<7> 000007FEED2B4123 IsNodeAtRisk()+113 ANR9999D Thread<7> 000007FEED28F881 admMonitorNodes()+a81 ANR9999D Thread<7> 000007FEED66A9AA StatusMonitorThread()+67a ANR9999D Thread<7> 000007FEED1D707C startThread()+13c ANR9999D Thread<7> 000007FEF94C3FEF beginthreadex()+107 ANR9999D Thread<7> 000007FEF94C4196 endthreadex()+192 ANR9999D Thread<7> 000000007696652D BaseThreadInitThunk()+d ANR9999D Thread<7> 0000000076D4C521 RtlUserThreadStart()+21 ANR0162W Supplemental database diagnostic information: -1:56098:-727 ([IBM][CLI Driver][DB2/LINUXX8664] SQL0727N An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE "-204", SQLSTATE "42704" and message tokens "TSMDB1.ASSOCIATIONS". SQLSTATE=56098). ANR0993I Server initialization complete. ************************** Tivoli Storage Manager Versions Affected: Tivoli Storage Manager Sever 6.3.4.x and 7.1.0.x on all supported platforms. Initial Impact: Low Additional Keywords: association start startup failure error collection monitor TSM
Local fix
No action is required - the error can be safely ignored. Subsequent status collections will not encounter the error because the ASSOCIATIONS view will have been created before the next collection.
Problem summary
**************************************************************** * USERS AFFECTED: * * All Tivoli Storage Manager Operation Center users. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description. * **************************************************************** * RECOMMENDATION: * * Apply fixing level when available. This problem is * * currently projected to be fixed in levels 6.3.5 and 7.1.1. * * Note that this is subject to change at the discretion of * * IBM. * ****************************************************************
Problem conclusion
The problem was fixed. Affected Platforms: AIX, HP-UX, Solaris, Linux, and Windows.
Temporary fix
Comments
APAR Information
APAR number
IT03272
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
63W
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-07-21
Closed date
2014-07-21
Last modified date
2014-07-21
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
TSM SERVER
Fixed component ID
5698ISMSV
Applicable component levels
R63A PSY
UP
R63H PSY
UP
R63L PSY
UP
R63S PSY
UP
R63W PSY
UP
R71A PSY
UP
R71H PSY
UP
R71L PSY
UP
R71S PSY
UP
R71W PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"63W","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
21 July 2014