Direct links to fixes
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 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
Modified date:
27 September 2021