IC75973: SELECT * FROM DB MAY SHOW A NEGATIVE VALUE FOR TOTAL_BUFF_REQ

APAR status

• Closed as program error.

Error description

• Running a select against the db table from dsmadmc, may show a
  negative value for TOTAL_BUFF_REQ,
  whereas q db f=d shows it correctly.
  
  For example;
  
  q db f=d
  
                   Database Name: TSMDB1
  Total Size of File System (MB): 8,388,608
      Space Used by Database(MB): 28,928
       Free Space Available (MB): 8,308,456
                     Total Pages: 2,502,777
                    Usable Pages: 2,502,641
                      Used Pages: 2,492,757
                      Free Pages: 9,884
           Buffer Pool Hit Ratio: 99.7
           Total Buffer Requests: 6,653,153,614
                  Sort Overflows: 0
         Package Cache Hit Ratio: 100.0
    Last Database Reorganization:
          Full Device Class Name: DBBACKUP_CLASS
    Incrementals Since Last Full: 0
  Last Complete Backup Date/Time: 04/18/2011 05:00:25
  
  
  SELECT * FROM DB
  
       DATABASE_NAME: TSMDB1
  TOT_FILE_SYSTEM_MB: 8388608
    USED_DB_SPACE_MB: 28928
       FREE_SPACE_MB: 8308456
         TOTAL_PAGES: 2502777
        USABLE_PAGES: 2502641
          USED_PAGES: 2492757
          FREE_PAGES: 9884
      BUFF_HIT_RATIO: 99.7
      TOTAL_BUFF_REQ: -1936780952
       SORT_OVERFLOW: 0
       PKG_HIT_RATIO: 100.0
          LAST_REORG:
      FULL_DEV_CLASS: DBBACKUP_CLASS
     NUM_BACKUP_INCR: 0
    LAST_BACKUP_DATE: 2011-04-18 05:00:25.000000
    PHYSICAL_VOLUMES: 0
  
  There is no error message logged in the activity for the select
  command.
  
  
  Initial Impact:
  Medium
  .
  Tivoli Storage Manager Versions Affected:
  All 6.1 and 6.2 Tivoli Storage Manager Servers.
  .
  Additional Keywords:
  TSM ZZ61 ZZ62  select Total Buffer Requests TOTAL_BUFF_REQ
  column length
  

Local fix

• Use q db f=d output
  

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 level and 6.2.3.                          *
  *                 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