|
Problem IC63097
|
Status: Geschlossen |
DB2EXFMT OUTPUTS HEAPUSE (Maximum Statement Heap Usage) |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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: |
|
| verfügbare FixPacks: |
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
|
| Lösung |
Problem was first fixed in Version 9.5 Fix Pack 6 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC63098 IC63099
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 10.09.2009
22.06.2010
22.06.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.FP6
|
| Problem behoben lt. FixList in der Version |
