IT31427: DB2SYSC CONSUMES 100% CPU RESULTING IN PERFORMANCE DEGRADATION IN ENVIRONMENTS THAT REPLICATE DEDUPLICATED DATA

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