DE Housekeeping jobs

Document ID : KB000010879
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

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.

housekeeping.jpg

Instructions:

The following commands are recommend to be executed routinely to keep the DE database in healthy state.

  • MOVEHISTORYDATA
  • PURGECOMPLETEJOBS
  • DELETESTATUSMESSAGES
  • TRACELOG CLEANUP using cleanup script or command in <de_install_dir>/bin

 

Here are some examples of how to set up the jobs.

For MOVEHISTORYDATA, setup job using the default AGENT.  You may want to move historical data that is older than one month to archive tables (H_ tables).

 

MOVEHISTORYDATA.jpg 

 

 

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.

The example shows threshold as seven (7) days using a JavaScript (see below).  This will delete messages older than seven days

deletestatus.jpg

 

JavaScript example

deletestatus_js.jpg

//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();

 

Additional Information:

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.