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.