SAP ABAP Data Element DB2BSTWFT (Number of merge passes requested for DB2 sort activities)
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
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 | DB2BSTWFT |
| Short Description | Number of merge passes requested for DB2 sort activities |
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 | Merge pass |
| Medium | 15 | Merge passes |
| Long | 20 | Merge passes |
| Heading | 12 | Merge passes |
Documentation
Definition
Total number of work files that were requested for all of the merge passes.
For DB2 to perform efficient prefetch for work files, each work file should have at least 16 dedicated buffers. Work files used during sort phase processing at other non-sort-related processing are not included in this statistics counter.
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in |
