SAP ABAP Data Element DB2WFPMRGP (Average Work Files per Merge Pass)
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 | DB2WFPMRGP |
| Short Description | Average Work Files per Merge Pass |
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 | 0 | |
| Medium | 0 | |
| Long | 29 | Avg.work files per merge pass |
| Heading | 0 |
Documentation
Definition
Average number of work files (runs) requested on a single merge pass.
The counter is calculated as
QBSTWFT / QBSTWFR
where
QBSTWFT:
Total number of work files that were requested for all of the merge passes.
Work files used during sort phase processing ot other non-sort-related processing are not included in this statistics counter.
QBSTWFR:
Total number of merge passes for DB2 sort activities.
This counter reflects how many merge passes were requested for DB2 to determine the number of work files permitted to support each merge pass.
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in | 700 |
