IBM Books

Buffer Pool Index Physical Reads


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
Table Space
Connection

API Structure(s)
sqlm_db_event
sqlm_tablespace_event
sqlm_conn_event

 

API Element Name
Element Type

pool_index_p_reads
counter

 

Description:  Indicates the number of physical read requests to get index pages into the buffer pool.

Usage:  See "Buffer Pool Index Logical Reads" for information about how to use this element.

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

[ DB2 List of Books | Search the DB2 Books ]