DB2 - Problembeschreibung
Problem IC81770 | Status: Geschlossen |
DATABASE MEMORY ALLOCATION EFFICIENCY IMPROVEMENTS | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
Memory allocation requirements of both LOAD and table compression dictionaries are inefficient, causing memory wastage and fragmentation. In the case of table compression dictionaries, excessive memory pool level overhead (logical size - physical size) may be seen in db2pd -alldbs -mempools output for the database heap. In the case of LOAD, frequent load operations may lead to an increase in database memory set level requirements due to fragmentation overhead. Symptoms include excess memory usage and possibly SQL0973 with the following db2diag.log message. EDUID : 8786 EDUNAME: db2lload 0 FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0 DATA #1 : String, 143 bytes LOADID: XXXXX Failed to enable fast memblocks , -1961951227, 0, Detected in file:sqlulbuf2.C, Line:2014 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All systems are affected * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.5 Fix pack 10 * **************************************************************** | |
Local-Fix: | |
Lösung | |
Problem first fixed in DB2 Version 9.5 Fix Pack 10 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 01.03.2012 06.09.2012 25.11.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP10 | |
Problem behoben lt. FixList in der Version | |
9.5.0.10 |