IBM Books

Number of Log Pages Written


Snapshot Information Level
Database

API Structure(s)
sqlm_dbase

Monitor Group
Basic

Resettable

Yes

 

Event Information Level
Database

API Structure(s)
sqlm_db_event

 

API 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.

The size of a log page in OS/2 and UNIX-based environments is 4K in size.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]