home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 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 FixList
9.5.0.7 FixList