IT25224: COLLECTING CONTAINER STORAGE POOL STATISTICS CAN RESULT IN INCREASED TEMP SPACE USAGE AND PERFORMANCE DROP

8.1.9.000-IBM-SPSRV-WindowsX64
8.1.9.000-IBM-SPSRV-Linuxx86_64
8.1.9.000-IBM-SPOC-WindowsX64
8.1.9.000-IBM-SPCMS-WindowsX64
8.1.9.000-IBM-SPSRV-Linuxs390x
8.1.9.000-IBM-SPCMS-WindowsI32
8.1.9.000-IBM-SPOC-Linuxx86_64
8.1.9.000-IBM-SPCMS-Linuxx86_64
8.1.9.000-IBM-SPSRV-Linuxppc64le
8.1.9.000-IBM-SPOC-Linuxs390x
8.1.9.000-IBM-SPOC-LinuxPPC64le
8.1.9.000-IBM-SPSRV-AIX
8.1.9.000-IBM-SPOC-AIX
IBM Spectrum Protect Server V8.1 Fix Pack 8 (V8.1.9) Downloads

APAR status

• Closed as program error.

Error description

• The following SQL (delivered via IT22928) can
  cause issues when there are many records in the related tables.
  Executing the
  statement can result in excessive usage of temporary tablespace
  and affect overall server operation.
  
  SELECT SUM( CAST( sdac.length as bigint ) ) FROM
  TSMDB1.sd_all_chunks
  sdac  WHERE poolid=? AND refcount=1  AND NOT EXISTS( SELECT 1
  FROM
  TSMDB1.sd_recon_order sdro  WHERE sdro.chunkid=sdac.chunkid
  and sdro.chunktype=sdac.chunktype ) FOR READ ONLY WITH UR
  
  The SQL command is used to  calculate the total size of data in
  a pool which is replicated from remote servers and not
  referenced locally.
  
  The output from the statement is used to populate the
  QUERY STG F=D column for
  Space Used for Protected Data.
  
  When there are many records in the related tables, executing the
  statement can result in excessive usage of temporary tablespace
  and affect overall server operation.
  
  To confirm the APAR collect data using the server monitoring
  script "Perl script to collect IBM Spectrum Protect server
  monitoring data", in the *-db2.txt files you can find the
  statement listed under the output collected at the end of the
  file:
  
  ELAPSED_TIME_SEC STATE STMT_TEXT
  ---------------- ----- ---------- ..
  ----------------------------
             76978 EXEC  SELECT SUM( CAST( sdac.length as bigint )
  ) FROM TSMDB1.sd_all_chunks
  sdac  WHERE poolid=? AND refcount=1  AND NOT EXISTS( SELECT 1
  FROM
  TSMDB1.sd_recon_order sdro  WHERE sdro.chunkid=sdac.chunkid
  and sdro.chunktype=sdac.chunktype ) FOR READ ONLY WITH UR -- 349
  
  
  Initial Impact: Medium
  
  IBM Spectrum Protect versions affected:
  Server  7.1.9.x and higher, and 8.1.5.x and higher on all
  supported platforms
  
  | MDVPARTL 7.1.9.0-TIV_5698MSV | (IT22928)
  | MDVPARTL 8.1.5.0-TIV_5698MSV | (IT22928)
  
  Keywords:
  TSM TS000974571 temp space usage
  

Local fix

• Contact IBM support for instructions to implement a local fix
  or
  Restart server
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All IBM Spectrum Protect server users of container type      *
  * storage pools.                                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in level 8.1.9.                        *
  *                                                              *
  * 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, 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