DE Housekeeping jobs

book

Article ID: 10879

calendar_today

Updated On:

Products

DSERIES- SERVER CA Workload Automation DE - System Agent (dSeries)

Issue/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.

 

Environment

Release: DSWAHA01300-12-Workload Automation DE-High Availability
Component:

Resolution

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.  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.

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

JavaScript example

//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.

Attachments