DB2 - Problem description
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 | |
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 |