How to suppress autoaggr data for a time frame?

Document ID : KB000016752
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

Is there a way to purge autoaggr data based on a time range?

Environment:
Autosys 11.3.6 on Linux but same question applies to all the other releases and platforms.
Answer:

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.