IBM Books

Buffer Pool Log Space Cleaners Triggered


Snapshot Information Level
Database

API Structure(s)
sqlm_dbase

Monitor Group
Buffer Pool

Resettable

Yes

 

Event Information Level
Database

API Structure(s)
sqlm_db_event

 

API 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.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]