DB2 FOR LUW / DB2FORLUW / 970 - DB2

This memory leak is caused by running UDFs when the following 
two conditions are true: 
 
1) your clientapplication and database server has different 
   code pages 
2) the connection concentrator is enabled. DB2 Connection 
   concentrator is activated when you set the number of maximum 
   logical agents (max_connections) higher than the number of 
   coordinating agents (max_coordagents). 
 
You may experience frequent out of application heap error 
messages due to this. The error message may look something 
like this: 
 
SQL0954C  Not enough storage is available in the application 
heap to process the statement.  SQLSTATE=57011 
 
 
Running the following db2pd command will show you a single 
application heap increasing as you repeat the execution of the 
UDF: 
 
 
db2pd -db <dbname> -memblocks appctl top 
 
------------------------------------------------- 
Top memory consumers in AppCtl memory set: 
PoolID     PoolName   TotalSize(Bytes)     %Bytes  TotalCount 
%Count    LOC          File 
     1         apph         4923381504      86.45     2562612 
1.68    117     3551095165 
     1         apph          486051840       8.53     2531520 
0.17    117     3551095165 
 
-------------------------------------------------

USERS AFFECTED: 
=============== 
Customer using version 9.5 and above on all platforms. 
 
PROBLEM DESCRIPTION: 
==================== 
It user application runs UDFs very frequently under the 
following two conditions, database will experience the memory 
leak in application heap and cause frequent out of memory 
errors: 
. 
1) your clientapplication and database server has different 
   code pages 
2) the connection concentrator is enabled. DB2 Connection 
   concentrator is activated when you set the number of maximum 
   logical agents (max_connections) higher than the number of 
   coordinating agents (max_coordagents). 
 
RECOMMENDATION: 
=============== 
Disabling connection concentrator will prevent the memory leak.

Disabling connection concentrator will prevent the memory leak. 
 
NOTE: DB2 connection concentrator is activated when you set the 
number of maximum logical agents (max_connections) higher than 
the number of coordinating agents (max_coordagents).

DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 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 9a 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 10 for Linux, UNIX, and Windows
 

Problem is first fixed in version 9.7 Fixpack 2.

Disabling connection concentrator will prevent the memory leak.

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

25.11.2009
23.03.2011
23.03.2011

9.7.,
9.7.FP2