IT35703: CLIENT OPERATION SLOWDOWN IF DESTINATION STORAGE POOL CONTAINS MANY DAMAGED CHUNKS ON 8.1.11 SERVER

8.1.12.200-IBM-SPSRV-WindowsX64
8.1.12.200-IBM-SPSRV-Linuxx86_64
8.1.12.200-IBM-SPSRV-Linuxs390x
8.1.12.200-IBM-SPSRV-Linuxppc64le
8.1.12.200-IBM-SPSRV-AIX
IBM Spectrum Protect Server V8.1 Fix Pack 13 (V8.1.13) Downloads
IBM Spectrum Protect Server V8.1.12.X interim fix downloads

APAR status

• Closed as program error.

Error description

• After applying version 8.1.11 of the Spectrum Protect server,
  client backup and restore operations can be severely slowed down
  when the destination pool contains a large number of damaged
  chunks.
  A change was introduced with IT33767 which modified the way
  database tables are scanned and has had a negative effect on
  performance in presence of large number of damaged chunk
  entries.
  
  Customer/Support Diagnostics:
  
  When collecting performance data using the servermon feature,
  client session threads will be spending most of their time in
  DB2 Reg Exec category running an SQL query like
  SELECT 1 FROM TSMDB1.sd_dedup_audit sdda WHERE
   sdda.recoverystatus!=3 AND sdda.type=1 AND sdda.poolid=? AND
   EXISTS(SELECT 1 FROM TSMDB1.sd_all_chunks sdac WHERE
    sdac.chunkid=sdda.id) FETCH FIRST ROW ONLY OPTIMIZE FOR 1 ROW
  
  =====================
  
  Spectrum Protect Versions Affected:
  Spectrum Protect Server version 8.1.11 on all supported
  platforms
  
  | MDVREGR 8.1.11.0-TIV_5698ISMSV |
  
  Initial Impact: Medium
  
  Additional Keywords:
  TS004685292 slowdown IT33767
  

Local fix

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 8.1.12.200 and 8.1.13. Note  *
  * that this is subject to change at the discretion of IBM.     *
  ****************************************************************
  

Problem conclusion

• This problem was fixed.
  Affected platforms for reported release:  AIX, Linux, and
  Windows.
  Platforms fixed:  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

• R81A PSY

     UP