Reduce space usage CA Scheduler IXX and Data (ACH) areas by removing obsolete MAIL box and AUDIT trail records.

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

Introduction:

To reduce the percent full of the Index and Data areas for your CA Scheduler Datacom data base, the IXX and ACH data sets should be expanded. But first, you should try deleting old MAIL box and AUDIT trail records. This technical document addresses the cleanup of the mailbox and audit trail records. This procedure can be executed with both CA Scheduler and CA Datacom remaining active.

 

Instructions:

Run the following job to clean up the obsolete audit trail and mailbox records.  This sample job is also located in the CA Scheduler CAIMAC data set, member name CHCLEAN.

 //CLEANUP  EXEC CAJUTIL0
 //SYSIN    DD *
 DELETE AUDIT KEEP=3         DELETE AUDIT 3 DAYS OLD OR OLDER
 DELETE MAILBOX KEEP=3       DELETE MAILBOX 3 DAYS OLD OR OLDER
 //

Note that some sites require a longer retention period for these records and therefore verify your site retention policy before running the cleanup job.

The CHCLEAN job can be defined to CA Scheduler so it will run every day immediately after AUTOSCAN or at anytime you deem necessary.  SAMPJCL member ISTEP34 contains JCL to define the CHCLEAN job to CA Scheduler to run every after AUTOSCAN.

If you have multiple copies of CA Scheduler, CHCLEAN should run on every copy of CA Scheduler.

After the cleanup job has completed, run the following CA Datacom report job to see the new space utilization.

 //REPORT   EXEC PGM=DBUTLTY,REGION=4M
 //STEPLIB  DD   DISP=SHR,DSN=YOUR.DATACOM.AD.CUSLIB
 //              DD   DISP=SHR,DSN=YOUR.DATACOM.AD.CAILIB
 //SYSPRINT DD   SYSOUT=*
 //CXX       DD   DISP=SHR,DSN=YOUR.DATACOM.AD.CXX
 //SYSIN    DD   *
 COMM OPTION=STATS,DBID=430
 REPORT AREA=CXX,DBID=430,TYPE=A
 //

Sample report output:

 DATACOM/AD                   DATA AREA SPACE UTILIZATION REPORT

 AREA DATA   TOTAL      TOTAL    TOTAL    USED    PERCENT
 NAME BASE   TRACKS    RECORDS   BLOCKS   BLOCKS  FULL  MAX
 CXX          500        N/A      6,000    218     3      3
 IXX  430     750        N/A      9,000  2,129    23     23
 ACH  430   3,000    150,024     18,000  5,371    29     29

The following CA Datacom report job can be used to determine the current number of mailbox and audit trail records. In the output report, locate "AUD" for audit trail records and "BOX" for mailbox records. "RECORDS IN TABLE" is the total record counts in the physical database.

 //REPORT   EXEC PGM=DBUTLTY,REGION=4M
 //STEPLIB  DD   DISP=SHR,DSN=YOUR.DATACOM.AD.CUSLIB
 //              DD   DISP=SHR,DSN=YOUR.DATACOM.AD.CAILIB
 //SYSPRINT DD   SYSOUT=*
 //CXX       DD   DISP=SHR,DSN=YOUR.DATACOM.AD.CXX
 //SYSIN    DD   *
 COMM OPTION=STATS,DBID=430
 REPORT AREA=CXX,DBID=430
 //

Sample report output:

 .......
 TABLE NAME - AUD                             AREA NAME  - ACH
 OCCURRENCE - CH430-CA-SCHEDULER-AUD P009                       
 TABLE ID   -     42                                         
 RECORD LENGTH    -    147 /    159                
 RECORDS IN TABLE -          69,962
 .......
 TABLE NAME - BOX                             AREA NAME  - ACH
 OCCURRENCE - CH430-CA-SCHEDULER-BOX P009                    
 TABLE ID   -     43                                         
 RECORD LENGTH    -    149 /    161                
 RECORDS IN TABLE -          12,655
 .......