Table/Structure Field list used by SAP ABAP Class CL_DB2_ACTION_BP_DETAILS (DB2: Performance: Bufferpool Details)
SAP ABAP Class 
CL_DB2_ACTION_BP_DETAILS (DB2: Performance: Bufferpool Details) is using
-
Class (40)
-
Data Element (5)
-
Table/Structure Field (163)
-
Function Module (2)
-
Interface (15)
-
Class Method (23)
-
Table (21)
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 | Table/Structure Field |
DB2QBST - BUPDRATE | Buffer Update Rate | |
| 2 | Table/Structure Field |
DB2QBST - CURRINUSE | Percentage of buffers currently in use | |
| 3 | Table/Structure Field |
DB2QBST - GETPRAND | Number of Random Access Getpage Requests | |
| 4 | Table/Structure Field |
DB2QBST - GETPRATE | Number of Getpage Requests per Second | |
| 5 | Table/Structure Field |
DB2QBST - PAGEIN | Number of page-ins | |
| 6 | Table/Structure Field |
DB2QBST - PG_DYNPREF | Number of Pages Read per Dynamic Prefetch Read | |
| 7 | Table/Structure Field |
DB2QBST - PG_LISPREF | Number of Pages Read per List Prefetch Read | |
| 8 | Table/Structure Field |
DB2QBST - PG_SEQPREF | Number of Pages Read per Sequential Prefetch Read | |
| 9 | Table/Structure Field |
DB2QBST - PREFDIS | Number of Times Sequential Prefetch Was Disabled | |
| 10 | Table/Structure Field |
DB2QBST - PWPWIO | Pages written per write I/O | |
| 11 | Table/Structure Field |
DB2QBST - QBSTCBA | Number of currently active (non-stealable) buffers | |
| 12 | Table/Structure Field |
DB2QBST - QBSTDIO | Number of dynamic prefetch reads | |
| 13 | Table/Structure Field |
DB2QBST - QBSTDIO | Number of dynamic prefetch reads | |
| 14 | Table/Structure Field |
DB2QBST - QBSTDMC | Number of times the data manager threshold was reached | |
| 15 | Table/Structure Field |
DB2QBST - QBSTDPF | Number of dynamic prefetch requests | |
| 16 | Table/Structure Field |
DB2QBST - QBSTDPP | Number of pages read via dynamic prefetch read I/O | |
| 17 | Table/Structure Field |
DB2QBST - QBSTDPP | Number of pages read via dynamic prefetch read I/O | |
| 18 | Table/Structure Field |
DB2QBST - QBSTDSO | Number of datasets successfully opened physically | |
| 19 | Table/Structure Field |
DB2QBST - QBSTDWT | Number of times the deferred write threshold was reached | |
| 20 | Table/Structure Field |
DB2QBST - QBSTDWV | Number of times vertical deferred write threshold is reached | |
| 21 | Table/Structure Field |
DB2QBST - QBSTGET | Number of get page requests (conditional and unconditional) | |
| 22 | Table/Structure Field |
DB2QBST - QBSTGET | Number of get page requests (conditional and unconditional) | |
| 23 | Table/Structure Field |
DB2QBST - QBSTHITR | Buffer hit ratio | |
| 24 | Table/Structure Field |
DB2QBST - QBSTIMW | Number of immediate writes | |
| 25 | Table/Structure Field |
DB2QBST - QBSTIMW | Number of immediate writes | |
| 26 | Table/Structure Field |
DB2QBST - QBSTJIS | Total number of denied concurrent prefetch I/O streams | |
| 27 | Table/Structure Field |
DB2QBST - QBSTJIS | Total number of denied concurrent prefetch I/O streams | |
| 28 | Table/Structure Field |
DB2QBST - QBSTLIO | Number of list prefetch reads | |
| 29 | Table/Structure Field |
DB2QBST - QBSTLIO | Number of list prefetch reads | |
| 30 | Table/Structure Field |
DB2QBST - QBSTLPF | Number of list prefetch requests | |
| 31 | Table/Structure Field |
DB2QBST - QBSTLPL | Number of times one or more pages were added to LPL | |
| 32 | Table/Structure Field |
DB2QBST - QBSTLPP | Number of pages read via list prefetch | |
| 33 | Table/Structure Field |
DB2QBST - QBSTLPP | Number of pages read via list prefetch | |
| 34 | Table/Structure Field |
DB2QBST - QBSTMAX | Number of times a work file could not be opened | |
| 35 | Table/Structure Field |
DB2QBST - QBSTMIG | Number of times migrated datasets were encountered | |
| 36 | Table/Structure Field |
DB2QBST - QBSTNGT | # of unsuccessful GETPAGE due conditional GETPAGE request | |
| 37 | Table/Structure Field |
DB2QBST - QBSTPIO | Number of sequential prefetch reads | |
| 38 | Table/Structure Field |
DB2QBST - QBSTPIO | Number of sequential prefetch reads | |
| 39 | Table/Structure Field |
DB2QBST - QBSTPL1 | Prefetch quantity is reduced from normal to 50% | |
| 40 | Table/Structure Field |
DB2QBST - QBSTPL1 | Prefetch quantity is reduced from normal to 50% | |
| 41 | Table/Structure Field |
DB2QBST - QBSTPL2 | Number of occurrences of prefetch quantity reduced 1/4 | |
| 42 | Table/Structure Field |
DB2QBST - QBSTPL2 | Number of occurrences of prefetch quantity reduced 1/4 | |
| 43 | Table/Structure Field |
DB2QBST - QBSTPQF | The parallel query went into reduced or degenerated mode | |
| 44 | Table/Structure Field |
DB2QBST - QBSTPQF | The parallel query went into reduced or degenerated mode | |
| 45 | Table/Structure Field |
DB2QBST - QBSTPQO | Total no. of requests for parallel query support | |
| 46 | Table/Structure Field |
DB2QBST - QBSTPWS | Number of pages written | |
| 47 | Table/Structure Field |
DB2QBST - QBSTPWS | Number of pages written | |
| 48 | Table/Structure Field |
DB2QBST - QBSTREE | Sequential prefetch disabled - unavailable read engine | |
| 49 | Table/Structure Field |
DB2QBST - QBSTREE | Sequential prefetch disabled - unavailable read engine | |
| 50 | Table/Structure Field |
DB2QBST - QBSTRIO | Number of synchronous read I/O operations | |
| 51 | Table/Structure Field |
DB2QBST - QBSTRIO | Number of synchronous read I/O operations | |
| 52 | Table/Structure Field |
DB2QBST - QBSTRPI | Number of page inserts required for read I/O | |
| 53 | Table/Structure Field |
DB2QBST - QBSTRPI | Number of page inserts required for read I/O | |
| 54 | Table/Structure Field |
DB2QBST - QBSTRTO | Number of recall timeouts | |
| 55 | Table/Structure Field |
DB2QBST - QBSTSEQ | Number of sequential prefetch requests | |
| 56 | Table/Structure Field |
DB2QBST - QBSTSGT | Number of get page requests issued by sequential access req. | |
| 57 | Table/Structure Field |
DB2QBST - QBSTSGT | Number of get page requests issued by sequential access req. | |
| 58 | Table/Structure Field |
DB2QBST - QBSTSIO | Synchronous read requests issued by sequential access req. | |
| 59 | Table/Structure Field |
DB2QBST - QBSTSIO | Synchronous read requests issued by sequential access req. | |
| 60 | Table/Structure Field |
DB2QBST - QBSTSPD | Sequential prefetch disabled - no buffers available | |
| 61 | Table/Structure Field |
DB2QBST - QBSTSPD | Sequential prefetch disabled - no buffers available | |
| 62 | Table/Structure Field |
DB2QBST - QBSTSPP | Number of pages read because of normal sequential prefetch | |
| 63 | Table/Structure Field |
DB2QBST - QBSTSPP | Number of pages read because of normal sequential prefetch | |
| 64 | Table/Structure Field |
DB2QBST - QBSTSWS | Update intents against pages in the buffer pool | |
| 65 | Table/Structure Field |
DB2QBST - QBSTSWS | Update intents against pages in the buffer pool | |
| 66 | Table/Structure Field |
DB2QBST - QBSTVPA | Number of successful virtual buffer pool expans./contract. | |
| 67 | Table/Structure Field |
DB2QBST - QBSTVPL | Number of buffers allocated for virtual buffer pool | |
| 68 | Table/Structure Field |
DB2QBST - QBSTWBVQ | Number of Pages Removed from the DWQ for Destructive Read | |
| 69 | Table/Structure Field |
DB2QBST - QBSTWDRP | Number of pages for which destructive read was requested | |
| 70 | Table/Structure Field |
DB2QBST - QBSTWEE | A write engine is unavailable for asynchronous write I/O | |
| 71 | Table/Structure Field |
DB2QBST - QBSTWFD | Work file requests were rejected due to buffer pool shortage | |
| 72 | Table/Structure Field |
DB2QBST - QBSTWFD | Work file requests were rejected due to buffer pool shortage | |
| 73 | Table/Structure Field |
DB2QBST - QBSTWFF | Number of times a merge pass could not be performed | |
| 74 | Table/Structure Field |
DB2QBST - QBSTWFF | Number of times a merge pass could not be performed | |
| 75 | Table/Structure Field |
DB2QBST - QBSTWFM | Maximum number of work files concurrently used | |
| 76 | Table/Structure Field |
DB2QBST - QBSTWFR | Number of merge passes requested for DB2 sort activities | |
| 77 | Table/Structure Field |
DB2QBST - QBSTWFR | Number of merge passes requested for DB2 sort activities | |
| 78 | Table/Structure Field |
DB2QBST - QBSTWFT | Number of merge passes requested for DB2 sort activities | |
| 79 | Table/Structure Field |
DB2QBST - QBSTWFT | Number of merge passes requested for DB2 sort activities | |
| 80 | Table/Structure Field |
DB2QBST - QBSTWIO | Number of asynchronous writes | |
| 81 | Table/Structure Field |
DB2QBST - QBSTWIO | Number of asynchronous writes | |
| 82 | Table/Structure Field |
DB2QBST - QBSTWKPD | Number of work prefetches not scheduled due to zero prefetch | |
| 83 | Table/Structure Field |
DB2QBST - QBSTWKPD | Number of work prefetches not scheduled due to zero prefetch | |
| 84 | Table/Structure Field |
DB2QBST - QBSTWPI | Number of page inserts required for write I/O | |
| 85 | Table/Structure Field |
DB2QBST - QBSTWPI | Number of page inserts required for write I/O | |
| 86 | Table/Structure Field |
DB2QBST - QBSTXFL | Number of times the virtual buffer pool was full | |
| 87 | Table/Structure Field |
DB2QBST - QBSTXFL | Number of times the virtual buffer pool was full | |
| 88 | Table/Structure Field |
DB2QBST - QBSTXFV | Total number of virtual buffer pool or hiperpool failures | |
| 89 | Table/Structure Field |
DB2QBST - QBSTXFV | Total number of virtual buffer pool or hiperpool failures | |
| 90 | Table/Structure Field |
DB2QBST - QBSTXIS | Highest number of concurrent prefetch I/O streams | |
| 91 | Table/Structure Field |
DB2QBST - RANDHITR | Random hit ratio | |
| 92 | Table/Structure Field |
DB2QBST - READRATE | Read rate per second | |
| 93 | Table/Structure Field |
DB2QBST - SIOPERSGT | Sync. seq. reads / seq. getpages | |
| 94 | Table/Structure Field |
DB2QBST - SWRTRATE | Sync writes / ( sync writes + async writes) | |
| 95 | Table/Structure Field |
DB2QBST - SYNRRAND | Number of Random Access Synchronous Reads | |
| 96 | Table/Structure Field |
DB2QBST - UPPPWRIT | Buffer update per pages written | |
| 97 | Table/Structure Field |
DB2QBST - VPSHORT | Number of Virtual Pool Shortages | |
| 98 | Table/Structure Field |
DB2QBST - WFN_DEGMP | Average Work Files Not Given per Degraded Merge Pass | |
| 99 | Table/Structure Field |
DB2QBST - WF_MERGE | Average Work Files per Merge Pass | |
| 100 | Table/Structure Field |
DB2QBST - WRITERATE | Write rate = ( Synchronous + async. writes ) / interval | |
| 101 | Table/Structure Field |
DB2QBSTT - QBSTBPNM | DB2 buffer pool name | |
| 102 | Table/Structure Field |
DB2QBSTT - QBSTDIO | Number of dynamic prefetch reads | |
| 103 | Table/Structure Field |
DB2QBSTT - QBSTDMC | Number of times the data manager threshold was reached | |
| 104 | Table/Structure Field |
DB2QBSTT - QBSTDPF | Number of dynamic prefetch requests | |
| 105 | Table/Structure Field |
DB2QBSTT - QBSTDPP | Number of pages read via dynamic prefetch read I/O | |
| 106 | Table/Structure Field |
DB2QBSTT - QBSTDSO | Number of datasets successfully opened physically | |
| 107 | Table/Structure Field |
DB2QBSTT - QBSTDWT | Number of times the deferred write threshold was reached | |
| 108 | Table/Structure Field |
DB2QBSTT - QBSTDWV | Number of times vertical deferred write threshold is reached | |
| 109 | Table/Structure Field |
DB2QBSTT - QBSTGET | Number of get page requests (conditional and unconditional) | |
| 110 | Table/Structure Field |
DB2QBSTT - QBSTIMW | Number of immediate writes | |
| 111 | Table/Structure Field |
DB2QBSTT - QBSTJIS | Total number of denied concurrent prefetch I/O streams | |
| 112 | Table/Structure Field |
DB2QBSTT - QBSTLIO | Number of list prefetch reads | |
| 113 | Table/Structure Field |
DB2QBSTT - QBSTLPF | Number of list prefetch requests | |
| 114 | Table/Structure Field |
DB2QBSTT - QBSTLPL | Number of times one or more pages were added to LPL | |
| 115 | Table/Structure Field |
DB2QBSTT - QBSTLPP | Number of pages read via list prefetch | |
| 116 | Table/Structure Field |
DB2QBSTT - QBSTMAX | Number of times a work file could not be opened | |
| 117 | Table/Structure Field |
DB2QBSTT - QBSTMIG | Number of times migrated datasets were encountered | |
| 118 | Table/Structure Field |
DB2QBSTT - QBSTNGT | # of unsuccessful GETPAGE due conditional GETPAGE request | |
| 119 | Table/Structure Field |
DB2QBSTT - QBSTPIO | Number of sequential prefetch reads | |
| 120 | Table/Structure Field |
DB2QBSTT - QBSTPL1 | Prefetch quantity is reduced from normal to 50% | |
| 121 | Table/Structure Field |
DB2QBSTT - QBSTPL2 | Number of occurrences of prefetch quantity reduced 1/4 | |
| 122 | Table/Structure Field |
DB2QBSTT - QBSTPQF | The parallel query went into reduced or degenerated mode | |
| 123 | Table/Structure Field |
DB2QBSTT - QBSTPQO | Total no. of requests for parallel query support | |
| 124 | Table/Structure Field |
DB2QBSTT - QBSTPWS | Number of pages written | |
| 125 | Table/Structure Field |
DB2QBSTT - QBSTREE | Sequential prefetch disabled - unavailable read engine | |
| 126 | Table/Structure Field |
DB2QBSTT - QBSTRIO | Number of synchronous read I/O operations | |
| 127 | Table/Structure Field |
DB2QBSTT - QBSTRPI | Number of page inserts required for read I/O | |
| 128 | Table/Structure Field |
DB2QBSTT - QBSTRTO | Number of recall timeouts | |
| 129 | Table/Structure Field |
DB2QBSTT - QBSTSEQ | Number of sequential prefetch requests | |
| 130 | Table/Structure Field |
DB2QBSTT - QBSTSGT | Number of get page requests issued by sequential access req. | |
| 131 | Table/Structure Field |
DB2QBSTT - QBSTSIO | Synchronous read requests issued by sequential access req. | |
| 132 | Table/Structure Field |
DB2QBSTT - QBSTSPD | Sequential prefetch disabled - no buffers available | |
| 133 | Table/Structure Field |
DB2QBSTT - QBSTSPP | Number of pages read because of normal sequential prefetch | |
| 134 | Table/Structure Field |
DB2QBSTT - QBSTSWS | Update intents against pages in the buffer pool | |
| 135 | Table/Structure Field |
DB2QBSTT - QBSTVPA | Number of successful virtual buffer pool expans./contract. | |
| 136 | Table/Structure Field |
DB2QBSTT - QBSTWBVQ | Number of Pages Removed from the DWQ for Destructive Read | |
| 137 | Table/Structure Field |
DB2QBSTT - QBSTWDRP | Number of pages for which destructive read was requested | |
| 138 | Table/Structure Field |
DB2QBSTT - QBSTWEE | A write engine is unavailable for asynchronous write I/O | |
| 139 | Table/Structure Field |
DB2QBSTT - QBSTWFD | Work file requests were rejected due to buffer pool shortage | |
| 140 | Table/Structure Field |
DB2QBSTT - QBSTWFF | Number of times a merge pass could not be performed | |
| 141 | Table/Structure Field |
DB2QBSTT - QBSTWFM | Maximum number of work files concurrently used | |
| 142 | Table/Structure Field |
DB2QBSTT - QBSTWFR | Number of merge passes requested for DB2 sort activities | |
| 143 | Table/Structure Field |
DB2QBSTT - QBSTWFT | Number of merge passes requested for DB2 sort activities | |
| 144 | Table/Structure Field |
DB2QBSTT - QBSTWIO | Number of asynchronous writes | |
| 145 | Table/Structure Field |
DB2QBSTT - QBSTWKPD | Number of work prefetches not scheduled due to zero prefetch | |
| 146 | Table/Structure Field |
DB2QBSTT - QBSTWPI | Number of page inserts required for write I/O | |
| 147 | Table/Structure Field |
DB2QBSTT - QBSTXFL | Number of times the virtual buffer pool was full | |
| 148 | Table/Structure Field |
DB2QBSTT - QBSTXFV | Total number of virtual buffer pool or hiperpool failures | |
| 149 | Table/Structure Field |
DB2QBSTT - QBSTXIS | Highest number of concurrent prefetch I/O streams | |
| 150 | Table/Structure Field |
DB2QDBP - QDBPNM | Name of buffer pool | |
| 151 | Table/Structure Field |
DB2_VIEW_BP_DET - QBST | DB2_VIEW_BP_DET-QBST | |
| 152 | Table/Structure Field |
DB2_VIEW_BP_DET - QBST | DB2_VIEW_BP_DET-QBST | |
| 153 | Table/Structure Field |
DB2_VIEW_BP_DET - QBST | DB2_VIEW_BP_DET-QBST | |
| 154 | Table/Structure Field |
DB2_VIEW_BP_DET - QBST | DB2_VIEW_BP_DET-QBST | |
| 155 | Table/Structure Field |
DB2_VIEW_BP_DET - QDBP | DB2_VIEW_BP_DET-QDBP | |
| 156 | Table/Structure Field |
DB2_VIEW_BP_DET - QDBP | DB2_VIEW_BP_DET-QDBP | |
| 157 | Table/Structure Field |
DB6NAVSYST - DBCNAME | Logical name for a database connection | |
| 158 | Table/Structure Field |
DB6TSTAMP_STRUCT - DATE | System Date | |
| 159 | Table/Structure Field |
DB6TSTAMP_STRUCT - TIME | System Time | |
| 160 | Table/Structure Field |
DBA_ACTION_CTRL - PARTITION_ALL_SUPPORTED | Replacement for Real Boolean Type: 'X' == True '' == False | |
| 161 | Table/Structure Field |
DBA_ACTION_DESCR - ID | DBA_ACTION_DESCR-ID | |
| 162 | Table/Structure Field |
SYST - DATUM | ABAP System Field: Current Date of Application Server | |
| 163 | Table/Structure Field |
SYST - UZEIT | ABAP System Field: Current Time of Application Server |
