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.

To complete the Index Compaction Properties page:

  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 — Identify the table on which you intent to perform the index compaction activity.
    • Index name — Identify the index name for which you intend to perform the index compaction activity.
    • Compaction % — Specify 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 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, Fathom 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 check box if you want this job to appear in the list of actions that can be selected to be executed 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. The Job Completion Actions and Alerts page appears. See the Resource Monitoring Guide 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 or run it immediately. You can also edit advanced information. See the "Advanced information" section for steps on editing advanced information.

Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095