Data Element list used by SAP ABAP Table DB2QBGL (Statistics Group Buffer Pool)
SAP ABAP Table
DB2QBGL (Statistics Group Buffer Pool) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | DB2BGL2D | Number of requests to delete a list of pages (secondary GBP) | ||
| 2 | DB2BGL2F | Number of write requests to the secondary GBP that failed | ||
| 3 | DB2BGL2H | # Asynch IXLCACHE invocations for secondary GBP | ||
| 4 | DB2BGL2N | Number of requests to delete a page from the secondary GBP | ||
| 5 | DB2BGL2R | Number of requests to read the castout statistics (sec. GBP) | ||
| 6 | DB2BGLAC | Clean pages written asynchronously | ||
| 7 | DB2BGLAW | Changed pages written asynchronously | ||
| 8 | DB2BGLAX | Register page list request | ||
| 9 | DB2BGLAY | Changed pages - Read after register page list | ||
| 10 | DB2BGLCC | Read castout class | ||
| 11 | DB2BGLCK | GBP checkpoints triggered | ||
| 12 | DB2BGLCS | Read castout statistics | ||
| 13 | DB2BGLCT | Castout class threshold | ||
| 14 | DB2BGLDG | Unregister page | ||
| 15 | DB2BGLDN | Delete data and directory entries in GBP | ||
| 16 | DB2BGLEX | Number of explicit cross-invalidations | ||
| 17 | DB2BGLGN | Group buffer pool ID | ||
| 18 | DB2BGLGT | Group buffer pool castout threshold | ||
| 19 | DB2BGLHS | # Asynch IXLCACHE invocations for primary GBP | ||
| 20 | DB2BGLMD | Synchronous read (not found) - Data returned | ||
| 21 | DB2BGLMR | Synchronous Read (Not Found) - No Data Returned (Dir. Entry) | ||
| 22 | DB2BGLN1 | # page P-lock lock negotiations for space map pages | ||
| 23 | DB2BGLN2 | # page P-lock lock negotiations for data pages | ||
| 24 | DB2BGLN3 | # page P-lock lock negotiations for index leaf pages | ||
| 25 | DB2BGLOS | CF requests to read storage statistics | ||
| 26 | DB2BGLP1 | # page P-lock lock requests for space map pages | ||
| 27 | DB2BGLP2 | # page P-lock lock requests for data pages | ||
| 28 | DB2BGLP3 | # page P-lock lock requests for index leaf pages | ||
| 29 | DB2BGLRC | Pages cast out from GBP to DASD | ||
| 30 | DB2BGLRD | Read directory info | ||
| 31 | DB2BGLRG | Register page | ||
| 32 | DB2BGLS1 | # page P-lock lock suspensions for space map pages | ||
| 33 | DB2BGLS2 | # page P-lock lock suspensions for data pages | ||
| 34 | DB2BGLS3 | # page P-lock lock suspensions for index leaf pages | ||
| 35 | DB2BGLSW | Changed pages written synchronously to GBP | ||
| 36 | DB2BGLU1 | # page P-lock unlock requests | ||
| 37 | DB2BGLUN | Unlock castout | ||
| 38 | DB2BGLWC | Clean pages written synchronously | ||
| 39 | DB2BGLWF | Write failed - no storage | ||
| 40 | DB2BGLXD | Synchronous read (cross invalidation) - data returned | ||
| 41 | DB2BGLXR | Synchronous Read (Cross Invalidation) - No Data Returned | ||
| 42 | DB2DEC19V | dec 19 with sign |