DB2 FOR LUW / DB2FORLUW / 970 - DB2

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

**************************************************************** 
* 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                   * 
****************************************************************

Terminate the client connection to free the memory heap

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
 

Fixed in DB2 9.7 Fix Pack 6

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

02.04.2012
04.06.2012
04.06.2012

9.7.FP6