> #### Database Analysis job

> The Database Analysis job runs against an OpenEdge database and loads the information into the FathomTrendDatabase. This information can be used for various purposes, including index compaction and data analysis.

> To complete the Database Analysis Properties page:

> 1. Provide values for the Name and Description fields.
> 2. Select the database for which you want to perform this analysis from the Resources list.
> 3. Select the Enable rule validation check box to indicate that you want this job to test your rules. Utilization % and Block number, two subfields of the Enable rule validation option, are active only if you select this option. Complete these two fields as follows:
> 1. In the Utilization % field, specify the percentage of utilization of the blocks for the index to validate against. If the index utilization percentage goes below this number, you could set up an alert to trigger.
> 2. In the Block number field, specify the threshold for the number of blocks that the index must contain for the rule to be run.
> 4. Select the Run index compaction check box if you want index compaction run for the database during this job. The Compaction % field specifies the percentage to which indexes will be packed when index compaction is run.
> 5. Verify the command's current working directory in the Working directory field. If specified, this directory must exist. This property defaults to the working directory defined at installation.
> 6. To append subsequent messages to the `.out` or `.err` files, select the Append option. The Output file field indicates where messages will be retained.
> 7. 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.
> 8. 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.
> 9. 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.
> 10. 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