|
Problem IC68526
|
Status: Closed |
MANY DECLARES AND DROPS (OR DECLARE...WITH REPLACE) OF GLOBAL TEMPORARY TABLES IN SAME TRANSACTION INCREASES APPLHEAP USAGE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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 |
| available fix packs: |
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
|
| Solution |
Fixed in DB2 for LUW Version 9.7 fixpack 3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 07.05.2010
23.09.2010
23.09.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP3
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
