IBM Books


Time Waited for Prefetch


Snapshot Information Level
Database
Application

API Structure(s)
sqlm_dbase
sqlm_appl

Monitor Group
Buffer Pool
Buffer Pool

Resettable

No

 

Event Information Level
Database
Connection

API Structure(s)
sqlm_db_event
sqlm_conn_event

 

API Element Name
Element Type

prefetch_wait_time
counter

 

Description:  The time an application spent waiting for an I/O server (prefetcher) to finish loading pages into the buffer pool.

Usage:  This element can be used to experiment with changing the number of I/O servers, and I/O server sizes.

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

[ DB2 List of Books | Search the DB2 Books ]