SAP ABAP Data Element DB2RBIXFRQ (Controls the collection of frequent value statistics)

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	DB2RBIXFRQ
Short Description	Controls the collection of frequent value statistics

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	DB2RBIXFRQ
Data Type	CHAR	Character String
Length	80
Decimal Places	0
Output Length	80
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	Statistic
Medium	17	Value statistic
Long	30	Frequent value statistic
Heading	0

Documentation

Definition

Controls the collection of frequent value statistics.

You can specify the following parameters:

• NUMCOLS
• COUNT

The parameters are separated by a comma.

Syntax: NUMCOLS <numcolsnumber>,COUNT <countnumber>

The parameters listed above have the following syntax:

• NUMCOLS
• Description: Indicates the number of key columns to concatenate together when collecting frequent values from the specified index.
• Syntax: NUMCOLS <numcolsnumber>
• COUNT
• Description: Indicates the number of frequent values to be collected.
• Syntax: COUNT <countnumber>

History

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