IT30308: EXPIRE INVENTORY PERFORMANCE DEGRADED AFTER UPGRADING TO 8.1.8.000

8.1.9.100-IBM-SPSRV-AIX
8.1.9.100-IBM-SPSRV-Linuxppc64le
8.1.9.100-IBM-SPSRV-Linuxs390x
8.1.9.100-IBM-SPSRV-Linuxx86_64
8.1.9.100-IBM-SPSRV-WindowsX64
8.1.10.000-IBM-SPSRV-AIX
8.1.10.000-IBM-SPSRV-Linuxppc64le
8.1.10.000-IBM-SPSRV-Linuxs390x
8.1.10.000-IBM-SPSRV-Linuxx86_64
8.1.10.000-IBM-SPSRV-WindowsX64
8.1.10.000-IBM-SPCMS-Linuxx86_64
8.1.10.000-IBM-SPCMS-WindowsI32
8.1.10.000-IBM-SPCMS-WindowsX64
8.1.10.000-IBM-SPOC-AIX
8.1.10.000-IBM-SPOC-LinuxPPC64le
8.1.10.000-IBM-SPOC-Linuxs390x
8.1.10.000-IBM-SPOC-Linuxx86_64
8.1.10.000-IBM-SPOC-WindowsX64
IBM Spectrum Protect Server V8.1 Fix Pack (V8.1.10) Downloads

APAR status

• Closed as program error.

Error description

• Server expire inventory performance can be observed to be much
  slower after upgrading to 8.1.8.000.   The issue is caused by a
  new SQL query added to support retention processing.
  
  Spectrum Protect Versions Affected:  All platforms running
  8.1.8.000
  Customer/L2 Diagnostics (If Applicable):
  
  Servermon output will show high execution time on the following
  SQL statement:
  
  Execution Time: 1095.189 sec, Number of Executions: 4,
  RowsReturned: 0, Rows Read: 1465148523
  SELECT 1 FROM TSMDB1.BACKUP_OBJECTS imbk WHERE imbk.NODEID=? AND
  imbk.FSID=? AND imbk.STATE=4 AND NOT EXISTS ( SELECT 1 FROM
  TSMDB1.replicated_objects nrro WHERE nrro.OBJID=imbk.OBJID AND
  nrro.DELETED IS NULL ) AND NOT EXISTS ( SELECT 1 FROM
  TSMDB1.replicating_objects nrrg WHERE nrrg.OBJID=imbk.OBJID )
  FETCH FIRST 1 ROWS ONLY FOR READ ONLY WITH UR -- 1783582
  
  
  Initial Impact::  Medium
  Additional Keywords: TSM ITSM ADSM slow
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All IBM Spectrum Protect server users.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing levels when available.                          *
  * This problem is currently projected to be fixed in levels    *
  * 8.1.9.100 and 8.1.10.                                        *
  * 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