Direct links to fixes
7.1.7.400-TIV-TSMSRV-AIX
7.1.7.400-TIV-TSMSRV-HP-UX
7.1.7.400-TIV-TSMSRV-Linuxppc64
7.1.7.400-TIV-TSMSRV-Linuxs390x
7.1.7.400-TIV-TSMSRV-Linuxx86_64
7.1.7.400-TIV-TSMSRV-SolarisSPARC
7.1.7.400-TIV-TSMSRV-WIN
8.1.6.000-IBM-SPSRV-AIX
8.1.6.000-IBM-SPSRV-Linuxppc64le
8.1.6.000-IBM-SPSRV-Linuxs390x
8.1.6.000-IBM-SPSRV-Linuxx86_64
8.1.6.000-IBM-SPSRV-WindowsX64
8.1.6.000-IBM-SPOC-AIX
8.1.6.000-IBM-SPOC-LinuxPPC64le
8.1.6.000-IBM-SPOC-Linuxs390x
8.1.6.000-IBM-SPOC-Linuxx86_64
8.1.6.000-IBM-SPOC-WindowsX64
8.1.6.000-IBM-SPCMS-Linuxx86_64
8.1.6.000-IBM-SPCMS-WindowsI32
8.1.6.000-IBM-SPCMS-WindowsX64
7.1.9.100-TIV-TSMSRV-AIX
7.1.9.100-TIV-TSMSRV-HP-UX
7.1.9.100-TIV-TSMSRV-Linuxppc64
7.1.9.100-TIV-TSMSRV-Linuxs390x
7.1.9.100-TIV-TSMSRV-Linuxx86_64
7.1.9.100-TIV-TSMSRV-SolarisSPARC
7.1.9.100-TIV-TSMSRV-WIN
8.1.6.100-IBM-SPSRV-Linuxppc64le
8.1.6.100-IBM-SPSRV-AIX
8.1.6.100-IBM-SPSRV-Linuxs390x
8.1.6.100-IBM-SPSRV-Linuxx86_64
8.1.6.100-IBM-SPSRV-WindowsX64
7.1.10.000-TIV-TSMSRV-AIX
7.1.10.000-TIV-TSMSRV-HP-UX
7.1.10.000-TIV-TSMSRV-Linuxppc64
7.1.10.000-TIV-TSMSRV-Linuxs390x
7.1.10.000-TIV-TSMSRV-Linuxx86_64
7.1.10.000-TIV-TSMSRV-SolarisSPARC
7.1.10.000-TIV-TSMSRV-WIN
IBM Spectrum Protect Server V7.1.7.X interim fix downloads
IBM Spectrum Protect Server V8.1 Fix Pack 6 (V8.1.6) Downloads
IBM Spectrum Protect Server V7.1.9.X interim fix downloads
IBM Spectrum Protect Server V8.1.6.X interim fix downloads
IBM Spectrum Protect Server V7.1 Fix Pack 10 (7.1.10.000) Downloads
APAR status
Closed as program error.
Error description
Running a select command from dsmadmc on v7.1 or 8.1 server against a table that is using a staging table and not a view, can cause the server to crash, if a row is greater than 32K. This doesn't affect running a similar select from the DB2 command prompt. dbx on AIX shows: RdbBindParamsForStmt(??, ??, ??, ??, ??, ??) at 0x100188928 RdbCliInsert(??, ??, ??, ??, ??) at 0x100184960 tbCliSRInsDel(??, ??, ??, ??, ??, ??, ??) at 0x100184430 TsmSqlPrepareData(??) at 0x1008f1924 StartThread(0x0) at 0x10000da90 or malloc_y.splay(u = 0x000000012c8efc60, v = 0x000000012c8effc0, heap = 0x09001000a00ab6c0), line 628 in "malloc_y.c" free_y(ptr = 0x000000012c8efc70, flags = 0), line 1623 in "malloc_y.c" free_common(ptr = 0x000000012c8efc70), line 2610 in "malloc_common.c" pkFreeTracked(??, ??, ??, ??) at 0x100004514 OutPopDataBlock(??) at 0x10039b794 outGetNext(??, ??, ??) at 0x100026f0c TsmSqlPrepareData(??) at 0x10065a5d4 StartThread(0x0) at 0x10000d670 TsmSqlPrepareData() is the important function to match this defect. One known case is using a very long "Client Access Privilege" list in the ADMINS table that causes a column to be greater than 24K, and can be seen with "q admin f=d", such that running "select ADMIN_NAME, REG_ADMIN, CONTACT from ADMINS" can cause this type of crash. This large column caused the row to be greater than 32K in size and thus a crash occurred "SHOW ADMINSQL" can be used to see what tables are affected. If the column "Staged" is true then that table "could" cause a crash when select is run against it and the row can be greater than 32K. Initial Impact: Medium Tivoli Storage Manager and IBM Spectrum Protect Versions Affected: Space Management Server v7.1 and v8.1 on supported platforms Additional Keywords: TSM Spectrum Protect abend crash core fails staging
Local fix
Do not run the failing select command
Problem summary
**************************************************************** * USERS AFFECTED: * * All 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.100, 7.1.10 and 8.1.6. * * 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
IT23092
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
2017-11-09
Closed date
2018-09-11
Last modified date
2018-09-11
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
Document Information
Modified date:
06 September 2023