IBM Support

IC98389: SELECT FROM DB RETURNS INCORRECT VALUE FOR PHYSICAL_VOLUMES

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • SQL select from db table returns an incorrect value for the
    physical_volumes column
    
    tsm: >select * from db
    
         DATABASE_NAME: TSMDB1
    TOT_FILE_SYSTEM_MB: 530176
      USED_DB_SPACE_MB: 182688
         FREE_SPACE_MB: 347396
           TOTAL_PAGES: 10975438
          USABLE_PAGES: 10974894
            USED_PAGES: 10966634
            FREE_PAGES: 8260
        BUFF_HIT_RATIO: 98.0
        TOTAL_BUFF_REQ: 4242278326
         SORT_OVERFLOW: 0
         PKG_HIT_RATIO: 99.8
            LAST_REORG: 2013-11-23 23:22:25.000000
        FULL_DEV_CLASS: TAPSST16
       NUM_BACKUP_INCR: 0
      LAST_BACKUP_DATE: 2013-11-27 14:05:16.000000
      PHYSICAL_VOLUMES: 0
    
    PHYSICAL_VOLUMES column shows 0, even it has 4 volumes in QUERY
    DBSPACE outputs.
    
    Location        Total Space(MB)      Used Space(MB)      Free
    Space(MB)
    -----------     ---------------     ---------------
    ---------------
    /tsmdb/db1    132,608.00           45,694.86           86,913.14
    /tsmdb/db2    132,352.00           45,694.70           86,657.30
    /tsmdb/db3    132,608.00           45,695.59           86,912.41
    /tsmdb/db4    132,608.00           45,695.07           86,912.93
    ------------
    
    
    Tivoli Storage Manager Versions Affected:
    
    Tivoli Storage Manager server version 6.x
    
    Customer/L2 Diagnostics (If Applicable)
    
    None
    
    Initial Impact:
    
    Medium
    
    Additional Keywords:
    
    TSM
    

Local fix

  • Issue "select * from dbspace" and then immediately issue "select
    * from db".
    

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 6.3.5 and 7.1.1. Note that this is *
    *                                                              *
    *                 subject to change at the discretion of IBM.  *
    ****************************************************************
    *
    

Problem conclusion

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

Temporary fix

Comments

APAR Information

  • APAR number

    IC98389

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    62A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-12-18

  • Closed date

    2014-04-02

  • Last modified date

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

  • R61A PSY

       UP

  • R61H PSY

       UP

  • R61L PSY

       UP

  • R61S PSY

       UP

  • R61W PSY

       UP

  • R62A PSY

       UP

  • R62H PSY

       UP

  • R62L PSY

       UP

  • R62S PSY

       UP

  • R62W PSY

       UP

  • R63A PSY

       UP

  • R63H PSY

       UP

  • R63L PSY

       UP

  • R63S PSY

       UP

  • R63W PSY

       UP

  • R71A PSY

       UP

  • R71H PSY

       UP

  • R71L PSY

       UP

  • R71S PSY

       UP

  • R71W PSY

       UP



Document information

More support for: Tivoli Storage Manager

Software version: 62A

Reference #: IC98389

Modified date: 03 April 2014