IT29808: Expire inventory or "delete filespace" process may be slow to delete data from a container storage pool

8.1.1.400-IBM-SPSRV-AIX
8.1.1.400-IBM-SPSRV-Linuxppc64le
8.1.1.400-IBM-SPSRV-Linuxs390x
8.1.1.400-IBM-SPSRV-Linuxx86_64
8.1.1.400-IBM-SPSRV-WindowsX64
8.1.8.100-IBM-SPSRV-AIX
8.1.8.100-IBM-SPSRV-Linuxppc64le
8.1.8.100-IBM-SPSRV-Linuxs390x
8.1.8.100-IBM-SPSRV-Linuxx86_64
8.1.8.100-IBM-SPSRV-WindowsX64
8.1.8.100-IBM-SPCMS-Linuxx86_64
8.1.8.100-IBM-SPOC-AIX
8.1.8.100-IBM-SPCMS-WindowsI32
8.1.8.100-IBM-SPOC-LinuxPPC64le
8.1.8.100-IBM-SPCMS-WindowsX64
8.1.8.100-IBM-SPOC-Linuxs390x
8.1.8.100-IBM-SPOC-Linuxx86_64
8.1.8.100-IBM-SPOC-WindowsX64
8.1.9.000-IBM-SPOC-AIX
8.1.9.000-IBM-SPSRV-AIX
8.1.9.000-IBM-SPOC-LinuxPPC64le
8.1.9.000-IBM-SPOC-Linuxs390x
8.1.9.000-IBM-SPSRV-Linuxppc64le
8.1.9.000-IBM-SPCMS-Linuxx86_64
8.1.9.000-IBM-SPOC-Linuxx86_64
8.1.9.000-IBM-SPCMS-WindowsI32
8.1.9.000-IBM-SPSRV-Linuxs390x
8.1.9.000-IBM-SPCMS-WindowsX64
8.1.9.000-IBM-SPOC-WindowsX64
8.1.9.000-IBM-SPSRV-Linuxx86_64
8.1.9.000-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 V8.1.1.X interim fix downloads
IBM Spectrum Protect Server V8.1.8.X interim fix downloads
IBM Spectrum Protect Server V8.1 Fix Pack 8 (V8.1.9) Downloads
IBM Spectrum Protect Server V7.1 Fix Pack 10 (7.1.10.000) Downloads

APAR status

• Closed as program error.

Error description

• Executing "Expire inventory" or "delete filespace", the process
  may be slow when processing the container storage pool.
  .
  L2/Customer diagnostics:
  
  A Spectrum Protect Server monitor instrumentation trace shows
  the "expire inventory"  thread was slow processing this SQL:
  
  
  Execution Time: 350.387 sec, Number of Executions: 20825,
  RowsReturned: 20825, Rows Read: 5664360, Sorts: 20825
  SELECT xPoolid, COUNT, SUM( CAST( xSize AS BIGINT ) ) FROM   (
  SELECT COALESCE( sdcl.poolid, sdndl.poolid ) AS xPoolid,
  COALESCE( sdcl.size, sdndl.length ) AS xSize    FROM
  TSMDB1.sd_recon_order AS sdro      LEFT JOIN
  TSMDB1.sd_chunk_locations AS sdcl        ON (
  sdcl.chunkid=sdro.chunkid and chunktype=0 )      LEFT JOIN
  TSMDB1.sd_non_dedup_locations AS sdndl        ON (
  sdndl.chunkid=sdro.chunkid and chunktype=1 )      WHERE
  sdro.objid=?   ) GROUP BY xPoolid FOR READ ONLY WITH UR  --
  694247
  
  
  Platform Version Affected:
  Spectrum Protect Server on all supported version
  .
  TS002513839  performance
  

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 7.1.10, 8.1.1.400,           *
  * 8.1.7.100, 8.1.8.100 and 8.1.9. Note that this is subject to *
  * change at the discretion of IBM.                             *
  ****************************************************************
  

Problem conclusion

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