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 IC63098 Status: Closed

db2exfmt outputs HEAPUSE : (Maximum Statement Heap Usage)

product:
DB2 FOR LUW / DB2FORLUW / 910 - 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:
No formail fix is planned.
Local Fix:
Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
10.09.2009
28.10.2009
28.10.2009
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)