IBM Support

IT23675: "SELECT * FROM LIBRARIES" FAILS WITH ANR9999D_2215375891 ERROR

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Running "select * from libraries" from the admin command line,
    when a defined library
    has "ZosMedia" option set to a non NULL value, will fail.
    
    ie
    q library f=d
    displays:
    
    ZosMedia: No
    
    Activity log will report for "select * from libraries":
    
    
    ANR9999D_2215375891 DoTheParmBinds(tbcli.c:8334)  Thread<596>:
    Type mismatch 60 != 10 for column 16 for row 116785148.
    ANR9999D Thread<596> issued message 9999 from:
    ANR9999D Thread<596>  0x000000010002f994  StdPutText
    ANR9999D Thread<596>  0x0000000100030618  OutDiagToCons
    ANR9999D Thread<596>  0x000000010000a874  outDiagfExt
    ANR9999D Thread<596>  0x00000001001a39ec  DoTheParmBinds
    ANR9999D Thread<596>  0x000000010019ae34  RdbBindParamsForStmt
    ANR9999D Thread<596>  0x0000000100196a98  RdbCliInsert
    ANR9999D Thread<596>  0x0000000100196574  tbCliSRInsDel
    ANR9999D Thread<596>  0x0000000100794c48  TsmSqlPrepareData
    ANR9999D Thread<596>  0x000000010000dc14  StartThread
    ANR0157W Database operation INSERT for table
    Librariest failed with result code 9991 and tracking ID:
    116785148.
    ANR0158W Database operation INSERT for table
    Librariest failed with operation code 9991 and tracking id
    116785148.
    The data for column 0 is: (string, len=6)0x545334353030.
    ANR0102E admsql.c(5849): Error 9991 inserting row
    in table "Librariest".
    
    "select ZosMedia from libraries" where the ZosMedia value is not
    Null would also error in same manner
    
    Initial Impact: Low
    
    
    Tivoli Storage Manager and IBM Spectrum Protect version
    affected:
    Server 7.1.x and 8.1.x on supported platforms
    
    
    
    
    Additional Keywords:  TSM  Spectrum Protect library select
    dsmadmc
    

Local fix

  • Use "query library f=d"
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Tivoli Storage Manager and IBM Spectrum Protect server   *
    * users of SELECT * FROM LIBRARIES.                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixing level when available.                           *
    * This problem is currently projected to be fixed in levels    *
    * 7.1.9 and 8.1.5.                                             *
    * Note that this is subject to change at the discretion of IBM *
    ****************************************************************
    *
    

Problem conclusion

  • This problem was fixed.
    
    Affected platforms for reported release:  AIX, HP, Solaris,
    Linux, and Windows.
    Platforms fixed:  AIX, HP, Linux, Solaris, and Windows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT23675

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-01-12

  • Closed date

    2018-01-18

  • Last modified date

    2018-01-18

  • 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

  • R63A PSY

       UP

  • R63H PSY

       UP

  • R63L PSY

       UP

  • R63S PSY

       UP

  • R63W PSY

       UP

  • R71A PSY

       UP

  • R71H PSY

       UP

  • R71L PSY

       UP

  • R71S PSY

       UP

  • R71W PSY

       UP

  • R81A PSY

       UP

  • R81L PSY

       UP

  • R81W PSY

       UP



Document information

More support for: Tivoli Storage Manager

Software version: 7.1.3

Reference #: IT23675

Modified date: 18 January 2018