IBM Books

Direct Read Requests


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

direct_read_reqs
counter

 

Description:  The number of requests to perform a direct read of one or more sectors of data.

Usage:  Use the following formula to calculate the average number of sectors that are read by a direct read:

 direct reads from database / direct read requests

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

[ DB2 List of Books | Search the DB2 Books ]