IC67932: TIVOLI STORAGE MANAGER SERVER MAY FAIL WITH ANR9999D_3749014485

IBM Tivoli Storage Manager V6.1 Fix Pack 4 (6.1.4) Server Downloads

APAR status

• Closed as program error.

Error description

• Tivoli Storage Manager Server may fail with
  ANR9999D_3749014485 BuildStmtOrderClause(tbcli.c:6999)
  Thread<13263>: Invalid settings in stmtHdlP 0 0 0 0
  .
  Customer/L2 Diagnostics
  .
  Example from a Tivoli Storage Manager Server actlog of
  DELETE FILESPACE command version 6.1.3.2 on AIX:
  .
  ANR9999D_3749014485 BuildStmtOrderClause(tbcli.c:6999)
   Thread<22800>: Invalid settings in stmtHdlP 0 0 0 0.
  ANR9999D Thread<22800> issued message 9999 from:
  ANR9999D Thread<22800>  0x0000000100012d50 StdPutText
  ANR9999D Thread<22800>  0x000000010001387c OutDiagToCons
  ANR9999D Thread<22800>  0x000000010000ebdc outDiagfExt
  ANR9999D Thread<22800>  0x00000001000b4310 BuildStmtOrderClause
  ANR9999D Thread<22800>  0x00000001000b1530 BuildStmt
  ANR9999D Thread<22800>  0x00000001000abf00
    RdbPrepareAndExecuteStmt
  ANR9999D Thread<22800>  0x00000001000a6c38 RdbCliFetch
  ANR9999D Thread<22800>  0x00000001000a5b68 tbCliSRFetch
  ANR9999D Thread<22800>  0x0000000100696d98 DeleteFileSpace
  ANR9999D Thread<22800>  0x00000001006910dc imFSDeletionThread
  ANR9999D Thread<22800>  0x0000000100009bb4 StartThread
  ANR0162W Supplemental database diagnostic information:
    1:42601:-104 ([IBM][CLI Driver][DB2/AIX64]
    SQL0104N  An unexpected token "FIRST" was found following
    "D=?) ORDER BY  FETCH".  Expected tokens may include:
    "FETCH". SQLSTATE=42601).~
  .
  Tivoli Storage Manager Versions Affected:
  Tivoli Storage Manager  server 6.1 and 6.2 on all platforms
  .
  Initial Impact:
  medium
  .
  Additional Keywords:
  zz61 zz62 TSM DB2 BuildStmtOrderClause invalid stmtHdlP
  

Local fix

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.0 and 6.2.2. Note that this  *
  *                                                              *
  *                 is subject to change at the discretion of    *
  *                 IBM.                                         *
  ****************************************************************
  *
  

Problem conclusion

• This problem was fixed.
  Affected platforms:  AIX, HP-UX, Sun Solaris, Linux, and
  Windows.
  

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