Create Index panel

Panel and field definitions

  Process   Options   Utilities   Help
                                                                                
 FM/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.