Table/Structure Field list used by SAP ABAP Class CL_DB2_ACTION_BUFFERPOOLS (DB2: Performance: Bufferpools)
SAP ABAP Class
CL_DB2_ACTION_BUFFERPOOLS (DB2: Performance: Bufferpools) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | ALV_S_FCAT - COL_OPT | Entry for Optional Column Optimization | ||
| 2 | ALV_S_FCAT - COL_OPT | Entry for Optional Column Optimization | ||
| 3 | ALV_S_FCAT - COL_POS | ALV control: Output column | ||
| 4 | ALV_S_FCAT - COL_POS | ALV control: Output column | ||
| 5 | ALV_S_FCAT - FIELDNAME | ALV control: Field name of internal table field | ||
| 6 | ALV_S_FCAT - FIELDNAME | ALV control: Field name of internal table field | ||
| 7 | ALV_S_FCAT - FIELDNAME | ALV control: Field name of internal table field | ||
| 8 | ALV_S_FCAT - HOTSPOT | ALV control: SingleClick-sensitive | ||
| 9 | ALV_S_FCAT - NO_OUT | ALV control: Column is not output | ||
| 10 | ALV_S_FCAT - NO_OUT | ALV control: Column is not output | ||
| 11 | ALV_S_FCAT - NO_OUT | ALV control: Column is not output | ||
| 12 | ALV_S_FCAT - TOOLTIP | ALV control: Tool tip for column header | ||
| 13 | ALV_S_FCAT - TOOLTIP | ALV control: Tool tip for column header | ||
| 14 | ALV_S_LAYO - ZEBRA | ALV control: Alternating line color (striped) | ||
| 15 | ALV_S_LAYO - ZEBRA | ALV control: Alternating line color (striped) | ||
| 16 | DB2QBST - BUPDRATE | Buffer Update Rate | ||
| 17 | DB2QBST - CURRINUSE | Percentage of buffers currently in use | ||
| 18 | DB2QBST - GETPRAND | Number of Random Access Getpage Requests | ||
| 19 | DB2QBST - GETPRATE | Number of Getpage Requests per Second | ||
| 20 | DB2QBST - PAGEIN | Number of page-ins | ||
| 21 | DB2QBST - PG_DYNPREF | Number of Pages Read per Dynamic Prefetch Read | ||
| 22 | DB2QBST - PG_LISPREF | Number of Pages Read per List Prefetch Read | ||
| 23 | DB2QBST - PG_SEQPREF | Number of Pages Read per Sequential Prefetch Read | ||
| 24 | DB2QBST - PREFDIS | Number of Times Sequential Prefetch Was Disabled | ||
| 25 | DB2QBST - PWPWIO | Pages written per write I/O | ||
| 26 | DB2QBST - QBSTBPNM | DB2 buffer pool name | ||
| 27 | DB2QBST - QBSTBPNM | DB2 buffer pool name | ||
| 28 | DB2QBST - QBSTBPNM | DB2 buffer pool name | ||
| 29 | DB2QBST - QBSTCBA | Number of currently active (non-stealable) buffers | ||
| 30 | DB2QBST - QBSTDIO | Number of dynamic prefetch reads | ||
| 31 | DB2QBST - QBSTDIO | Number of dynamic prefetch reads | ||
| 32 | DB2QBST - QBSTDMC | Number of times the data manager threshold was reached | ||
| 33 | DB2QBST - QBSTDPF | Number of dynamic prefetch requests | ||
| 34 | DB2QBST - QBSTDPP | Number of pages read via dynamic prefetch read I/O | ||
| 35 | DB2QBST - QBSTDPP | Number of pages read via dynamic prefetch read I/O | ||
| 36 | DB2QBST - QBSTDSO | Number of datasets successfully opened physically | ||
| 37 | DB2QBST - QBSTDWT | Number of times the deferred write threshold was reached | ||
| 38 | DB2QBST - QBSTDWV | Number of times vertical deferred write threshold is reached | ||
| 39 | DB2QBST - QBSTGET | Number of get page requests (conditional and unconditional) | ||
| 40 | DB2QBST - QBSTGET | Number of get page requests (conditional and unconditional) | ||
| 41 | DB2QBST - QBSTHITR | Buffer hit ratio | ||
| 42 | DB2QBST - QBSTIMW | Number of immediate writes | ||
| 43 | DB2QBST - QBSTIMW | Number of immediate writes | ||
| 44 | DB2QBST - QBSTJIS | Total number of denied concurrent prefetch I/O streams | ||
| 45 | DB2QBST - QBSTJIS | Total number of denied concurrent prefetch I/O streams | ||
| 46 | DB2QBST - QBSTLIO | Number of list prefetch reads | ||
| 47 | DB2QBST - QBSTLIO | Number of list prefetch reads | ||
| 48 | DB2QBST - QBSTLPF | Number of list prefetch requests | ||
| 49 | DB2QBST - QBSTLPL | Number of times one or more pages were added to LPL | ||
| 50 | DB2QBST - QBSTLPP | Number of pages read via list prefetch | ||
| 51 | DB2QBST - QBSTLPP | Number of pages read via list prefetch | ||
| 52 | DB2QBST - QBSTMAX | Number of times a work file could not be opened | ||
| 53 | DB2QBST - QBSTMIG | Number of times migrated datasets were encountered | ||
| 54 | DB2QBST - QBSTNGT | # of unsuccessful GETPAGE due conditional GETPAGE request | ||
| 55 | DB2QBST - QBSTPIO | Number of sequential prefetch reads | ||
| 56 | DB2QBST - QBSTPIO | Number of sequential prefetch reads | ||
| 57 | DB2QBST - QBSTPL1 | Prefetch quantity is reduced from normal to 50% | ||
| 58 | DB2QBST - QBSTPL1 | Prefetch quantity is reduced from normal to 50% | ||
| 59 | DB2QBST - QBSTPL2 | Number of occurrences of prefetch quantity reduced 1/4 | ||
| 60 | DB2QBST - QBSTPL2 | Number of occurrences of prefetch quantity reduced 1/4 | ||
| 61 | DB2QBST - QBSTPQF | The parallel query went into reduced or degenerated mode | ||
| 62 | DB2QBST - QBSTPQF | The parallel query went into reduced or degenerated mode | ||
| 63 | DB2QBST - QBSTPQO | Total no. of requests for parallel query support | ||
| 64 | DB2QBST - QBSTPWS | Number of pages written | ||
| 65 | DB2QBST - QBSTPWS | Number of pages written | ||
| 66 | DB2QBST - QBSTREE | Sequential prefetch disabled - unavailable read engine | ||
| 67 | DB2QBST - QBSTREE | Sequential prefetch disabled - unavailable read engine | ||
| 68 | DB2QBST - QBSTRIO | Number of synchronous read I/O operations | ||
| 69 | DB2QBST - QBSTRIO | Number of synchronous read I/O operations | ||
| 70 | DB2QBST - QBSTRPI | Number of page inserts required for read I/O | ||
| 71 | DB2QBST - QBSTRPI | Number of page inserts required for read I/O | ||
| 72 | DB2QBST - QBSTRTO | Number of recall timeouts | ||
| 73 | DB2QBST - QBSTSEQ | Number of sequential prefetch requests | ||
| 74 | DB2QBST - QBSTSGT | Number of get page requests issued by sequential access req. | ||
| 75 | DB2QBST - QBSTSGT | Number of get page requests issued by sequential access req. | ||
| 76 | DB2QBST - QBSTSIO | Synchronous read requests issued by sequential access req. | ||
| 77 | DB2QBST - QBSTSIO | Synchronous read requests issued by sequential access req. | ||
| 78 | DB2QBST - QBSTSPD | Sequential prefetch disabled - no buffers available | ||
| 79 | DB2QBST - QBSTSPD | Sequential prefetch disabled - no buffers available | ||
| 80 | DB2QBST - QBSTSPP | Number of pages read because of normal sequential prefetch | ||
| 81 | DB2QBST - QBSTSPP | Number of pages read because of normal sequential prefetch | ||
| 82 | DB2QBST - QBSTSWS | Update intents against pages in the buffer pool | ||
| 83 | DB2QBST - QBSTSWS | Update intents against pages in the buffer pool | ||
| 84 | DB2QBST - QBSTVPA | Number of successful virtual buffer pool expans./contract. | ||
| 85 | DB2QBST - QBSTVPL | Number of buffers allocated for virtual buffer pool | ||
| 86 | DB2QBST - QBSTWBVQ | Number of Pages Removed from the DWQ for Destructive Read | ||
| 87 | DB2QBST - QBSTWDRP | Number of pages for which destructive read was requested | ||
| 88 | DB2QBST - QBSTWEE | A write engine is unavailable for asynchronous write I/O | ||
| 89 | DB2QBST - QBSTWFD | Work file requests were rejected due to buffer pool shortage | ||
| 90 | DB2QBST - QBSTWFD | Work file requests were rejected due to buffer pool shortage | ||
| 91 | DB2QBST - QBSTWFF | Number of times a merge pass could not be performed | ||
| 92 | DB2QBST - QBSTWFF | Number of times a merge pass could not be performed | ||
| 93 | DB2QBST - QBSTWFM | Maximum number of work files concurrently used | ||
| 94 | DB2QBST - QBSTWFR | Number of merge passes requested for DB2 sort activities | ||
| 95 | DB2QBST - QBSTWFR | Number of merge passes requested for DB2 sort activities | ||
| 96 | DB2QBST - QBSTWFT | Number of merge passes requested for DB2 sort activities | ||
| 97 | DB2QBST - QBSTWFT | Number of merge passes requested for DB2 sort activities | ||
| 98 | DB2QBST - QBSTWIO | Number of asynchronous writes | ||
| 99 | DB2QBST - QBSTWIO | Number of asynchronous writes | ||
| 100 | DB2QBST - QBSTWKPD | Number of work prefetches not scheduled due to zero prefetch | ||
| 101 | DB2QBST - QBSTWKPD | Number of work prefetches not scheduled due to zero prefetch | ||
| 102 | DB2QBST - QBSTWPI | Number of page inserts required for write I/O | ||
| 103 | DB2QBST - QBSTWPI | Number of page inserts required for write I/O | ||
| 104 | DB2QBST - QBSTXFL | Number of times the virtual buffer pool was full | ||
| 105 | DB2QBST - QBSTXFL | Number of times the virtual buffer pool was full | ||
| 106 | DB2QBST - QBSTXFV | Total number of virtual buffer pool or hiperpool failures | ||
| 107 | DB2QBST - QBSTXFV | Total number of virtual buffer pool or hiperpool failures | ||
| 108 | DB2QBST - QBSTXIS | Highest number of concurrent prefetch I/O streams | ||
| 109 | DB2QBST - RANDHITR | Random hit ratio | ||
| 110 | DB2QBST - READRATE | Read rate per second | ||
| 111 | DB2QBST - SIOPERSGT | Sync. seq. reads / seq. getpages | ||
| 112 | DB2QBST - SWRTRATE | Sync writes / ( sync writes + async writes) | ||
| 113 | DB2QBST - SYNRRAND | Number of Random Access Synchronous Reads | ||
| 114 | DB2QBST - UPPPWRIT | Buffer update per pages written | ||
| 115 | DB2QBST - VPSHORT | Number of Virtual Pool Shortages | ||
| 116 | DB2QBST - WFN_DEGMP | Average Work Files Not Given per Degraded Merge Pass | ||
| 117 | DB2QBST - WF_MERGE | Average Work Files per Merge Pass | ||
| 118 | DB2QBST - WRITERATE | Write rate = ( Synchronous + async. writes ) / interval | ||
| 119 | DB2QBSTT - QBSTDIO | Number of dynamic prefetch reads | ||
| 120 | DB2QBSTT - QBSTDMC | Number of times the data manager threshold was reached | ||
| 121 | DB2QBSTT - QBSTDPF | Number of dynamic prefetch requests | ||
| 122 | DB2QBSTT - QBSTDPP | Number of pages read via dynamic prefetch read I/O | ||
| 123 | DB2QBSTT - QBSTDSO | Number of datasets successfully opened physically | ||
| 124 | DB2QBSTT - QBSTDWT | Number of times the deferred write threshold was reached | ||
| 125 | DB2QBSTT - QBSTDWV | Number of times vertical deferred write threshold is reached | ||
| 126 | DB2QBSTT - QBSTGET | Number of get page requests (conditional and unconditional) | ||
| 127 | DB2QBSTT - QBSTIMW | Number of immediate writes | ||
| 128 | DB2QBSTT - QBSTJIS | Total number of denied concurrent prefetch I/O streams | ||
| 129 | DB2QBSTT - QBSTLIO | Number of list prefetch reads | ||
| 130 | DB2QBSTT - QBSTLPF | Number of list prefetch requests | ||
| 131 | DB2QBSTT - QBSTLPL | Number of times one or more pages were added to LPL | ||
| 132 | DB2QBSTT - QBSTLPP | Number of pages read via list prefetch | ||
| 133 | DB2QBSTT - QBSTMAX | Number of times a work file could not be opened | ||
| 134 | DB2QBSTT - QBSTMIG | Number of times migrated datasets were encountered | ||
| 135 | DB2QBSTT - QBSTNGT | # of unsuccessful GETPAGE due conditional GETPAGE request | ||
| 136 | DB2QBSTT - QBSTPIO | Number of sequential prefetch reads | ||
| 137 | DB2QBSTT - QBSTPL1 | Prefetch quantity is reduced from normal to 50% | ||
| 138 | DB2QBSTT - QBSTPL2 | Number of occurrences of prefetch quantity reduced 1/4 | ||
| 139 | DB2QBSTT - QBSTPQF | The parallel query went into reduced or degenerated mode | ||
| 140 | DB2QBSTT - QBSTPQO | Total no. of requests for parallel query support | ||
| 141 | DB2QBSTT - QBSTPWS | Number of pages written | ||
| 142 | DB2QBSTT - QBSTREE | Sequential prefetch disabled - unavailable read engine | ||
| 143 | DB2QBSTT - QBSTRIO | Number of synchronous read I/O operations | ||
| 144 | DB2QBSTT - QBSTRPI | Number of page inserts required for read I/O | ||
| 145 | DB2QBSTT - QBSTRTO | Number of recall timeouts | ||
| 146 | DB2QBSTT - QBSTSEQ | Number of sequential prefetch requests | ||
| 147 | DB2QBSTT - QBSTSGT | Number of get page requests issued by sequential access req. | ||
| 148 | DB2QBSTT - QBSTSIO | Synchronous read requests issued by sequential access req. | ||
| 149 | DB2QBSTT - QBSTSPD | Sequential prefetch disabled - no buffers available | ||
| 150 | DB2QBSTT - QBSTSPP | Number of pages read because of normal sequential prefetch | ||
| 151 | DB2QBSTT - QBSTSWS | Update intents against pages in the buffer pool | ||
| 152 | DB2QBSTT - QBSTVPA | Number of successful virtual buffer pool expans./contract. | ||
| 153 | DB2QBSTT - QBSTWBVQ | Number of Pages Removed from the DWQ for Destructive Read | ||
| 154 | DB2QBSTT - QBSTWDRP | Number of pages for which destructive read was requested | ||
| 155 | DB2QBSTT - QBSTWEE | A write engine is unavailable for asynchronous write I/O | ||
| 156 | DB2QBSTT - QBSTWFD | Work file requests were rejected due to buffer pool shortage | ||
| 157 | DB2QBSTT - QBSTWFF | Number of times a merge pass could not be performed | ||
| 158 | DB2QBSTT - QBSTWFM | Maximum number of work files concurrently used | ||
| 159 | DB2QBSTT - QBSTWFR | Number of merge passes requested for DB2 sort activities | ||
| 160 | DB2QBSTT - QBSTWFT | Number of merge passes requested for DB2 sort activities | ||
| 161 | DB2QBSTT - QBSTWIO | Number of asynchronous writes | ||
| 162 | DB2QBSTT - QBSTWKPD | Number of work prefetches not scheduled due to zero prefetch | ||
| 163 | DB2QBSTT - QBSTWPI | Number of page inserts required for write I/O | ||
| 164 | DB2QBSTT - QBSTXFL | Number of times the virtual buffer pool was full | ||
| 165 | DB2QBSTT - QBSTXFV | Total number of virtual buffer pool or hiperpool failures | ||
| 166 | DB2QBSTT - QBSTXIS | Highest number of concurrent prefetch I/O streams | ||
| 167 | DB2QDBP - QDBPNM | Name of buffer pool | ||
| 168 | DB2QDBP - QDBPNM | Name of buffer pool | ||
| 169 | DB2_VIEW_BP - ACTIVITY_TAB | DB2_VIEW_BP-ACTIVITY_TAB | ||
| 170 | DB2_VIEW_BP - ACTIVITY_TAB | DB2_VIEW_BP-ACTIVITY_TAB | ||
| 171 | DB2_VIEW_BP - ACTIVITY_TAB | DB2_VIEW_BP-ACTIVITY_TAB | ||
| 172 | DB2_VIEW_BP - ACTIVITY_TAB | DB2_VIEW_BP-ACTIVITY_TAB | ||
| 173 | DB2_VIEW_BP - ACTIVITY_TAB | DB2_VIEW_BP-ACTIVITY_TAB | ||
| 174 | DB2_VIEW_BP - ACTIVITY_TAB | DB2_VIEW_BP-ACTIVITY_TAB | ||
| 175 | DB2_VIEW_BP - CONFIG_TAB | DB2_VIEW_BP-CONFIG_TAB | ||
| 176 | DB2_VIEW_BP - CONFIG_TAB | DB2_VIEW_BP-CONFIG_TAB | ||
| 177 | DB2_VIEW_BP - CONFIG_TAB | DB2_VIEW_BP-CONFIG_TAB | ||
| 178 | DB2_VIEW_BP - DEFAULT_TAB | DB2_VIEW_BP-DEFAULT_TAB | ||
| 179 | DB2_VIEW_BP - DS_DATA | DB2_VIEW_BP-DS_DATA | ||
| 180 | DB2_VIEW_BP - DS_DATA | DB2_VIEW_BP-DS_DATA | ||
| 181 | DB2_VIEW_BP - DS_DATA | DB2_VIEW_BP-DS_DATA | ||
| 182 | DB2_VIEW_BP - DS_DATA | DB2_VIEW_BP-DS_DATA | ||
| 183 | DB2_VIEW_BP - DS_DATA | DB2_VIEW_BP-DS_DATA | ||
| 184 | DB2_VIEW_CONTROLLER - MEMBER | DB2 member name in data sharing environment | ||
| 185 | DB2_VIEW_CONTROLLER - MEMBER | DB2 member name in data sharing environment | ||
| 186 | DB2_VIEW_CONTROLLER - MEMBER | DB2 member name in data sharing environment | ||
| 187 | DB2_VIEW_CONTROLLER - MEMBER | DB2 member name in data sharing environment | ||
| 188 | DB6NAVSYST - DBCNAME | Logical name for a database connection | ||
| 189 | DB6NAVSYST - DBCNAME | Logical name for a database connection | ||
| 190 | DB6NAVSYST - DBCNAME | Logical name for a database connection | ||
| 191 | DB6NAVSYST - DBCNAME | Logical name for a database connection | ||
| 192 | DB6TSTAMP_STRUCT - DATE | System Date | ||
| 193 | DB6TSTAMP_STRUCT - TIME | System Time | ||
| 194 | DB6_ALV_DESCR - FIELDDESCR | DB6_ALV_DESCR-FIELDDESCR | ||
| 195 | DB6_ALV_DESCR - FIELDDESCR | DB6_ALV_DESCR-FIELDDESCR | ||
| 196 | DB6_ALV_DESCR - FIELDDESCR | DB6_ALV_DESCR-FIELDDESCR | ||
| 197 | DB6_ALV_DESCR - GRID | DB6_ALV_DESCR-GRID | ||
| 198 | DB6_ALV_DESCR - LAYOUT | DB6_ALV_DESCR-LAYOUT | ||
| 199 | DB6_ALV_DESCR - LAYOUT | DB6_ALV_DESCR-LAYOUT | ||
| 200 | DB6_ALV_DESCR - LAYOUT | DB6_ALV_DESCR-LAYOUT | ||
| 201 | DB6_ALV_DESCR - RECEIVER | DB6_ALV_DESCR-RECEIVER | ||
| 202 | DB6_ALV_DESCR - RECEIVER | DB6_ALV_DESCR-RECEIVER | ||
| 203 | DBA_ACTION_CTRL - PARTITION_ALL_SUPPORTED | Replacement for Real Boolean Type: 'X' == True '' == False | ||
| 204 | LVC_S_FCAT - COLTEXT | ALV control: Column heading | ||
| 205 | LVC_S_FCAT - COLTEXT | ALV control: Column heading | ||
| 206 | LVC_S_FCAT - COL_OPT | Entry for Optional Column Optimization | ||
| 207 | LVC_S_FCAT - COL_OPT | Entry for Optional Column Optimization | ||
| 208 | LVC_S_FCAT - COL_POS | ALV control: Output column | ||
| 209 | LVC_S_FCAT - COL_POS | ALV control: Output column | ||
| 210 | LVC_S_FCAT - FIELDNAME | ALV control: Field name of internal table field | ||
| 211 | LVC_S_FCAT - FIELDNAME | ALV control: Field name of internal table field | ||
| 212 | LVC_S_FCAT - FIELDNAME | ALV control: Field name of internal table field | ||
| 213 | LVC_S_FCAT - HOTSPOT | ALV control: SingleClick-sensitive | ||
| 214 | LVC_S_FCAT - NO_OUT | ALV control: Column is not output | ||
| 215 | LVC_S_FCAT - NO_OUT | ALV control: Column is not output | ||
| 216 | LVC_S_FCAT - NO_OUT | ALV control: Column is not output | ||
| 217 | LVC_S_FCAT - TOOLTIP | ALV control: Tool tip for column header | ||
| 218 | LVC_S_FCAT - TOOLTIP | ALV control: Tool tip for column header | ||
| 219 | LVC_S_L002 - GRID_TITLE | ALV Control: Title bar text | ||
| 220 | LVC_S_LAYO - GRID_TITLE | ALV Control: Title bar text | ||
| 221 | LVC_S_LAYO - ZEBRA | ALV control: Alternating line color (striped) | ||
| 222 | LVC_S_LAYO - ZEBRA | ALV control: Alternating line color (striped) | ||
| 223 | SYST - DATUM | ABAP System Field: Current Date of Application Server | ||
| 224 | SYST - DATUM | ABAP System Field: Current Date of Application Server | ||
| 225 | SYST - UZEIT | ABAP System Field: Current Time of Application Server | ||
| 226 | SYST - UZEIT | ABAP System Field: Current Time of Application Server |