Data Element list used by SAP ABAP Table DB2QBSTT (DB2 CL - Buffer manager statitics block)
SAP ABAP Table DB2QBSTT (DB2 CL - Buffer manager statitics block) is using
# | Object Type | Object Name | Object Description | Note |
---|---|---|---|---|
1 | Data Element | DB2BSTBPNM | DB2 buffer pool name | |
2 | Data Element | DB2BSTCBA | Number of currently active (non-stealable) buffers | |
3 | Data Element | DB2BSTDIO | Number of dynamic prefetch reads | |
4 | Data Element | DB2BSTDMC | Number of times the data manager threshold was reached | |
5 | Data Element | DB2BSTDPF | Number of dynamic prefetch requests | |
6 | Data Element | DB2BSTDPP | Number of pages read via dynamic prefetch read I/O | |
7 | Data Element | DB2BSTDSO | Number of datasets successfully opened physically | |
8 | Data Element | DB2BSTDWT | Number of times the deferred write threshold was reached | |
9 | Data Element | DB2BSTDWV | Number of times vertical deferred write threshold is reached | |
10 | Data Element | DB2BSTGET | Number of get page requests (conditional and unconditional) | |
11 | Data Element | DB2BSTIMW | Number of immediate writes | |
12 | Data Element | DB2BSTJIS | Total number of denied concurrent prefetch I/O streams | |
13 | Data Element | DB2BSTLIO | Number of list prefetch reads | |
14 | Data Element | DB2BSTLPF | Number of list prefetch requests | |
15 | Data Element | DB2BSTLPL | Number of times one or more pages were added to LPL | |
16 | Data Element | DB2BSTLPP | Number of pages read via list prefetch | |
17 | Data Element | DB2BSTMAX | Number of times a work file could not be opened | |
18 | Data Element | DB2BSTMIG | Number of times migrated datasets were encountered | |
19 | Data Element | DB2BSTNGT | # of unsuccessful GETPAGE due conditional GETPAGE request | |
20 | Data Element | DB2BSTPIO | Number of sequential prefetch reads | |
21 | Data Element | DB2BSTPL1 | Prefetch quantity is reduced from normal to 50% | |
22 | Data Element | DB2BSTPL2 | Number of occurrences of prefetch quantity reduced 1/4 | |
23 | Data Element | DB2BSTPQF | The parallel query went into reduced or degenerated mode | |
24 | Data Element | DB2BSTPQO | Total no. of requests for parallel query support | |
25 | Data Element | DB2BSTPWS | Number of pages written | |
26 | Data Element | DB2BSTREE | Sequential prefetch disabled - unavailable read engine | |
27 | Data Element | DB2BSTRIO | Number of synchronous read I/O operations | |
28 | Data Element | DB2BSTRPI | Number of page inserts required for read I/O | |
29 | Data Element | DB2BSTRTO | Number of recall timeouts | |
30 | Data Element | DB2BSTSEQ | Number of sequential prefetch requests | |
31 | Data Element | DB2BSTSGT | Number of get page requests issued by sequential access req. | |
32 | Data Element | DB2BSTSIO | Synchronous read requests issued by sequential access req. | |
33 | Data Element | DB2BSTSPD | Sequential prefetch disabled - no buffers available | |
34 | Data Element | DB2BSTSPP | Number of pages read because of normal sequential prefetch | |
35 | Data Element | DB2BSTSWS | Update intents against pages in the buffer pool | |
36 | Data Element | DB2BSTVPA | Number of successful virtual buffer pool expans./contract. | |
37 | Data Element | DB2BSTVPL | Number of buffers allocated for virtual buffer pool | |
38 | Data Element | DB2BSTWBVQ | Number of Pages Removed from the DWQ for Destructive Read | |
39 | Data Element | DB2BSTWDRP | Number of pages for which destructive read was requested | |
40 | Data Element | DB2BSTWEE | A write engine is unavailable for asynchronous write I/O | |
41 | Data Element | DB2BSTWFD | Work file requests were rejected due to buffer pool shortage | |
42 | Data Element | DB2BSTWFF | Number of times a merge pass could not be performed | |
43 | Data Element | DB2BSTWFM | Maximum number of work files concurrently used | |
44 | Data Element | DB2BSTWFR | Number of merge passes requested for DB2 sort activities | |
45 | Data Element | DB2BSTWFT | Number of merge passes requested for DB2 sort activities | |
46 | Data Element | DB2BSTWIO | Number of asynchronous writes | |
47 | Data Element | DB2BSTWKPD | Number of work prefetches not scheduled due to zero prefetch | |
48 | Data Element | DB2BSTWPI | Number of page inserts required for write I/O | |
49 | Data Element | DB2BSTXFL | Number of times the virtual buffer pool was full | |
50 | Data Element | DB2BSTXFV | Total number of virtual buffer pool or hiperpool failures | |
51 | Data Element | DB2BSTXIS | Highest number of concurrent prefetch I/O streams | |
52 | Data Element | DB2DEC19V | dec 19 with sign | |
53 | Data Element | DB2DEC19V | dec 19 with sign | |
54 | Data Element | DB2DEC19V | dec 19 with sign | |
55 | Data Element | DB2DEC19V | dec 19 with sign | |
56 | Data Element | DB2DEC19V | dec 19 with sign | |
57 | Data Element | DB2MEMN | DB2 member name in data sharing environment | |
58 | Data Element | DB2NUMC10 | Field type numc, length 10, integer |