home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC76937 Status: Closed

A SINGLE MONITORING EVENT, SUCH AS A DEADLOCK, CAN CREATE A FILE LARGER
THAN WHAT IS SPECIFIED BY MAXFILESIZE.

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
Currently, a single monitoring event will be written to a new 
file if it does not fit in the current .evt file based on 
MAXFILESIZE.  However, the new file will be as large as needed 
to record the entire single event in one file.  This can result 
in a very large event file. 
 
The fix for this APAR provides an option to force an event 
record to fit into the target event file, up to the size defined 
by the MAXFILESIZE setting specified while creating the event 
monitor, by truncating the event record if necessary. So, for 
example, if a deadlock event dumps out a very large listing of 
locks, this information will be truncated to MAXFILESIZE.  The 
registry setting can be turned on and off by: 
 
db2set DB2_SYSTEM_MONITOR_SETTINGS=ENFORCE_MAX_FILE_SIZE:TRUE 
db2set DB2_SYSTEM_MONITOR_SETTINGS=ENFORCE_MAX_FILE_SIZE:FALSE 
 
db2stop 
db2start 
 
The default behavior will continue to be writing the entire 
event record into a single file without any truncation of data, 
thus allowing the size of the target .evt file to grow beyond 
the MAXFILESIZE setting.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.5 Fix Pack 9 to be able to use the new  * 
* option to limit the size of the target .evt files to the     * 
* MAXFILESIZE setting.                                         * 
****************************************************************
Local Fix:
N/A
available fix packs:
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
First fixed in Version 9.5 Fix Pack 9
Workaround
not known / see Local fix
Comment
Please get in touch with service to enable the new option.
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC77172 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
13.06.2011
08.03.2012
08.03.2012
Problem solved at the following versions (IBM BugInfos)
9.5.FP9
Problem solved according to the fixlist(s) of the following version(s)
9.5.0.9 FixList