Buffer Pool Log Space Cleaners Triggered



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.