home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList