Direct links to fixes
8.1.10.000-IBM-SPOC-WindowsX64
8.1.10.000-IBM-SPOC-Linuxx86_64
8.1.10.000-IBM-SPOC-Linuxs390x
8.1.10.000-IBM-SPOC-LinuxPPC64le
8.1.10.000-IBM-SPOC-AIX
8.1.10.000-IBM-SPCMS-WindowsX64
8.1.10.000-IBM-SPCMS-WindowsI32
8.1.10.000-IBM-SPCMS-Linuxx86_64
8.1.10.000-IBM-SPSRV-WindowsX64
8.1.10.000-IBM-SPSRV-Linuxx86_64
8.1.10.000-IBM-SPSRV-Linuxs390x
8.1.10.000-IBM-SPSRV-Linuxppc64le
8.1.10.000-IBM-SPSRV-AIX
IBM Spectrum Protect Server V8.1 Fix Pack (V8.1.10) Downloads
APAR status
Closed as program error.
Error description
The db2sysc process is constantly consuming all CPU resources and the Spectrum Protect server has no active process at that time. In addition high usage of paging space, reaching up to 70% can be observed. If Spectrum Protect Server process dsmserv is stopped, the DB2 process db2sysc CPU usage drops to 0. From the output of instrumentation in servermon, or manually collecting instrumentation with the "inst end" command, if the SQL output shows the following delete SQL execution time against the sd_replicating_chunks table is more than half the instrumentation interval then this problem may exist. Example: Instrumentation began 11:06:08.971 ended 11:25:57.111 elapsed 1188.140 .... ---------------------------------------------------------------- -------------- Execution Time: 1071.663 sec, Number of Executions: 2629, RowsReturned: 0 DELETE FROM TSMDB1.sd_replicating_chunks WHERE chunkid IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) -- 73 ---------------------------------------------------------------- -------------- In the above case, the SQL execution time of 1071.663 seconds is much more than half of 1188.140 seconds. Spectrum Protect Versions Affected: Spectrum Protect Server 8.1.7.0 and above on all platforms Initial Impact: Medium Special Activity: | MDVREGR 8.1.7.0-TIV_5698ISMSV | Additional Keywords: Spectrum Protect; db2sysc; high CPU; performance degradation; TS003115728
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All IBM Spectrum Protect server users that use bidirectional * * PROTECT STGPOOL commands * **************************************************************** * PROBLEM DESCRIPTION: * * See error description * **************************************************************** * RECOMMENDATION: * * Apply fixing level when available. This problem is * * currently projected to be fixed in level 8.1.10 and above. * ****************************************************************
Problem conclusion
This problem was fixed. Affected platforms: AIX, Linux, and Windows
Temporary fix
Comments
APAR Information
APAR number
IT31427
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
81A
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-01-21
Closed date
2020-02-19
Last modified date
2020-02-19
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
R81L PSY
UP
R81W PSY
UP
R81A PSY
UP
[{"Line of Business":{"code":"LOB26","label":"Storage"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"81A"}]
Document Information
Modified date:
15 September 2021