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

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

• 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.
  
  
    NOTE: You can determine value for pool_id from:
          'show sspool'  which displays storage pool name and
          pool_id in () after name.
          or from 'show sdpool' which also displays stgpool name
          and pool_id in () after name.
  
          ie STG_POOL_NAME(xx)    so xx is pool_id
  

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