SAP ABAP Data Element DB2CCEXT (Number of allowable dataset extents)
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 | DB2CCEXT |
| Short Description | Number of allowable dataset extents |
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 | 10 | Extents |
| Medium | 15 | Number extents |
| Long | 20 | Number of extents |
| Heading | 17 | Number of Extents |
Documentation
Definition
Beginning with DB2 V7.1, SAP utilizes a stored procedure named DSNACCOR which recommends running a utility based upon data in the real-time statistic tables These recommendations are based on a complex calculation, which is detailed in DB2 UDB for OS/390 and z/OS V7 Utility Guide and Reference. This is one of the values that is used in the calculation for recommending RUNSTATS, REORG and altering data set allocations of a table- or indexspace.
It is an input and output parameter of type INTEGER:
- When used for input, the value specifies a criterion for recommending that the RUNSTATS or REORG utility should be run on a table space or index space. It also specifies that DSNACCOR should warn the user that the table space or index space has used too many extents. If the number of physical extents in the index space, table space, or partition is greater than this value, DSNACCOR recommends running RUNSTATS or REORG and altering data set allocations. The default is 25 (Extent threshold: Severity 2).
- When displayed as output, the value is the number of physical extents in the table space, index space, or partition, if there's a recommendation for altering data set allocations. Otherwise, this value is null.
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in | 620 |
