Spotlight on DB2 6.10 - User Guide

Direct I/O rates

The Direct dataflows depict the rate of direct reads and writes occurring in all active databases in the DB2 instance.

• Direct writes—Database requests that bypass buffer pools to write LONG VARCHAR or large object (LOB) data directly to the database or to perform database restores and loads.

• Direct reads—Database requests that bypass buffer pools to read LONG VARCHAR or large object (LOB) data directly from the database or to perform a database backup.

Required monitor switch

Buffer pool

Displayed statistic

At each refresh, Spotlight captures the following statistics and displays them just above their respective rate dataflow.

• W/s (direct write rate)—The total number of direct writes per second across all databases and partitions within the instance

• R/s (direct read rate)—The total number of direct reads per second across all databases and partitions within the instance

Graph

The line graph that overlays each dataflow plots the instance-wide direct write or read rates captured over the series of refreshes that have occurred during the Spotlight session.

Associated drilldown

Clicking in the Global Database I/O panel opens the Database Manager Summary drilldown. This drilldown provides details about all the active databases and partitions in the DB2 instance. You can select any database or partition to view details about that database, including I/O activity details.

Related topics

Metric Editor

Database Manager Summary drilldown