DB2 - Problembeschreibung
Problem IC63099 | Status: Geschlossen |
db2exfmt outputs HEAPUSE : (Maximum Statement Heap Usage) | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - 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 isnegative number.Arguments:---------BLDLEVEL: (Build * * level)DB2 v9.5.0.4 : s090429HEAPUSE : (Maximum Statement * * Heap Usage)-190800 PagesOn linuxamd64, the behaviour is * * different. Instead of anegative number, 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,any program that queries the * * explain tables may see theincorrect HEAPUSE. * **************************************************************** * RECOMMENDATION: * * upgrade to Version 9.7 Fix Pack 2 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in Version 9.7 Fix Pack 2 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 10.09.2009 10.06.2010 10.06.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP2 | |
Problem behoben lt. FixList in der Version | |
9.7.0.2 |