SAP ABAP Data Element DB2BSTWKPD (Number of work prefetches not scheduled due to zero prefetch)
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
⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
⤷ STU2 (Package) CCMS for DB2 for OS/390
Basic Data
Data Element | DB2BSTWKPD |
Short Description | Number of work prefetches not scheduled due to zero prefetch |
Data Type
Category of Dictionary Type | D | Domain |
Type of Object Referenced | No Information | |
Domain / Name of Reference Type | DB2DEC19V | |
Data Type | DEC | Counter or amount field with comma and sign |
Length | 19 | |
Decimal Places | 0 | |
Output Length | 26 | |
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 | pref not s |
Medium | 18 | pref not scheduled |
Long | 22 | prefetch not scheduled |
Heading | 22 | prefetch not scheduled |
Documentation
Definition
Number of times sequential prefetch was not scheduled because the prefetch quantity was zero.
Prefetch checks the prefetch quantity. Normally the quantity should be one to eight pages. When the quantity is zero, the value in this field is incremented.
If the number in this field is larger than 5% of the number of sequential prefetch reads, consider increasing the buffer pool size.
History
Last changed by/on | SAP | 20110908 |
SAP Release Created in |