IBM Books


Buffer Pool Data Pages from Extended Storage


Snapshot Information Level
Database
Table Space
 
Application

API Structure(s)
sqlm_dbase
sqlm_tablespace
sqlm_bp_info
sqlm_appl

Monitor Group
Buffer Pool
Buffer Pool
Buffer Pool
Buffer Pool

Resettable 

Yes

 

Event Information Level
Database
Connection
Table Space

API Structure(s)
sqlm_db_event
sqlm_conn_event
sqlm_tablespace_event

 

API Element Name
Element Type

pool_data_from_estore
counter

 

Description:  Number of bufferpool data pages copied from extended storage.

Usage:  Required pages are copied from extended storage to the bufferpool, if they are not in the bufferpool, but are in extended storage. This copying may incur the cost of connecting to the shared memory segement, but saves the cost of a disk read.

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

[ DB2 List of Books | Search the DB2 Books ]