|
Problem IC68526
|
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 / 970 - 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: *
* users of Declared Global Temporary Tables (DGTTs) *
****************************************************************
* PROBLEM DESCRIPTION: *
* increase in application memory use on the server when many *
* DGTTs are created in the same transaction *
****************************************************************
* RECOMMENDATION: *
* Move to DB2 for LUW Version 9.7 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.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
Fixed in DB2 for LUW Version 9.7 fixpack 3 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 07.05.2010
23.09.2010
23.09.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP3
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
