|
Problem IC68504
|
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 / 950 - 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: *
* 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 |
| available fix packs: |
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
|
| Solution |
Fixed in DB2 V9.5 Fixpack 5 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC68526 IC68527
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 07.05.2010
09.11.2010
09.11.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.7
|
 |
| 9.5.0.7
|
|
