|
Problem IC68527
|
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 / 980 - 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: *
* 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 |
| available fix packs: |
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux
|
| Solution |
Fixed in DB2 for LUW V9.8 fixpack 3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 07.05.2010
12.08.2011
12.08.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.8.FP3
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.8.0.4
|
 |
