DB2 FOR LUW / DB2FORLUW / 970 - DB2

When performing multiple inserts within a unit of work into 
partitioned MDC tables, a small amount of memory may be leaked 
in the Application Shared Heap (inside the Application Memory 
set).  This memory usage accumulates until the database 
deactivates, and may result in performance degradation or other 
out-of-memory related errors. 
 
The Application Shared Heap can be monitored using : 
- database snapshot (look for the "Applications Shared Heap" 
memory pool entry) 
- db2pd -db <database> -mempools (look for the row with a 
PoolName of appshrh ) 
- on DB2 version 9.7 Fix Pack 5 and higher, use the 
MON_GET_MEMORY_POOL routine filtering on 
MEMORY_POOL_TYPE='APPL_SHARED' 
 
The leaking memory can be identified using the following: 
db2pd -db <database> -memblocks appctl | grep 1560397958 
( use "-memblocks appl 20" on version 9.7 Fix Pack 4 and higher 
) 
 
If a large number of rows similar to the following are seen, 
this APAR likely applies: 
0x070000003003FFC8 20         appshrh      59    1            0 
1497  1560397958

**************************************************************** 
* USERS AFFECTED:                                              * 
* systems using partitioned MDC tables                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix pack 8                        * 
****************************************************************

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
 

Problem first fixed in DB2 Version 9.7 Fix pack 8

keiner bekannt / siehe Local-Fix

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

14.11.2012
10.07.2013
10.07.2013

9.7.FP8