IBM Support

IT20115: "QUERY STGPOOL" SHOWS INCORRECT DEDUP AND COMPRESSION STATISTICSFOR DIRECTORY-CONTAINER STORAGE POOLS

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The " QUERY STGPOOL" server command may not show the correct
    inline dedup and compression statistics for  directory-container
    storage pools, erroneously reporting all these values as zero
    (percentage) like in the following example:
    
    
             Storage Pool Name: DIRCONTPOOL
                         Storage Pool Type: Primary
                              Storage Type: DIRECTORY
                       .......
                     Deduplication Savings: 0 (0%)
                       Compression Savings: 0 (0%)
                         Total Space Saved: 0 (0%)
    
    
    
    The problem will occur when the directory-container storage pool
    has a large set of un-referenced data extents or received a very
    large amount of data extents from another server through the
    "PROTECT STGPOOL" process.
    
    This can be verified by the following DB2 select:
    
    db2 "select * from sd_pool_clusters where ck1=0 and ck2=0"
    
    
    In such a case, the output will look like:
    
    
    POOLID                         7
    CK1                            0
    CK2                            0
    NUMFILES                       12345678
    NUMCHUNKS                      0
    PHYSOCCUPANCY                  203184914921999
    RPTOCCUPANCY                   112231614039999
    COMPRSAVED                     50575439960374
    PROT_TOTAL                     118781352050200
    UNREF_TOTAL                    6350396232437
    SNAPSHOT_DATE                  2017-02-24-02.42.54.999999
    
    1 record(s) selected.
    
    
    As for above sample, if the output shows PHYOCCUPANCY larger
    than RPTOCCUPANCY, then this APAR applies.
    
    
    
    
    IBM Spectrum Protect versions affected:
    Servers  7.1.3 and above, and 8.1.x on supported platforms
    
    
    
    
    Initial Impact:
    Medium
    
    
    
    
    Additional Keywords:
    TSM "Spectrum Protect" directory container dedup saving zero
    percent wrong "Q STGPOOL"
    

Local fix

Problem summary

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

Problem conclusion

  • This problem was fixed.
    Affected platforms:  AIX, Linux, Solaris and Windows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT20115

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-04-07

  • Closed date

    2017-04-13

  • Last modified date

    2017-04-13

  • 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: 7.1.3

Reference #: IT20115

Modified date: 13 April 2017