SAP ABAP Data Element DB2RTSSORT (SORTDATA option of the REORG TABLESPACE utility)
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 | DB2RTSSORT |
| Short Description | SORTDATA option of the REORG TABLESPACE utility |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | DB2YNFLAG | |
| Data Type | CHAR | Character String |
| Length | 1 | |
| Decimal Places | 0 | |
| Output Length | 1 | |
| 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 | SORTDATA |
| Medium | 15 | SORTDATA |
| Long | 20 | SORTDATA |
| Heading | 8 | SORTDATA |
Documentation
Definition
Specifies that the data is to be unloaded by tablespace scan, then sorted in clustering order. Records always are sorted by the table in order to retain the clustering of records of the same table.
This option is recommended to improve performance unless one of the following is true:
- The data is in perfect clustering order and the REORG utility is used to reclaim space from dropped tables.
- The dataset is very large and there is not enough DASD available for sorting.
- The longest possible composite record size is greater than 32760.
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in | 700 |
