|
Problem IC77172
|
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 / 970 - 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 Error Description. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 6. *
**************************************************************** |
| Local Fix: |
N/A |
| available fix packs: |
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 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 |
First fixed in DB2 version 9.7 Fix Pack 6. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.06.2011
02.08.2012
02.08.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
