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

7.1.9.000-TIV-TSMCMS-Windows64
7.1.9.000-TIV-TSMCMS-Windows32
7.1.9.000-TIV-TSMCMS-Linuxx64
7.1.9.000-TIV-TSMOC-LinuxS390
7.1.9.000-TIV-TSMOC-LinuxPPC64
7.1.9.000-TIV-TSMOC-Windows
7.1.9.000-TIV-TSMOC-Linuxx64
7.1.9.000-TIV-TSMOC-AIX
7.1.9.000-TIV-TSMSRV-WIN
7.1.9.000-TIV-TSMSRV-SolarisSPARC
7.1.9.000-TIV-TSMSRV-Linuxx86_64
7.1.9.000-TIV-TSMSRV-Linuxs390x
7.1.9.000-TIV-TSMSRV-Linuxppc64
7.1.9.000-TIV-TSMSRV-HP-UX
7.1.9.000-TIV-TSMSRV-AIX
8.1.5.000-IBM-SPCMS-WindowsX64
8.1.5.000-IBM-SPCMS-WindowsI32
8.1.5.000-IBM-SPCMS-Linuxx86_64
8.1.5.000-IBM-SPOC-WindowsX64
8.1.5.000-IBM-SPOC-Linuxx86_64
8.1.5.000-IBM-SPOC-Linuxs390x
8.1.5.000-IBM-SPOC-LinuxPPC64le
8.1.5.000-IBM-SPOC-AIX
8.1.5.000-IBM-SPSRV-WindowsX64
8.1.5.000-IBM-SPSRV-Linuxx86_64
8.1.5.000-IBM-SPSRV-Linuxs390x
8.1.5.000-IBM-SPSRV-Linuxppc64le
8.1.5.000-IBM-SPSRV-AIX
IBM Spectrum Protect Server V8.1 Fix Pack 5 (V8.1.5) Downloads
IBM Spectrum Protect Server V7.1 Fix Pack 9 (7.1.9.000) Downloads

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 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