Data Element list used by SAP ABAP Table DB2_KPI_QBST (bufferpool activity data)
SAP ABAP Table
DB2_KPI_QBST (bufferpool activity data) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | DB2BSTBPNM | DB2 buffer pool name | ||
| 2 | DB2BSTDMC | Number of times the data manager threshold was reached | ||
| 3 | DB2BSTGET | Number of get page requests (conditional and unconditional) | ||
| 4 | DB2BSTIMW | Number of immediate writes | ||
| 5 | DB2BSTPWS | Number of pages written | ||
| 6 | DB2BSTRIO | Number of synchronous read I/O operations | ||
| 7 | DB2BSTRPI | Number of page inserts required for read I/O | ||
| 8 | DB2BSTSGT | Number of get page requests issued by sequential access req. | ||
| 9 | DB2BSTSIO | Synchronous read requests issued by sequential access req. | ||
| 10 | DB2BSTSWS | Update intents against pages in the buffer pool | ||
| 11 | DB2BSTVPL | Number of buffers allocated for virtual buffer pool | ||
| 12 | DB2MEMN | DB2 member name in data sharing environment | ||
| 13 | DB2PREFDIS | Number of Times Sequential Prefetch Was Disabled | ||
| 14 | DB2RNDHITR | Random hit ratio | ||
| 15 | DB2SIOSGT | Sync. seq. reads / seq. getpages | ||
| 16 | DB2SWRTRATE | Sync writes / ( sync writes + async writes) | ||
| 17 | DB2UPPPWRI | Buffer update per pages written | ||
| 18 | DB2VPSHORT | Number of Virtual Pool Shortages |