IC63718: TSM Q DB F=D OR SELECT * FROM DB CAN FAIL WITH ANR0162W AND CLI0110E

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When issuing QUERY DB F=D or SELECT * from DB, this error can
    occur:
    -
    4/7/2009 12:42:39 PM ANR0162W Supplemental database diagnostic
    information: -1:22002:-99999 (■IBM■CLI Driver CLI0110E
    Invalid output or indicator buffer specified. SQLSTATE=22002).
    -
    This error is intermittent and may persist for a period of
    time, or it may not occur again.
    .
    TSM Versions Affected:
    6.1.2 TSM server on all platforms
    Initial Impact:
    Low
    Additional Keywords:
    MSGANR0162W MSGCLI0110E 22002 tsmdb2 query database format
    detailed zz61 tsm61
    MDVPARTL 6.1.2 IC60845
    

Local fix

  • There is no known work around at this time. If the error
    persists, restarting the TSM and DB2 software might solve this
    problem.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Tivoli Storage Manager server users      *
    *                 issuing QUERY DB F=D command.                *
    ****************************************************************
    * PROBLEM DESCRIPTION: See ERROR DESCRIPTION.                  *
    ****************************************************************
    * RECOMMENDATION: Apply fixing level when available. This      *
    *                 problem is currently projected to be fixed   *
    *                 in level 6.1.3. 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

    IC63718

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    61L

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-10-12

  • Closed date

    2009-11-02

  • Last modified date

    2009-11-02

  • 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



Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli Storage Manager

Software version:

61L

Reference #:

IC63718

Modified date:

2009-11-02

Translate my page

Machine Translation

Content navigation