Buffer Pool Index Logical 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_l_reads
counter

Description:  Indicates the number of logical read requests for index pages that have gone through the buffer pool.

Usage:  This count includes accesses to index pages that are:

• Already in the buffer pool for which the database manager returns the page
• Read into the buffer pool before the database manager can return the page.

In conjunction with "Buffer Pool Index Physical Reads", you can calculate the index page hit ratio for the buffer pool using one of the following:

 1 - (buffer pool index physical reads / buffer pool index logical reads)

To calculate the overall buffer pool hit ratio, see "Buffer Pool Data Logical Reads".

If the hit ratio is low, increasing the number of buffer pool pages may improve performance. See the Administration Guide for more information about the buffer pool configuration parameter (buffpage).

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

[ DB2 List of Books | Search the DB2 Books ]