DB2 Version 9.7 for Linux, UNIX, and Windows

log_writes - Number of Log Pages Written monitor element

The number of log pages written to disk by the logger.

Element identifier
log_writes
Element type
counter
Table 1. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database dbase Basic
For snapshot monitoring, this counter can be reset.
Table 2. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Database event_db -
Usage
You may use this element with an operating system monitor to quantify the amount of I/O on a device that is attributable to database activity.
Note: When log pages are written to disk, the last page might not be full. In such cases, the partial log page remains in the log buffer, and additional log records are written to the page. Therefore log pages might be written to disk by the logger more than once. You should not use this element to measure the number of pages produced by DB2®.