|
Problem IC63097
|
Status: Closed |
DB2EXFMT OUTPUTS HEAPUSE (Maximum Statement Heap Usage) |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
db2exfmt outputs HEAPUSE : (Maximum Statement Heap Usage)
when the memory size is greater than 2GB, we see a negative
number.
It has platform-dependent behaviour. On AIX, there is negative
number.
Arguments:
---------
BLDLEVEL: (Build level)
DB2 v9.5.0.4 : s090429
HEAPUSE : (Maximum Statement Heap Usage)
-190800 Pages
On linuxamd64, the behaviour is different. Instead of a negative
number, db2exfmt outputs an extreamly large number
Arguments:
---------
BLDLEVEL: (Build level)
DB2 v9.5.0.4 : s090429
HEAPUSE : (Maximum Statement Heap Usage)
4503599626995952 Pages
The wrong "HEAPUSE" info is stored in the EXPLAIN tables, any
program that queries the explain tables may see the incorrect
HEAPUSE. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* It has platform-dependent behaviour *
****************************************************************
* PROBLEM DESCRIPTION: *
* db2exfmt outputs HEAPUSE : (Maximum Statement Heap *
* Usage)when the memory size is greater than 2GB, we see a *
* negativenumber.It has platform-dependent behaviour. On AIX, *
* there isnegativenumber.Arguments:---------BLDLEVEL: (Build *
* level)DB2 v9.5.0.4 : s090429HEAPUSE : (Maximum Statement *
* Heap Usage)-190800 PagesOn linuxamd64, the behaviour is *
* different. Instead of anegativenumber, db2exfmt outputs an *
* extreamly large numberArguments:---------BLDLEVEL: (Build *
* level)DB2 v9.5.0.4 : s090429HEAPUSE : (Maximum Statement *
* Heap Usage)4503599626995952 PagesThe wrong "HEAPUSE" info is *
* stored in the EXPLAIN tables,anyprogram that queries the *
* explain tables may see theincorrectHEAPUSE. *
****************************************************************
* RECOMMENDATION: *
* upgrade to Version 9.5 Fix Pack 6 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
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 |
Problem was first fixed in Version 9.5 Fix Pack 6 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC63098 IC63099
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.09.2009
22.06.2010
22.06.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
