IBM Support

IC60845: 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 TSM server on all platforms
    Initial Impact:
    Low
    Additional Keywords:
    MSGANR0162W MSGCLI0110E 22002 tsmdb2 query database format
    detailed zz61 tsm61
    

Local fix

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

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Tivoli Storage Manager server       *
    *                 V6.1.0.0 or V6.1.1.0.                        *
    ****************************************************************
    * PROBLEM DESCRIPTION: See ERROR Description.                  *
    ****************************************************************
    * RECOMMENDATION: Apply the level containing this fix when     *
    *                 available. This problem is currently         *
    *                 projected to be fixed in level 6.1.2.        *
    *                 Note that this is subject to change          *
    *                 at the discretion of IBM.                    *
    ****************************************************************
    *
    

Problem conclusion

  • This issue has been corrected.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC60845

  • 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-04-21

  • Closed date

    2009-05-07

  • Last modified date

    2009-05-07

  • 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

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"61L","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
07 May 2009