IC98389: SELECT FROM DB RETURNS INCORRECT VALUE FOR PHYSICAL_VOLUMES

IBM Tivoli Storage Manager V6.3 Fix Pack 5 (6.3.5.000) Server Downloads

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