DB2 Version 9.7 for Linux, UNIX, and Windows

prefetch_wait_time - Time waited for prefetch monitor element

The time an application spent waiting for an I/O server (prefetcher) to finish loading pages into the buffer pool. The value is given in milliseconds.

Table 1. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database dbase Buffer Pool
Application appl Buffer Pool
Table 2. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Database event_db -
Connection event_conn -
Usage
This element can be used to experiment with changing the number of I/O servers, and I/O server sizes.