Try OpenEdge Now
skip to main content
Trend Database Guide and Reference
Database Compaction Job : Creating compaction job instances

Creating compaction job instances

The Data Compaction job compacts and purges data in the OpenEdge Management Trend Database. The primary purpose of this job is to help you to manage the size of the database.
To access the job, choose Jobs > New > Job from a Template. Then choose the DataCompaction link on the Create Custom Job page. The Data Compaction Job page appears, as shown in the following figure.
Figure 1. Data Compaction Job page
You must complete the necessary fields on the page to set up and run a database compaction job instance.
To set up and run a data compaction job:
1. Provide values for the Name and the Description fields. Name is a required field.
2. In the Compact trend data more than days old field, identify the number of days for which you intend to compact data. A day, as defined for this field, begins at midnight. This is a required field.
Note: You can compact only data that is more than a week old. If you enter a value of 1-6, no data compaction will take place.
In the Purge archived data more than days old field, specify the number of days of data you want purged from the database.
3. Enter a value in the Working directory field. The Working directory field identifies the command's current working directory, and the directory you specify must exist. This property defaults to the working directory defined at installation.
4. Enter values in the Output file (stdout) and Output file (stderr) fields. The stdout location indicates where messages will be stored and the stderr location indicates where error messages will be stored. To append subsequent messages to these files, select the Append option.
5. Select the Debug log file option to obtain diagnostic details that help you 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 trace file data available through the debug trace file link in the Job History section of the Job Summary page.
6. Select the Action option to indicate if the job can be used as an action. See OpenEdge Management: Resource Monitoring for more information about actions.
If you intend to set up actions and alerts for this job, click the Edit button associated with the Completion Actions and Alerts field. The Job Completion Actions and Alerts page appears:
7. Define any actions or alerts, then click Save to return to the Data Compaction Job page. See OpenEdge Management: Resource Monitoring for more information about associating actions with alerts.
The summary page appears:
Once you create a Data Compaction job instance, you can view and edit the job's advanced information.