DB2 - Problembeschreibung
Problem IC90143 | Status: Geschlossen |
EXCESSIVE MEMORY USAGE WITH XML SYSTEM TEMPORARY TABLES | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
As of DB2 version 9.7 Fix Pack 6/ Version 10.1 GA, systems with a a very high concurrent requirement of XML system temporary tables may see higher memory usage in the database heap. In all but extreme cases this additional memory usage will be insignificant. Example db2pd -alldbs -mempools output, showing that the real memory usage (PhySz) greatly exceeds the internal requirement (LogSz) Memory Pools: MemSet PoolName Id LogSz LogUpBnd LogHWM PhySz PhyUpBnd PhyHWM TRWPRD dbh 2 255440313 2423652352 255667442 1751908352 2423652352 1751908352 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * systems processing XML data * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 Fix Pack 9 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows | |
Lösung | |
Problem first fixed in DB2 Version 9.7 Fix Pack 9 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC90242 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 11.02.2013 26.12.2013 26.12.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP9 | |
Problem behoben lt. FixList in der Version | |
9.7.0.9 | |
9.7.0.9 |