IC70962: TIVOLI STORAGE MANAGER SERVER MAY HANG WITH LONG QUERY NODEDATA COMMAND

IBM Tivoli Storage Manager (TSM) server V6.1.4.x interim fix downloads

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 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