Is there a way to purge autoaggr data based on a time range?
DBMaint is not designed to perform such operation.
There is no utility to delete a selected range of records from these tables.
You can delete ALL the aggregated job, alarm, and scheduler statistics in the following situations:
- When you want the aggregation process to regenerate all statistics.
- When you no longer want to store the aggregated statistics in the database.
- When you delete aggregated statistics, the statistics in the ujo_rep_hourly, ujo_rep_daily, ujo_rep_weekly, and ujo_rep_monthly tables are deleted.
Follow these steps:
Open the UNIX operating system prompt or the Windows instance command prompt as follows:
(UNIX) Run the shell that is sourced to use CA Workload Automation AE.
The operating system command prompt appears.
(Windows) Click Start, Programs, CA, Workload Automation AE, Command Prompt (instance_name).
The instance command prompt appears.
Enter the following command:
sendevent - E AGGREGATE [-l {HOURLY|DAILY|WEEKLY|MONTHLY} -d
These tables are not huge because:
- ujo_rep_* tables should not have more than 8K
- ujo_rep_daily table adds only 1 row per day.
- ujo_dep_monthly adds only 1 row every month.
- ujo_rep_weekly - adds one record every week.
- ujo_rep_hourly - adds 1 record per hour.