DB2 - Problembeschreibung
Problem IC62926 | Status: Geschlossen |
MEMORY LEAK CAN OCCUR WHILE RUNNING REORG ON A TABLE WITH A COMPRESSED XDA OBJECT | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
In DB2 v9.7 a small amount of memory from the database heap may be leaked during a REORG. For the leak to occur, the reorganized table must be compressed and must contain at least one XML column. Some of the XML documents must be stored in the XML storage object and be compressed. Symptoms of this memory leak include: - Continuous increase of memory usage both inside the DB2 process and on the system overall - Out-of-memory errors reported by the database manager - Side effects such as the inability to connect to DB2 databases - System memory or paging space exhaustion This memory is allocated from the database heap, and will be reported by DB2 memory monitoring tools (db2pd, db2mtrk, snapshot). | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Any * **************************************************************** * PROBLEM DESCRIPTION: * * MEMORY LEAK CAN OCCUR WHILE RUNNING REORG ON A TABLE WITH A * * COMPRESSED XDA OBJECT * **************************************************************** * RECOMMENDATION: * * Upgrade to V9.7 FP1 * **************************************************************** | |
Local-Fix: | |
Increasing the size of the database heap via the 'dbheap' memory configuration parameter may help prevent the symptoms of this memory leak. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 01.09.2009 04.02.2010 04.02.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP1 | |
Problem behoben lt. FixList in der Version | |
9.7.0.1 |