SAP ABAP Data Element DB2SUMEXTS (Total number of extents of a TS or index (parts summed up))
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 | DB2SUMEXTS |
Short Description | Total number of extents of a TS or index (parts summed up) |
Data Type
Category of Dictionary Type | Direct Type Entry | |
Type of Object Referenced | No Information | |
Domain / Name of Reference Type | ||
Data Type | INT4 | 4-byte integer, integer number with sign |
Length | 10 | |
Decimal Places | 0 | |
Output Length | 11 | |
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 | 7 | Extents |
Medium | 14 | Sum of extents |
Long | 37 | Total sum of extents of a TS or index |
Heading | 37 | Total sum of extents of a TS or index |
Documentation
Total sum of number of extents for a tablespace or index, summed up over the partitions or extensions of this tablespace or index.
This is kind of indicating a trend. If this number is too high, you should consider a REORG to speed up data access.
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 700 |