B2 buffer pool metrics.
For a detailed discussion of these metrics, see ProTop Real-Time - Buffer Pools (ctrl-b).
To set up an alert on a metric listed here, make note of the Data Collector name at the top of this page, the Alertable Metric and Data Type from the table below and visit Alert Configuration.
| Alertable Metric | ProTop RT Label | Data Type | Description |
| tt_b2 | (temptable name) | ||
| bpActive | Active | num | Number of active buffers in the buffer pool |
| bpArea | Area | num | Only available in late 11.x versions. Number of area blocks in the buffer pool |
| bpBMap | BMap | num | Number of block map blocks in the buffer pool |
| bpCMap | CMap | num | Number of cluster map blocks in the buffer pool |
| bpCtrl | Ctrl | num | Only available in late 11.x versions. Number of control blocks in the buffer pool |
| bpData | DataBlk | num | Only available in late 11.x versions. Number of data blocks in the buffer pool |
| bpHitPct | Hit% | num | Percentage of read requests filled from the buffer pool |
| bpIdx | IdxBlk | num | Only available in late 11.x versions. Number of index blocks in the buffer pool |
| bpIndexes | Idxs | num | Number of indices in the buffer pool |
| bpLOBS | LOB | num | Number of LOBs in the buffer pool |
| bpLogRd | LogRd | num | Number of logical reads from the buffer pool |
| bpLogWr | logWr | num | Number of logical writes to the buffer pool |
| bplruStat | LRU Stat | char | Status of the LRU chain. See below for discussion |
| bpMstr | Mstr | num | Only available in late 11.x versions. Number of master blocks in the buffer pool |
| bpName | Pool | char | Primary or Alternate buffer ppol |
| bpObj | Obj | num | Only available in late 11.x versions. Number of object blocks in the buffer pool. |
| bpOCList | OCL | num | Number of object cluster list blocks in the buffer pool |
| bpOList | OLst | num | Number of object list blocks in the buffer pool |
| bpOSRd | OSRd | num | Number of reads from storage (disk) |
| bpOSWr | OSWr | num | Number of writes to storage (disk) |
| bpSeq | SEQ | num | Only available in late 11.x versions. Number of sequence blocks in the buffer pool |
| bpSize | Buffers | num | Number of buffer blocks in the pool |
| bpTables | Tbls | num | Number of tables in the buffer pool |
| bpUnused | Unused | num | Number of unused buffers in the buffer pool |
| zbpLru2 | LRU2 | char | Is LRU enabled or disabled? |
| zbpABPAct | ABP Running | char | Is there Alternate Buffer Pool activity? (Yes/No) |