DB2 FOR LUW / DB2FORLUW / A50 - DB2

When using Federated server there is a memory leak when the 
statements are compiled. 
 
The command 'db2pd -dbptnmem' will show high instance memory 
usage from the 'PRIVATE' consumer 
 
The MON_GET_MEMORY_POOL routine will show high memory usage from 
the PERSISTENT_PRIVATE memory pool.  This, along with the usage 
of federated server, is enough to identify the problem. 
   db2 "select * from 
table(mon_get_memory_pool('PRIVATE',null,null)) 
 
More detailed information pointing to the problem can be seen 
when running the following command: 
 db2pd -memblocks private sort pid=[db2sysc pid] > 
db2pd_membPRIVATESort.out 
will show large memory usage in the following areas: 
	All memory blocks in Private set. 
 
Address            DataAddress        PoolID     PoolName 
BlkAge Size(Bytes)  I LOC   File 
Total set size: 0 bytes 
 
Memory blocks sorted by size: 
PoolID     PoolName   TotalSize(Bytes)     TotalCount LOC   File 
 
0                     60226016             752652     451 
2074526459 
0                     14784439             1240354    1874 
2093195612 
0                     8388608              16         9153 
3922823597 
 
The LOC column may differ for each Fix Pack level. 
 
The problem was introduced in DB2 10.5.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All Federated Server users                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW 10.5 Fix Pack 5                           * 
****************************************************************

n/a

First fixed in DB2 LUW 10.5 Fix Pack 5

keiner bekannt / siehe Local-Fix

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

07.07.2014
13.03.2015
25.07.2016