The CA Workload Automation DE should have daily housekeeping jobs for optimal performance. A HOUSEKEEPING application is included in the Desktop Client. It is highly recommended to implement this application in to your workload and schedule it daily.
The following commands are recommend to be executed routinely to keep the DE database in healthy state.
Here are some examples of how to set up the jobs.
For MOVEHISTORYDATA, setup job using the default AGENT. Move historical data that is older than one month to archive tables (H_ tables).
The DELETESTATUSMESSAGES is an important command that clears the status message tables. These tables can grow very fast in a busy environment.
The 'Arguments to pass' field has DE hostname, with port it is using, user and password of admin and the command with threshold.
//Configure how many days older statuesmessages to delete
var no_of_days = 7
var old_date = new Date();
old_date.setDate(old_date.getDate() - no_of_days);
APPL.date = (old_date.getYear()+1900)+'-'+eval(old_date.getMonth() + 1)+'-' +old_date.getDate()+' '+old_date.getHours()+':'+old_date.getMinutes()+':'+old_date.getSeconds();
It is very important to clear out the tracelogs or move them to some other location. The tracelogs can fill up the filesystem that can result in shutdown of the server. You can get more information on setting up routine clean up on tracelogs here.
Lastly, the PURGECOMPLETEDJOBS should also be part of your housekeeping. It allows you to keep your real-time tables compact and fast.