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 number
IC75973
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
62L
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-04-23
Closed date
2011-06-03
Last modified date
2013-08-21
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
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"62L","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
21 August 2013