To reduce the CA Jobtrac JM data base space utilization, a frequent cleanup job is recommended. There are three types of records that can be deleted from the CA Jobtrac JM database: AUDIT and HISTORY. Deleting these types of records frees up the Index and Data space and makes them available for later reuse. To free up the Index space for immediate reuse, the DEFRAG command is recommended.
CA JOBTRAC JM SAMPJCL(GJTRJPURG) member contains a sample job to DELETE expired AUDIT and HISTORY records from the CA Jobtrac JM database. After the records are deleted, run the following CA Datacom job to DEFRAG the CA JOBTRAC Index data set:
//IXXCOMP EXEC PGM=DBUTLTY
//STEPLIB DD DISP=SHR,DSN=YOUR.DATACM.AD.CUSLIB
// DD DISP=SHR,DSN=YOUR.DATACOM.AD.CAILIB
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
The above DEFRAG job should be defined to CA Jobtrac JM and should run weekly after GJTRPURG job.