IBM Support

IT23898: THE TSM SUITE FOR UNIFIED RECOVERY CAPACITY REPORT SHOWS 0 TB

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The TSM Suite for Unified Recovery capacity report, created by
    the macro 'tsm_tb_cap_v713.macro', incorrectly shows 0 TB in the
    primary storage pools. For example:
    
    
    Data Managed by TSM Suite for Unified Recovery
    TB within PRIMARY storage pools:   0
    
    
    This is due to an overflow error by the underlying SQL
    statement.
    
    
    Customer/L2 Diagnostics:
    
    
    Running the macro's SQL from the Spectrum Protect administrative
    command line will reproduce the overflow error-
    
    
    TSM> SELECT node_name,CAST(FLOAT(SUM(physical_mb)) / 1024 AS
    DEC(10,1))as "Space in GB", SUM (num_files) as "Number of files"
    FROM occupancy GROUP BY node_name
    
    ANR0162W Supplemental database diagnostic information:
    -1:22003:-413 ([IBM][CLI Driver][DB2/AIX64] SQL0413N
    Overflow occurred during numeric data type conversion.
    SQLSTATE=22003).
    

Local fix

Problem summary

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

Problem conclusion

  • This problem was fixed.
    Affected platforms for reported release:  AIX, HP-UX, Solaris,
    Linux, and Windows.
    Platforms fixed:  AIX, HP-UX, Solaris, Linux, and Windows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT23898

  • 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

    2018-02-08

  • Closed date

    2018-05-13

  • Last modified date

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

  • R71H 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 #: IT23898

Modified date: 13 May 2018