IBM Support

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

Subscribe

You can track all active APARs for this component.

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 number

    IT21275

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    81L

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-07-02

  • Closed date

    2017-08-11

  • Last modified date

    2017-09-15

  • 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

  • R71A PSY

       UP

  • R71L PSY

       UP

  • R71S PSY

       UP

  • R71W PSY

       UP

  • R81A PSY

       UP

  • R81L PSY

       UP

  • R81W PSY

       UP



Document information

More support for: Tivoli Storage Manager

Software version: 81L

Reference #: IT21275

Modified date: 15 September 2017