SAP ABAP Table DB2_KPI_QBST (bufferpool activity data)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU2 (Package) CCMS for DB2 for OS/390
Basic Data
Table Category INTTAB    Structure 
Structure DB2_KPI_QBST   Table Relationship Diagram
Short Description bufferpool activity data    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MEMBER DB2MEMN DB2CHAR08 CHAR 8   0   DB2 member name in data sharing environment  
2 QBSTBPNM DB2BSTBPNM DB2BPNAME CHAR 8   0   DB2 buffer pool name  
3 QBSTVPL DB2BSTVPL DB2DEC19V DEC 19   0   Number of buffers allocated for virtual buffer pool  
4 QBSTGET DB2BSTGET DB2DEC19V DEC 19   0   Number of get page requests (conditional and unconditional)  
5 RANDHITR DB2RNDHITR DB2DECPCT DEC 5   2   Random hit ratio  
6 QBSTRPI DB2BSTRPI DB2DEC19V DEC 19   0   Number of page inserts required for read I/O  
7 SIOPERSGT DB2SIOSGT DB2DEC19V6 DEC 19   6   Sync. seq. reads / seq. getpages  
8 UPPPWRIT DB2UPPPWRI DB2DEC19V2 DEC 19   2   Buffer update per pages written  
9 SWRTRATE DB2SWRTRATE DB2DECPCT DEC 5   2   Sync writes / ( sync writes + async writes)  
10 QBSTDMC DB2BSTDMC DB2DEC19V DEC 19   0   Number of times the data manager threshold was reached  
11 VPSHORT DB2VPSHORT DB2DEC20V DEC 20   0   Number of Virtual Pool Shortages  
12 PREFDIS DB2PREFDIS DB2DEC20V DEC 20   0   Number of Times Sequential Prefetch Was Disabled  
13 QBSTSGT DB2BSTSGT DB2DEC19V DEC 19   0   Number of get page requests issued by sequential access req.  
14 QBSTSIO DB2BSTSIO DB2DEC19V DEC 19   0   Synchronous read requests issued by sequential access req.  
15 QBSTRIO DB2BSTRIO DB2DEC19V DEC 19   0   Number of synchronous read I/O operations  
16 QBSTSWS DB2BSTSWS DB2DEC19V DEC 19   0   Update intents against pages in the buffer pool  
17 QBSTPWS DB2BSTPWS DB2DEC19V DEC 19   0   Number of pages written  
18 QBSTIMW DB2BSTIMW DB2DEC19V DEC 19   0   Number of immediate writes  
History
Last changed by/on SAP  20110908 
SAP Release Created in 731