Snapshot Level Database |
Logical Data Grouping dbase |
Monitor Switch Buffer Pool |
Resettable |
Yes |
|
Event Type Database |
Logical Data Grouping db_event |
|
Element Name Element Type |
pool_lsn_gap_clns counter |
Description: The number of times a page cleaner was invoked because the logging space used had reached a predefined criterion for the database.
Usage: This element can be used to help evaluate whether you have enough space for logging, and whether you need more log files or larger log files.
The page cleaning criterion is determined by the setting for the softmax configuration parameter. Page cleaners are triggered if the oldest page in the buffer pool contains an update described by a log record that is older than the current log position by the criterion value. See the Administration Guide for more information.