DB2 - Problembeschreibung
Problem IC92740 | Status: Geschlossen |
EXCESSIVE MEMORY USAGE IN DATABASE HEAP WHEN FAILING ALTER TABLE SPACE COMMANDS ARE ISSUED ACROSS A LARGE NUMBER OF TABLESPACES | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
A 256K database heap allocation required for certain alter tablespace commands is unintentionally cached when no internal action is required. The memory is cached per tablespace and will be reused for any subsequent alter tablespace command on the same tablespace (and may be freed as part of that operation). Commands known to miss freeing the buffer: 1. ALTER TABLESPACE ... REDUCE where the reduce operation cannot proceed. This will be accompanied by a db2diag.log message: FUNCTION: DB2 UDB, buffer pool services, sqlbAlterPool, probe:15 MESSAGE : ADM1534W Table space "USERSPACE1" could not be reduced in size because there are used pages at the end of the table space. 2. ALTER TABLESPACE ... REBALANCE where the rebalance operation is not required. The additional cached memory is rarely significant, reused per tablespace, and freed at database deactivation. Systems with a very large number of tablespaces where the above commands are regularly issued may experience symptoms associated with abnormally high memory usage. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * all systems * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 9.7 Fix Pack 9 * **************************************************************** | |
Local-Fix: | |
avoid invalid ALTER TABLESPACE command where possible | |
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: IC95388 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 03.06.2013 18.12.2013 18.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 |