SAP ABAP Data Element DB2RBIXFLD (Index definitions for the REBUILD INDEX statement)
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 DB2RBIXFLD
Short Description Index definitions for the REBUILD INDEX statement  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type DB2RBIXFLD    
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 REBUILD IX 
Medium 15 REBUILD INDEX 
Long 30 REBUILD INDEX parameter 
Heading 0   
Documentation

Definition

For the REBUILD INDEX you can specify the following paramters:

  • INDEX
  • TABLESPACE
  • PART

The parameters are separated by a comma.

Syntax: INDEX <indexname>,PART <partitionnumber>,INDEX <indexname>,INDEX <indexname>

The parameters listed above have the following syntax:

  • INDEX
    • Description: Indicates the qualified name of an index.
    • Syntax: INDEX <creator>.<indexname>
    • Comment: The index name must be specified by the creator and the index name, and these must be separated by a period. Each index name must be preceded by the prefix INDEX.
  • TABLESPACE
    • Description: Specifies the tablespace from which all indexes are to be recovered.
    • Syntax: TABLESPACE <dbname>.<tsname>
    • Comment: The tablespace name must be specified by the database and tablespace name and these are separated by a period. Each tablespace name must be preceded by the prefix TABLESPACE.
  • PART
    • Description: Specifies the physical partition of a partitioned index or the logical partition of a nonpartitioned index in a partitioned tablespace that is to be recovered.
    • Syntax: PART <partitionnumber>
    • Comment: Parameter PART is the PARTITION of an indexspace or a tablespace. PART must be followed by a number.

If you specify INDEX ALL, all other indexes are ignored in the generated utility statement preview. Only the INDEX ALL statement is executed.

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