DB2 SRM BPM Attributes
Use the DB2 SRM BPM attributes to create situations to monitor buffer pool activity.
Allocated Pages The total number of pages allocated to the buffer pool: It includes pages that are currently read or updated, updated pages, and available pages.
Get Page Rate The number of get page operations per second over the last interval.
Get Page Rate Extended Precision The number of get page operations per second over the last interval.
Interval Time The number of seconds since last sample.
Originating System ID The managed system name of the agent. It is an alphanumeric text string, with a maximum of 32 characters; for example, DB91:SYS1:DB2.
Pages In Use The number of virtual buffer pool pages in use at the end of the interval (a snapshot value of the current number of non-stealable buffers): A non-stealable buffer is either one which has an outstanding Getpage (someone is currently looking at this page) or one which has been updated and not yet written out to DASD.
Pool ID The buffer pool ID.
Prefetch Request Rate The number of prefetch requests issued per second over the last interval.
Prefetch Request Rate Extended Precision The number of prefetch requests issued per second over the last interval.
Read IO Rate The number of read I/O operations per second over the last interval.
Read IO Rate Extended Precision The number of read I/O operations per second over the last interval.
Time The date and time, as set on the monitored system, indicating the instance when the agent collects information.
Utilization The percentage of the buffer pool currently in use: It is calculated as: (QBSTCBA / QBSTVPL)*100 for DB2 9 and (QBSTCBA / QDBPVPSZ)*100 for DB2 10 or later.
- QBSTCBA
- The total number of currently active (nonstealable) buffers.
- QBSTVPL
- The number of buffers allocated for a virtual buffer pool.
- QDBPVPSZ
- The size of the virtual buffer pool.
Valid entry ranges from 0 to 10000.
VP Size The size of the virtual buffer pool.
Write IO Rate The number of write I/Os performed per second over the last interval.
Write IO Rate Extended Precision The number of write I/Os performed per second over the last interval.