|
Problem IC89149
|
Status: Closed |
FILE EVENT MONITOR LEAKS PRIVATE MEMORY WHEN FAILING TO WRITE OUT EVENT HEADER |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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
... |
| Problem Summary: |
****************************************************************
* 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 *
**************************************************************** |
| Local Fix: |
Increase the MAXFILESIZE, MAXFILES attributes for the file event
monitor and/or increase the filesystem space available to the
event monitor |
| available fix packs: |
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
|
| Solution |
Problem first fixed in DB2 Version 9.7 Fix Pack 8 |
| Workaround |
see local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC89151
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.12.2012
11.07.2013
11.07.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.8
|
 |
