Hierarchy
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-DB2 (Application Component) DB2 for z/OS⤷
STU2 (Package) CCMS for DB2 for OS/390
Basic Data
| Data Element | DB2BACNGT |
| Short Description | Unsuccesful Page at Conditional Getpage Request |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | DB2INT4U | |
| Data Type | INT4 | 4-byte integer, integer number with sign |
| Length | 10 | |
| Decimal Places | 0 | |
| Output Length | 10 | |
| 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 | Un.Pg.req. |
| Medium | 15 | Unsuc.Pg.requ. |
| Long | 26 | Unsuccessful page requests |
| Heading | 0 |
Documentation
Definition
Number of times a page requested for a query processed in parallel was unavailable because an I/O was in progress or the page was not found in the buffer pool. The agent does not wait. Instead, control returns to the agent. This counter is used only when queries are processed in parallel.
If the value is close to zero, most pages are already prefetched into the buffer pool and wait time for synchronous I/O is small. The counter can be high if, for example, there is a cluster index scan and the data is not truly clustered by the index key, so the data pages are not accessed in their true order. Hence, the cluster ratio is not valid. Use the runstats utility to update it.
This number is also used to determine how many sequential prefetches of one page were scheduled.
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in |
