SAP ABAP Data Element DB2BPHRL (Hit ratio)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DB2 (Application Component) DB2 for z/OS
⤷
STU3 (Package) Development Class for Database Monitor
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-DB2 (Application Component) DB2 for z/OS⤷
STU3 (Package) Development Class for Database Monitor
Basic Data
| Data Element | DB2BPHRL |
| Short Description | Hit ratio |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | DB2DEC13_2 | |
| Data Type | DEC | Counter or amount field with comma and sign |
| Length | 12 | |
| Decimal Places | 2 | |
| Output Length | 16 | |
| Value Table |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | ||
| Default Component name | ||
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 10 | Hit ratio |
| Medium | 15 | Hit ratio (%) |
| Long | 20 | Hit ratio (%) |
| Heading | 20 | Hit ratio (%) |
Documentation
Definition
The hit ratio of a buffer pool is defined as the total number of GETPAGE
operations minus the number of pages read from DASD (both synchronously
and using prefetch), divided by the total number of GETPAGE operations,
and multiplied by 100.
The highest possible hit ratio is 100%, that is, when every page
requested is always in the buffer pool. If the requested page is not in
the buffer pool, the hit ratio is 0% or less. If the hit ratio is
negative, this means that prefetch brought pages into the buffer pool
that are not subsequently referenced, either because the query stops
before it reaches the end of the table space, or because the prefetched
pages are stolen by DB2 for reuse before the query can access them.
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in | 710 |
