Creating an index

To create a new index, perform the following on the Db2® Object Functions panel:

1. Type 6 in the Object Type entry field.
2. Type C on the command line.
3. Press Enter. FM/Db2 displays the Create Index panel.

Use the Create Index panel to create an index for a pre-existing base table.

The top section of the panel contains five input fields that define the index to be created. If you entered object name information on the Db2® object functions panel, these values are carried forward and the appropriate name fields are pre-filled.

The bottom part of the panel contains a list of options that need to be completed to define the index. There is a single selection field, in which you can type the number of the required option.

The first option is required (define the columns in the index). Typically, the third option is needed (define the space requirements for the index).

When the index has been completely specified, you select option 7 to create the index.

Related tasks

• Index type (Create Index)
• Index Column Selection (Create Index)
• Allocation (Create Index)
• Index (Create Index)
• Index Partitions (Create Index)
• Partition Values Option (Create Index)

Related references

• Db2 Object Functions panel
• Create Index panel
• Create Index: Type panel
• Create Index: Column Selection panel
• Create Index: Allocation panel
• Create Index: Options panel
• Create Index: Partitions panel
• Create Index: Partition Values panel