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.
Buffer pool
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
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.
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.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
