Table/Structure Field list used by SAP ABAP Function Module DB2_KPI_GET_BP_ACTIVITY (get bufferpool activity data)
SAP ABAP Function Module
DB2_KPI_GET_BP_ACTIVITY (get bufferpool activity data) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | DB2DSMEM - MEMB_NAME | DB2DSMEM-MEMB_NAME | ||
| 2 | DB2_KPI_QBST - MEMBER | DB2 member name in data sharing environment | ||
| 3 | DB2_KPI_QBST - QBSTGET | Number of get page requests (conditional and unconditional) | ||
| 4 | DB2_KPI_QBST - QBSTIMW | Number of immediate writes | ||
| 5 | DB2_KPI_QBST - QBSTPWS | Number of pages written | ||
| 6 | DB2_KPI_QBST - QBSTRIO | Number of synchronous read I/O operations | ||
| 7 | DB2_KPI_QBST - QBSTSGT | Number of get page requests issued by sequential access req. | ||
| 8 | DB2_KPI_QBST - QBSTSIO | Synchronous read requests issued by sequential access req. | ||
| 9 | DB2_KPI_QBST - QBSTSWS | Update intents against pages in the buffer pool | ||
| 10 | DB2_KPI_QBST - RANDHITR | Random hit ratio | ||
| 11 | DB2_KPI_QBST - SIOPERSGT | Sync. seq. reads / seq. getpages | ||
| 12 | DB2_KPI_QBST - SWRTRATE | Sync writes / ( sync writes + async writes) | ||
| 13 | DB2_KPI_QBST - UPPPWRIT | Buffer update per pages written |