DB2 - Problembeschreibung
Problem IC73944 | Status: Geschlossen |
DATABASE MEMORY ALLOCATION EFFICIENCY IMPROVEMENTS | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - 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 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: * * Systems with a high frequency of LOAD operations. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 9.7 Fix pack 4 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 9.7 Fix pack 4 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC81770 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 18.01.2011 29.04.2011 25.11.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP4 | |
Problem behoben lt. FixList in der Version | |
9.7.0.4 |