Create Index panel
You use the Create Index panel to create an index for a pre-existing base table.
Panel and field definitions
Process Options Utilities Help
ZDT/Db2 (DFG2) Create Index
New Index:
Owner . . . . . . . + (optional)
Name . . . . . . . +
Table Owner . . . . + (optional)
Table Name . . . . +
Buffer Pool . . . . (optional, BP0-BP49)
Index Creation:
Creation Options
2 1. Index type (optional)
2. Index columns (required, except on auxiliary tables)
3. Allocation (optional, usually needed)
4. Index options (optional)
5. Partitions (partitioned indexes only)
6. Partition values (required for partitioned indexes)
7. Create the index
Command ===>
F1=Help F2=Split F3=Exit F4=Expand F7=Backward F8=Forward
F9=Swap F10=Left F11=Right F12=Cancel
- Owner
- The owner of the index.
- Name
- The name of the index. This is a required field.
- Table Owner
- The SQLID used to create the table on which the index is being defined.
- Table Name
- The name of the table on which the index is being created. This is a required field. You can enter the name of the table on which the index is created. A validation check needs to be performed to verify that the table exists.
- Buffer Pool
- The name of the buffer pool in which the index data sets are created.
- Creation Options
- Specify the number of the creation option you want to use:
- 1. Index type
- To specify information to define the type of index to be created. Displays the Create Index: Type panel.
- 2. Index columns
- To select the columns that comprise the index. Displays the Create Index: Column Selection panel.
- 3. Allocation
- To specify the space requirements for the index being created. displays the Create Index: Allocation panel.
- 4. Index options
- To specify information to define options for the index to be created. Displays the Create Index: Options panel.
- 5. Partitions
- To specify space information for index partitions. displays the Create Index: Partitions panel.
- 6. Partition values
- To specify limit values for index entries in each partition. displays the Create Index: Partition Values panel.
- 7. Create the index
- When you have finished specifying details for the index to be created, select this creation option to create the index.
Parent panels
Child panels
To display this panel… | Use/do this |
---|---|
Create Index: Type panel | Creation option 1 |
Create Index: Column Selection panel | Creation option 2 |
Create Index: Allocation panel | Creation option 3 |
Create Index: Options panel | Creation option 4 |
Create Index: Partitions panel | Creation option 5 |
Create Index: Partition Values panel | Creation option 6 |