|
Problem IC82437
|
Status: Closed |
MEMORY LEAK WHEN REFERENCING ROW VARIABLES IN SET STATEMENTS IN DPF |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
When a set statement that references row variables is executed,
you may find a memory leak in the application heap in DPF.
You can monitor the growing memory usage in an application heap
in DPF by running:
db2pd -db <DBNAME> -memblocks appl -alldbpartitionums
Note* The above reports only information from database partition
servers on the same physical machine that db2pd is being run on.
After running the command for this scenario, you may find
something similar to the following in the output:
PoolID PoolName TotalSize(Bytes) TotalCount LOC
File
1 apph 3 3
5833 930532034 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Anyone running v97 or later *
****************************************************************
* PROBLEM DESCRIPTION: *
* MEMORY LEAK WHEN REFERENCING ROW VARIABLES IN SET STATEMENTS *
* IN DPF *
****************************************************************
* RECOMMENDATION: *
* upgrade to v97fp6 or later release/fixpack *
**************************************************************** |
| Local Fix: |
Terminate the client connection to free the memory heap |
| available fix packs: |
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 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Fixed in DB2 9.7 Fix Pack 6 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.04.2012
04.06.2012
04.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
