home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC75280 Status: Closed

HISTORICAL ANALYSIS OF A TABLESPACE HAS TOTAL SIZE SHOWING AS NEGATIVE
VALUE IN CONTROL CENTER

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
The calculation for Total Size is: 
Total Size(in bytes) = totalPages in bytes (the value being 
shown at the Historical Analysis Screen) * pageSize in bytes 
(the value being shown at the Historical Analysis screen) 
 
Total Size (in MB) = Total Size (in bytes) / MB unit 
 
In cases where Total Pages is very large, this calculation can 
result in a very large number which displays as a negative 
value.  This is because an integer type is being used to store 
the total page value and the value is too large for the integer 
type.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 LUW v9.5                                                 * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* HISTORICAL ANALYSIS OF A TABLESPACE HAS TOTAL SIZE SHOWING   * 
* AS                                                           * 
* NEGATIVE VALUE IN CONTROL CENTER                             * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW v9.5 Fixpack 8                            * 
****************************************************************
Local Fix:
As a workaround, please calculate the Total Size manually using 
the calculation noted in the error description.
available fix packs:
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
First fixed in DB2 LUW v9.5 Fixpack 8
Workaround
Calculate total size manually using: Total Size (in MB) = Total 
Size (in bytes) / MB unit
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC75315 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
25.03.2011
05.07.2011
05.07.2011
Problem solved at the following versions (IBM BugInfos)
9.5.FP8
Problem solved according to the fixlist(s) of the following version(s)
9.5.0.8 FixList