SAP ABAP Data Element DB2CLUSTRD (Whether the table is actually clustered by the index)

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	DB2CLUSTRD
Short Description	Whether the table is actually clustered by the index

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	Clustered
Medium	15	Clustered
Long	20	Clustered
Heading	9	Clustered

Documentation

Definition

N No: a significant number of rows are not in clustering order, or
statistics were not gathered.

Y Yes: most of the rows are in clustering order

The entry can be changed by the RUNSTATS utility.

History

Last changed by/on	SAP	20070813
SAP Release Created in	700