Create Index: Type panel

You use the Create Index: Type panel to specify information to define the type of index to be created.

Panel and field definitions

  Process   Options   Utilities   Help
                                                                                
 FM/Db2 (DFG2)                Create Index Type

 Index Type Options:
    Uniqueness
    1 1. Non-Unique
      2. Unique
      3. Unique Not Null

 Clustering Index Option:
    Enter '/' to select option
    / Clustering Index (required for partitioned indexes)

 Non-Partitioned Index:
    Piecesize  . . . .              Multiplier
                                     1. K (1024)
                                     2. M (1048576)
                                     3. G (1073741824)




 (Specify the partitions for a partitioned index using Create Index option 5)
 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F4=CRetriev  F7=Backward  F8=Forward
  F9=Swap     F10=Actions  F12=Cancel
1. Non-Unique
Duplicate index values are permitted.
2. Unique
Distinct values for all entries in the index.
3. Unique Not Null
Distinct values for all not null entries in the index.
Clustering Index Option
Enter a / to specify a clustering index (CLUSTER keyword).
Piecesize
You can specify a maximum addressability for each piece (data set of a non-partitioning index). The values entered must be powers of 2, and the valid values depend on the multiplier.
  • If the multiplier is K, valid values are 2**n between 256 and 67 108 864 inclusive.
  • If the multiplier is M, valid values are 2**n between 1 and 66 536 inclusive.
  • If the multiplier is G, valid values are 2**n between 1 and 64 inclusive.

Parent panels

Child panels

None.

Related tasks