Setting up an Index Compaction job

The Index Compaction job compacts indexes to optimal compression and can be run online or offline. To determine which indexes to compact, run database analysis against the database whose indexes you intend to compact.

1. Provide values for the Name and Description fields.

2. Select the database for which you are performing this activity.

3. Complete the following fields:

Table name — Identifies the table on which you intend to perform the index compaction activity

Index name — Identifies the index name for which you intend to perform the index compaction activity

Compaction % — Specifies the percentage to which indexes will be packed when index compaction is run

4. Verify that the Working directory field identifies the command's current working directory. If specified, this directory must exist. This property defaults to the OpenEdge Management working directory defined at installation.

5. To append subsequent messages to the .out or .err files, select the Append option. The Output file field indicates where messages will be retained.

6. Select the Debug log file option to obtain diagnostic details that help debug job properties when setting up a job. For example, you can set this option and use the Run Now feature on the Job Summary page. Once you have submitted the job, OpenEdge Management makes debug data available through the debug log file link on the Job Summary page.

7. Select the Indicate if the job can be used as an action option if you want this job to appear in the list of actions that can be selected for execution from the Alerts and Job completion action page.

8. If you intend to set up actions and alerts for this job, click the Edit button associated with the Completion Actions and Alerts field to display the Job Completion Actions and Alerts page. See OpenEdge Management: Resource Monitoring for more information about the Job Completion Actions and Alerts page.

9. Click Save. The Job Summary page appears. You can now schedule the job to run at a later time, or you can run it immediately. You can also edit advanced information. See Editingadvanced job information for additional details.