SAP ABAP Data Element DB2CCLEVEL (REORG Index: Change to number of index tree levels absolute)

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

Basic Data

Data Element	DB2CCLEVEL
Short Description	REORG Index: Change to number of index tree levels absolute

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	Tree level
Medium	17	Tree level change
Long	26	Tree level change absolute
Heading	26	Tree level change absolute

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. The recommendation for REORG on a indexspace is 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.

It is an input and output parameter of type INTEGER:

• When used for input, the value acts as threshold for the number of levels in the index tree that were added or removed since the last REORG, REBUILD INDEX, or LOAD REPLACE . The default is 0.
• When displayed as output, the value is the number of levels in the index tree that were added or removed since the last REORG, REBUILD INDEX, or LOAD REPLACE., if object is indexspace and there's a recommendation for REORG. Otherwise, this value is null.

History

Last changed by/on	SAP	20130604
SAP Release Created in	620