DB2 - Problembeschreibung
Problem IC68504 | Status: Geschlossen |
MANY DECLARES AND DROPS (OR DECLARE...WITH REPLACE) OF GLOBAL TEMPORARY TABLES IN SAME TRANSACTION INCREASES APPLHEAP USAGE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
If a single transaction includes many creates and drops of global temporary tables (most typically by using the "DECLARE GLOBAL TEMPORARY TABLE....WITH REPLACE) repeatedly, the application heap usage increases during the transaction. Only a commit/rollback will free this memory. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL DB2LUW * **************************************************************** * PROBLEM DESCRIPTION: * * MANY DECLARES AND DROPS (OR DECLARE...WITH * * REPLACE)OFGLOBALTEMPORARY TABLES IN SAME TRANSACTION * * INCREASESAPPLHEAPUSAGE * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V9.5 Fixpack 5 * **************************************************************** | |
Local-Fix: | |
Commit more frequently or re-use existing declare global temporary tables (rather than using DECLARE ...WITH REPLACE) if the definition of the table remains the same | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows | |
Lösung | |
Fixed in DB2 V9.5 Fixpack 5 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC68526 IC68527 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 07.05.2010 09.11.2010 09.11.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP5 | |
Problem behoben lt. FixList in der Version | |
9.1.0.7 | |
9.5.0.7 |