Indexes

The Indexes option screen displays when you select option 3 from the Object Selection menu. It lets you specify whether you want to create, alter, drop, or model an index. The following figure shows a sample screen.

Indexes Option Screen

Menu Utilities Help
------------------------------------------------------------------------------------
File-AID for DB2                                Indexes                SSID ===> DSN
OPTION ===>

   C - Create INDEX
   A - Alter INDEX
   D - Drop   INDEX
   M - Model INDEX

Specify Index Information:      (* or pattern for list):
   Creator        ===> TSOID01
   Index Name     ===> EMP

Specify CREATE Index Options:   (* or pattern for list):
   Table Creator ===> TSOID01
   Table Name     ===> EMPNO

OPTION

Specify the letter that represents the activity you want to pursue.

C	Create an index.
A	Alter an index.
D	Drop an index.
M	Model an index and create a new index.

Specify Index Information: (* or pattern for list) Area

Creator

Specify your creator ID. You can also specify a generic name with * (asterisk), or a pattern. This displays the Index Selection window, from which you can select a specific object.

Index Name

Name of the index you want to create, alter, drop, or model. Required if you are modeling an index. You can also specify a generic name with * (asterisk), or a pattern. This displays the Index Selection window, from which you can select a specific object.

Specify CREATE Index Options: (* or pattern for list) Area

Table Creator

ID of the user who created the table on which the index is based. This field is required if you are creating an index. If this information is in your user profile (see Defaults-and-user-parameters-function for details), the field is prefilled. Required when you are creating an index.

You can also specify a generic name with * (asterisk), or a pattern. This displays the Index Selection window, from which you can select a specific object.

Table Name

Name of the table on which the index is based. If you have just finished creating the table, the field is prefilled. This field is required if you are creating an index. Not used if you are modeling an index.

You can also specify a generic name with * (asterisk), or a pattern. This displays the Index Selection window, from which you can select a specific object.

Important

When you press Enter from the Indexes screen, or from the Index Selection window, File-AID for Db2 Object Administration displays. Refer to File-AID for Db2 Object Administration User Reference for information.