DB2 FOR LUW / DB2FORLUW / 970 - DB2

A file event monitor may leak private memory when it fails to 
write out the header of a monitored event.  This may occur if 
the defined MAXFILESIZE / MAXFILES limit is reached or if 
filesystem space is exhausted. 
 
In the case of a deadlock event, if there is a large number of 
locks involved, the leaked memory may be large and cause memory 
usage problems on a system (eg. paging). 
 
A db2diag.log message is associated with the leak : 
EDUID   : 94323                EDUNAME: db2evmli (DEADLOCK_MON) 
0 
FUNCTION: DB2 UDB, database monitor, sqmEvmonBuffer::write_data, 
probe:10 
MESSAGE : ZRC=0x800D002B=-2146631637=SQLM_RC_EVFULL "monitor 
full of data" 
          DIA8052C The Event Monitor "" has reached its file 
capacity. Delete 
          the files in the target directory "" or move them to 
another 
          directory. 
 
The memory growth occurs in the PERSISTENT_PRIVATE memory pool 
and can be monitored using the MON_GET_MEMORY_POOL monitor 
routine. 
 
db2pd -memblocks <db2sysc PID> 
may show a growing amount of memory allocations from a file ID 
of 3401466018: 
PoolID     PoolName   TotalSize(Bytes)     TotalCount LOC   File 
0                     2272875936           1          4437 
3401466018 
0                     2272869259           1          4437 
3401466018 
...

**************************************************************** 
* USERS AFFECTED:                                              * 
* systems using file event monitors                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Use local fix or upgrade to DB2 Version 9.7 Fix Pack 8       * 
****************************************************************

Increase the MAXFILESIZE, MAXFILES attributes for the file event 
monitor and/or increase the filesystem space available to the 
event monitor

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

see local fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC89151 
Nachfolger : 

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

17.12.2012
11.07.2013
11.07.2013

9.7.FP8