The number of log pages written to disk by
the logger.
- Element identifier
- log_writes
- Element type
- counter
Table 1. Snapshot Monitoring InformationSnapshot Level |
Logical Data Grouping |
Monitor Switch |
Database |
dbase |
Basic |
For snapshot monitoring, this counter
can be reset.
Table 2. Event Monitoring InformationEvent 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®.