Deleting Archived History Records with CA Jobtrac r11

Products

• Jobtrac

Issue/Introduction

Description

In Jobtrac 11.0, GJTRJPRG has replaced GJTRMAHI as the Utility to use to delete old archived records based upon their age, the number of records that exist for an event, or a combination of age and number of records.

Environment

Release:
Component: JOBTRC

Resolution

In Jobtrac 11.0, GJTRJPRG has replaced GJTRMAHI as the Utility to use to delete old archived records based upon their age, the number of records that exist for an event, or a combination of age and number of records. The records deleted from the history database are no longer kept except as printed output on the Purge report. Once deleted, the records are not recoverable except from file backups.

To use the GJTRJPRG utility, you invoke the GJTRJPRG PROC and specify keywords to perform the required function. A sample GJTRJPRG PROC is located in the  JOBTRAC SAMPJCL library.  Datacom/AD and  Jobtrac libraries must be available to execute this program by steplib or linklist.

There are two new KEYWORDS that are new to the Purge process. 'STTDAYS' which defines the age in days of the statistics records to keep and 'AUDDAYS which defines the age in days of the audit records to keep.

If no values are specified for these keywords no audit or statistic records are deleted by GJTRJPRG.

Special care should be taken when the DELETE keyword is used with the EVENT keyword.  If 'EVENT=*,DELETE' is specified then all history will be deleted.

If the following is specified then the last 5 days of history will be kept and five days of statistic and audit records are kept:

EVENT=*,DAYS=05,DELETE

AUDDAYS=005

STTDAYS=005  

A good procedure to follow would be to run DBBACKUP from the SAMPJCL library to obtain a backup of your database prior to running with the DELETE keyword or run with 'NODELETE' to verify what is going to occur. 

As always, please contact Broadcom support for Jobtrac Job Management if you have further questions.