Select Archive Files

The Select Archive File(s) dialog lists the Archive Directory entries for files that match criteria in the Archive File Filters dialog.

These dialogs are similar to those described in Archive Directory Maintenance; however, the Select Archive File(s) dialog differs from the Archive Directory Maintenance dialog by allowing you to select names of multiple Archive Files.

Select Archive File(s) dialog with multiple Archive Files

To select Archive Files for index maintenance, hold the Ctrl or Shift key while clicking file names, then click Select. To select a single Archive File, double-click the file name or select the file name and click Select.

The Select All button allows you to select all Archive Files listed on the Select Archive File(s) dialog. The Select Matching button allows you to select the Archive Files with names that match the criteria specified in the Archive File Filters. After you select the Archive Files, the Index Maintenance dialog is displayed.

Note: You cannot select names of Archive Files with Inaccessible status.

Grouping Files

If the Archive Files contain tables with the same name but different qualifiers, you will receive a prompt asking if you want to group the tables by table name alone or with qualifiers.

Prompt that asks you to group tables by table name only or by DB Alias, Creator ID, and table name

Equality Rules for Multiple Tables

When you use multiple tables, the utility matches tables, columns, and indexes according to the following rules: