Direct links to fixes
7.1.7.400-TIV-TSMSRV-WIN
7.1.7.400-TIV-TSMSRV-SolarisSPARC
7.1.7.400-TIV-TSMSRV-Linuxx86_64
7.1.7.400-TIV-TSMSRV-Linuxs390x
7.1.7.400-TIV-TSMSRV-Linuxppc64
7.1.7.400-TIV-TSMSRV-HP-UX
7.1.7.400-TIV-TSMSRV-AIX
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.4.000-IBM-SPSRV-Linuxx86_64
8.1.4.000-IBM-SPSRV-WindowsX64
8.1.4.000-IBM-SPSRV-Linuxs390x
8.1.4.000-IBM-SPSRV-Linuxppc64le
8.1.4.000-IBM-SPSRV-AIX
8.1.1.100-IBM-SPSRV-WindowsX64
8.1.1.100-IBM-SPSRV-Linuxx86_64
8.1.1.100-IBM-SPSRV-Linuxs390x
8.1.1.100-IBM-SPSRV-Linuxppc64le
8.1.1.100-IBM-SPSRV-AIX
IBM Spectrum Protect Server V8.1.1.X interim fix downloads
IBM Spectrum Protect Server V8.1 Fix Pack 4 (V8.1.4) Downloads
IBM Spectrum Protect Server V7.1 Fix Pack 9 (7.1.9.000) Downloads
IBM Spectrum Protect Server V7.1.7.X interim fix downloads
APAR status
Closed as program error.
Error description
IBM Spectrum Protect server may not start index reorganization as expected when there is other database activity for the table. Before starting index reorganization, the server will check for database locks that will conflict with index reorganization activity. In some cases the server will incorrectly determine that incompatible locks exist and chose not to begin index reorganization for the table. If this problem is encountered, a server trace with TBREORG trace during reorganization activity will contain lines like the following: 21:06:34.416 Ý241¨Ýtbnsql.c¨Ý1394¨ÝRdbExecuteSQLToStrings¨: Executing sql 'SELECT lock_mode FROM TABLE(MON_GET_LOCKS (CLOB('<lock_mode>IN</lock_mode><table_schema>TSMDB1 </table_schema><table_name>SD_CHUNK_LOCATIONS</table_name>') ,-1 )) FETCH FIRST 1 ROW ONLY '. 21:06:34.755 Ý241¨Ýtbnsql.c¨Ý1442¨ÝRdbExecuteSQLToStrings¨:1 rows found. 21:06:34.755 Ý241¨Ýtbreorg.c¨Ý3805¨ÝCheckForIncompatibleLocks¨: Found an incompatible lock from db2 for SD.Chunk.Locations-SD_CHUNK_LOCATIONS. Check for both of the following: -1- SELECT lock_mode FROM TABLE(MON_GET_LOCKS(CLOB('<lock_mode>IN </lock_mode> -2- Found an incompatible lock from db2 Tivoli Storage Manager Versions Affected: All Tivoli Storage Manager servers 7.1.1.200 and higher All IBM Spectrum Protect servers 8.1 and higher Initial Impact: Medium Additional Keywords: TSM Tivoli Storage Manager IN lock indexes indices reorg
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Tivoli Storage Manager and IBM Spectrum Protect server * * users. * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * Apply fixing level when available. This problem is currently * * projected to be fixed in levels 7.1.9, 8.1.1.100, and 8.1.4. * * 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-UX, Solaris, Linux, and Windows. Platforms fixed: AIX, HP-UX, Solaris, Linux, and Windows.
Temporary fix
Comments
APAR Information
APAR number
IT23014
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
81L
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-11-02
Closed date
2017-11-06
Last modified date
2017-11-16
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
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:
28 September 2021