IBM Support

IT13811: TIVOLI STORAGE MANAGER SERVER RUNNING "SELECT * FROM STGPOOLS" FAILS WITH ANR0162W

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Problem Description:
    
    Intermittent issue with "select * from STGPOOLS" sometimes fails
    with the following errors:-
    
    ANR2017I Administrator ADMIN issued command: select * from
    stgpools (SESSION: 90336)
    ANR0162W Supplemental database diagnostic information:
    -1:22003:-302 ([IBM][CLI Driver][DB2/LINUXX8664] SQL0302N The
    value of a host variable in the EXECUTE or OPEN statement is out
    of range for its corresponding use. SQLSTATE=22003). (SESSION:
    90336)
    ANR0157W Database operation INSERT for table Stgpools.SQL failed
    with result code 2343 and tracking ID: 0x21dc668. (SESSION:
    90336)
    ANR0158W Database operation INSERT for table Stgpools.SQL failed
    with operation code 2343 and tracking id 0x21dc668. The data for
    column 0 is: (string, len=6)0x46422D523131. (SESSION: 90336)
    ANR0102E admsql.c(5811): Error 2343 inserting row in table
    "Stgpools.SQL". (SESSION: 90336)
    
    
    Customer/L2 Diagnostics:
    
    A trace using classes SQL DBSTMT SSPOOL shows
    
    09:41:51.974 [497720][afqry.c][334][AfQryPoolStatus]:FILE pool
    FB-R11(9), migOccMB=0.000000 migCapMB=0.000000 migOcc=927091320,
    migCapacity=3292528640000,  pctMigrMB=-nan,
    
    The migOccMB and migCapMB are zero but the migOcc and the
    migCapacity are non-zero which is resulting in this issue.
    
    At the time of the problem Query Storage may show very high
    values for Pct Mgr for the affected pool, in our case this was
    over 14 billion.
    
    Tivoli Storage Manager Versions Affected:   6.3.x and 7.1.x on
    all supported platforms
    
    
    Initial Impact:
    Low
    
    Additional Keywords:
    TSM  IBM Spectrum Protect
    

Local fix

  • You may be able to successfully run the select command at a
    later time, after data has been migrated from the stgpool
    

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

Problem conclusion

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

Temporary fix

Comments

APAR Information

  • APAR number

    IT13811

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71L

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-02-17

  • Closed date

    2016-06-24

  • Last modified date

    2016-06-24

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  • dsmserv
    

Fix information

  • Fixed component name

    TSM SERVER

  • Fixed component ID

    5698ISMSV

Applicable component levels

  • R71A PSY

       UP

  • R71H PSY

       UP

  • R71L PSY

       UP

  • R71S PSY

       UP

  • R71W PSY

       UP



Document information

More support for: Tivoli Storage Manager

Software version: 7.1.3

Reference #: IT13811

Modified date: 24 June 2016