DB2 Buffer Pool (DB2_BUFFERPOOL)

The DB2_BUFFERPOOL application class represents the bufferpool node of the database and displays the monitoring activities related to the bufferpools,

Application class attributes

Attributes (parameters)

The following attributes are available for this monitor type:

• Average of direct write time (AveDirWriteTime)
• Average of dir read time (AveDirReadTime)
• Average of number of pages read per async request (AveNumPgsReadPerAsyncReq)
• Average of number sectors read per direct read (AveNumSectorsRead)
• Average of number sectors written per direct write (AveNumSectorsWritten)
• Average of page cleaner write time (AvePgCleanWriteTime)
• Average of page read time (AvePgReadTime)
• Average of page write time (AvePgWriteTime)
• Average of pre-fetch read time (AvePrefetchReadTime)
• Average synchronous I/O read time (AveSyncBPReadTime)
• Buffer pool data page cleaner efficiency ratio (BPDataPgCleanEff)
• Buffer pool data write/read ratio (BPDataWriteReadRatio)
• Buffer pool hit ratio (BufferPoolHitRatio)
• Buffer pool index page cleaner efficiency ratio (BPIndxPgCleanEff)
• Buffer pool index write/read ratio (BPIndxWriteReadRatio)
• Database pre-fetcher efficiency ratio (DBPrefetchEffRatio)
• Data page hit ratio (DataPgHitRatio)
• Index of page hit ratio (IndxPgHitRatio)
• Synchronous buffer pool hit ratio (SyncBPHitRatio)