Generating Archive Indexes

To generate the Archive Indexes defined in the Indexes tab, click File > Run, or click the Run toolbar button.

A Personal Option determines whether you are prompted to confirm that you want to overwrite any Archive Index Files with Exists status on the Files tab.

During the Archive Index generation process, the Archive Index Generation Progress dialog displays a log of processing activity. The log groups Archive Files by Server. For each table in an Archive File, the log displays the results of the process for each index.

Archive Index Generation Progress dialog

Select Return to the editor when this dialog is closed to return to the Index Maintenance dialog after you close the Archive Index Generation Progress dialog.

Click Cancel Process to cancel the Archive Index process. A confirmation dialog prompts to verify that you want to cancel the process. Any Archive Index Files created up to the point of cancellation are retained.

For each index that is processed, the log will show the following:

When the Archive Index process is complete, you can save or print the Archive Index Process Log. To save the log, click File > Save As. To print the log, click File > Print. The log is also stored in the Temp directory in the format aixmnnnn.tmp, where nnnn is a four-digit number.

Index Generation Process

If all columns selected for an index do not occur in every occurrence of the table, the Index Maintenance Utility may either truncate the index or not process it, depending on the position of the missing columns.

If all columns selected for an index are included in every occurrence of the table, but more than 16 columns have been selected for the index, the utility will not create the index.

If a column selected for an index exceeds 255 characters, a column contains a LOB, or the total data length of all columns in an index exceeds 512 characters, the utility will not create the index.

If an index name is used for another index for the same table, the utility will rename subsequent occurrences of the index.

Once a table has 16 indexes, the utility will not create any additional indexes for the table.