IC67932: TIVOLI STORAGE MANAGER SERVER MAY FAIL WITH ANR9999D_3749014485

Subscribe

You can track all active APARs for this component.

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 number

    IC67932

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    61A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-04-16

  • Closed date

    2010-05-14

  • Last modified date

    2010-05-14

  • 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



Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli Storage Manager

Software version:

61A

Reference #:

IC67932

Modified date:

2010-05-14

Translate my page

Machine Translation

Content navigation