IT21275: RUNSTATS ON TABLE SD_CHUNK_LOCATIONS RUNS CONTINUOUSLY AND HIGHER CPU AND BUSIER DISK READS ARE SEEN

8.1.1.100-IBM-SPSRV-WindowsX64
8.1.1.100-IBM-SPSRV-Linuxx86_64
8.1.1.100-IBM-SPSRV-Linuxs390x
8.1.1.100-IBM-SPSRV-Linuxppc64le
8.1.1.100-IBM-SPSRV-AIX
8.1.3.000-IBM-SPCMS-WindowsX64
8.1.3.000-IBM-SPCMS-WindowsI32
8.1.3.000-IBM-SPCMS-Linuxx86_64
8.1.3.000-IBM-SPOC-WindowsX64
8.1.3.000-IBM-SPOC-Linuxx86_64
8.1.3.000-IBM-SPOC-Linuxs390x
8.1.3.000-IBM-SPOC-LinuxPPC64le
8.1.3.000-IBM-SPOC-AIX
8.1.3.000-IBM-SPSRV-WindowsX64
8.1.3.000-IBM-SPSRV-Linuxx86_64
8.1.3.000-IBM-SPSRV-Linuxs390x
8.1.3.000-IBM-SPSRV-Linuxppc64le
8.1.3.000-IBM-SPSRV-AIX
IBM Spectrum Protect Server V8.1 Fix Pack 3 (V8.1.3) Downloads
IBM Spectrum Protect Server V7.1 Fix Pack 8 (7.1.8.000) Downloads
IBM Spectrum Protect Server V8.1.1.X interim fix downloads

APAR status

• Closed as program error.

Error description

• Runstats on table SD_CHUNK_LOCATIONS runs continuously and this
  causes cpu usage to rise
  and database disks to be busier doing additional reads.
  
  
  "db2 list utilities" will show:
  
  ID                               = 1364373
  Type                             = RUNSTATS
  Database Name                    = TSMDB1
  Member Number                    = 0
  Description                      = TSMDB1.SD_CHUNK_LOCATIONS
  Start Time                       = xx/xx/xxxx 12:45:15.116928
  State                            = Executing
  Invocation Type                  = User
  Throttling:
     Priority                      = Unthrottled
  
  
  Tivoli Storage Manager and IBM Spectrum Protect versions
  affected:
  Server 7.1.3.x and higher, and 8.1.x on all supported platforms
  
  
  Initial Impact: Medium
  
  Additional Keywords:  TSM IBM Spectrum Protect runstats
  container
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Tivoli Storage Manager and 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.8 and 8.1.3. Note that   *
  * this is subject to change at the discretion of IBM.          *
  ****************************************************************
  

Problem conclusion

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