Number of Log Pages Written


 
Snapshot Level
Database

 
Logical Data Grouping
dbase

 
Monitor Switch
Basic

Resettable

Yes

 

 
Event Type
Database

 
Logical Data Grouping
db_event

 

Element Name
Element Type

log_writes
counter

 

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

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 data element to measure the number of pages produced by DB2.