|
Problem IC66165
|
Status: Closed |
GET_DBSIZE_INFO CALCULATIONS ARE INCORRECT |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problem description: |
The output for "call GET_DBSIZE_INFO(?,?,?,-1)" showed the
following values on the customer's system as follows.
$ db2 "call GET_DBSIZE_INFO(?,?,?,-1)"
Value of output parameters
--------------------------
Parameter Name : SNAPSHOTTIMESTAMP
Parameter Value : 2010-01-27-16.26.01.960351
Parameter Name : DATABASESIZE
Parameter Value : 933794480128
Parameter Name : DATABASECAPACITY
Parameter Value : 897023210496
Return Status = 0
The values of DATABASECAPACITY being less than DATABASESIZE is
not expected behavior. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of GET_DBSIZE_INFO procedure *
****************************************************************
* PROBLEM DESCRIPTION: *
* The output for "call GET_DBSIZE_INFO(?,?,?,-1)" showed the *
* *
* following values on the customer's system as follows. *
* *
* *
* *
* $ db2 "call GET_DBSIZE_INFO(?,?,?,-1)" *
* *
* *
* *
* Value of output parameters *
* *
* *
* *
* -------------------------- *
* *
* *
* *
* Parameter Name : SNAPSHOTTIMESTAMP *
* *
* *
* *
* Parameter Value : 2010-01-27-16.26.01.960351 *
* *
* *
* *
* Parameter Name : DATABASESIZE *
* *
* *
* *
* Parameter Value : 933794480128 *
* *
* Parameter Name : DATABASECAPACITY *
* *
* *
* *
* Parameter Value : 897023210496 *
* *
* Return Status = 0 *
* *
* *
* *
* *
* *
* The values of DATABASECAPACITY being less than DATABASESIZE *
* does *
* not make sense. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V91 FP10 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Solution |
Problem fixed in DB2 V91 FP10 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.02.2010
14.06.2011
19.08.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.10
|
 |
