Autotrack Log Retention

Products

• CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

How can I find/set/modify log retention time for the autotrack command?

Environment

CA Workload Automation AE

Resolution

The number of days retained in the AutoSys database is configurable. It is determined by the following command in the $AUTOSYS/bin/DBMaint file:

archive_events -A -l 7  -b 50000 >> $outfile 2>&1

Default retention is 7 days. This can be adjusted.

Any data that is purged from the database is logged into files under $AUTOUSER/archive. These files will build up indefinitely as long as autotrack is enabled. We recommend setting up an automated job to remove these files after X days.

Consider database sizing if you do increase the number of days to retain. The two tables where the data is kept are:

ujo_audit_info
ujo_audit_msg