A fix is available
APAR status
Closed as program error.
Error description
The Tivoli Storage Manager server may hang when the QUERY NODEDATA command is issued, where the command is so long that it overflows the SQL buffer. Following message can be seen in server activity log: 08/11/2010 14:29:07 ANR2017I Administrator ADMIN issued command: QUERY NODEDATA COLLOCG=oracle STG=back* (SESSION: 16074) 08/11/2010 14:29:07 ANR9999D_3523178843 bfQueryNodeData(bfcollg.c:1693) Thread<52948>: SQL buffer not large enough for BF statements, need 3717 (SESSION: 16074) The call stack may look like following: #3 0x00000000808a0fa8 in StdPutText ( fmtStr=0x2001bc7e3f8 "ANR9999D_2637115035 pkDestroyMutex(pkmon.c:676) Thread<52937>: Failed to destroy mutex 0x81967ce0:descP->tableMutex rc=16, held=0 by outinit.c:774 2627f950 0.~", argP=0x0, myStream=0x0, msgType=OUTTYPE_MESSAGE) at output.c:5823 #4 0x00000000808a3bce in OutDiagToCons (crc=<value optimized out>, func=0x80bfbab4 "pkDestroyMutex", srcFile=0x80bfb584 "pkmon.c", srcLine=676, diagMsgP=0x83427a53 "Failed to destroy mutex 0x81967ce0:descP->tableMutex rc=16, held=0 by outinit.c:774 2627f950 0.~") at output.c:1190 #5 0x00000000808a6f3c in outDiagfExt (func=<value optimized out>, srcFile=<value optimized out>, srcLine=<value optimized out>, fmtStr=<value optimized out>) at outvarg.c:208 #6 0x000000008091fe9a in pkDestroyMutex (mutexP=0x81967ce0) at pkmon.c:673 #7 0x00000000808b1a0e in outCloseStream (stream=0x81967c78) at outinit.c:1285 #8 0x0000000080776688 in SmAdminSession (sessP=0x82f0fb58) at smadmin.c:1215 #9 0x0000000080656964 in DoAdminGeneral (sessP=0x82f0fb58) at smexec.c:5337 #10 0x000000008065ca56 in smExecuteSession (infoP=<value optimized out>, beginFunc=<value optimized out>, Tivoli Storage Manager Versions Affected: Tivoli Storage Manager server 6.1.x on Linux platform. Initial Impact: Low Additional Keywords: zz61 hang query nodedata sql buffer bf
Local fix
Issue the QUERY COLLOCGROUP command to display a list of nodes in the group. Then issue the QUERY NODEDATA command for each node in the group.
Problem summary
**************************************************************** * USERS AFFECTED: All Tivoli Storage Manager server users. * **************************************************************** * PROBLEM DESCRIPTION: See Error Description. * **************************************************************** * RECOMMENDATION: Apply fixing level when available. This * * problem is currently projected to be fixed * * in levels 6.1.4.2, 6.1.5.0 and 6.2.2.0. * * Note that this is * * subject to change at the discretion of IBM. * **************************************************************** *
Problem conclusion
The problem has been corrected.
Temporary fix
Comments
APAR Information
APAR number
IC70962
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
61L
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-09-09
Closed date
2010-09-16
Last modified date
2010-09-16
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
R61A PSY
UP
R61H PSY
UP
R61L PSY
UP
R61S PSY
UP
R61W PSY
UP
R62A PSY
UP
R62H PSY
UP
R62L PSY
UP
R62S PSY
UP
R62W PSY
UP
[{"Line of Business":{"code":"LOB26","label":"Storage"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"61L"}]
Document Information
Modified date:
16 September 2021