IBM Books

Number of Log Pages Read


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_reads
counter

 

Description:  The number of log pages read from disk by the logger.

Usage:  You can 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 ]