|
Problem IC68527
|
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 / 980 - 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: *
* Applications that create Declared Global Temporary Tables *
****************************************************************
* PROBLEM DESCRIPTION: *
* Applheap Memory increase *
****************************************************************
* RECOMMENDATION: *
* Move to DB2 for LUW V9.8 fixpack 3 *
**************************************************************** |
| 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.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux
|
| Lösung |
Fixed in DB2 for LUW V9.8 fixpack 3 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 07.05.2010
12.08.2011
12.08.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.8.FP3
|
| Problem behoben lt. FixList in der Version |
| 9.8.0.4
|
 |
