How to DEFRAG the CA Jobtrac Job Management Index (IXX) data set after DELETE HISTORY?

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

Description:

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.

Solution:

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   * 
  DEFRAG DBID=161 
  COMM OPTION=STATS,DBID=161              
/* 

The above DEFRAG job should be defined to CA Jobtrac JM and should run weekly after GJTRPURG job.