IBM Support

IT21134: COMPRESSION SAVINGS IN QUERY STGPOOL OUTPUT AND OPERATIONS CENTER CONTAINER DETAILS IS 0% OR VALUE MUCH LESS THAN EXPECTED.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Due to a calculation error, when using the QUERY STGPOOL
    command, or viewing the details of the pool within the
      Operations Center, the COMPRESSION SAVINGS report 0%.
    
      Using the command:
    
        QUERY STGPOOL <stgpool name> FORMAT=DETAIL
    
      Results:
      is being hit. If the value is small or a negative number
      then you will want the fix for this APAR:
    
        db2 connect to tsmdb1
        db2 set schema tsmdb1
        db2 "select COMPRSAVED from tsmdb1.SD_POOL_CLUSTERS where
         CK1=0 AND CK2=0"
    Initial Impact: Low|Medium|High
      Low
    Additional Keywords:
      OC GUI REPORTING CONTAINER SAVINGS COMPRESSION
    

Local fix

  • The following SQL will update the values:
    
      db2 connect to tsmdb1
      db2 set schema tsmdb1
      db2 "update TSMDB1.SD_POOL_CLUSTERS set
        COMPRSAVED=(SELECT COALESCE(SUM(CAST(SIZE AS BIGINT)),0) -
        COALESCE(SUM(CAST(LENGTH AS BIGINT)-128),0)
        FROM TSMDB1.SD_CHUNK_LOCATIONS WHERE POOLID=pool_id
        AND BITAND( FLAGS, 50 )>0) WHERE POOLID=pool_id
        AND CK1=0 AND CK2=0"
    
      NOTE: The above SQL will need to be updated. You will
            need to determine the "pool_id" for your storage
            pool.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All IBM Tivoli Storage Manager server 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

    IT21134

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    81A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-06-22

  • Closed date

    2017-08-03

  • Last modified date

    2017-08-03

  • 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: 81A

Reference #: IT21134

Modified date: 03 August 2017