Reduce space usage CA Scheduler IXX and Data (ACH) areas by removing obsolete MAIL box and AUDIT trail records.
Article ID: 27078
Updated On:
Products
Issue/Introduction
To reduce the percent full of the Index and Data areas for your CA Scheduler Datacom data base, the IXX, ACH and HST data sets should be expanded. But first, you should try deleting old MAIL box, AUDIT trail and HISTORY records. This technical document addresses the cleanup of the mailbox, audit trail and history records. This procedure can be executed with both CA Scheduler and CA Datacom remaining active.
When CA Scheduler starts and after autoscan occurs, the following message displays on how full the IXX, ACH and HST data area.
CACM335I SCD1 CA-DATACOM AREA ACH IS 75% FULL
CACM335I SCD1 CA-DATACOM AREA HST IS 55% FULL
CACM335I SCD1 CA-DATACOM AREA IXX IS 80% FULL
Use the instructions below to reduce the space % FULL.
Environment
Component:
Resolution
Run the following job to clean up the obsolete audit trail, mailbox and history records. This sample job is also located in the CA Scheduler CAIJCL data set, member name CHCLEAN.
//* SAMPLE JCL TO DELETE EXPIRED AUDIT AND MAILBOX ENTRIES //* //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 DELETE HISTORY LIST=YES DELETE HISTORY PER HISTRET/HISTNUM OPTIONS // * ADD THIS STEP TO DO THE DEFRAG FOR THE IXX //REPORT EXEC PGM=DBUTLTY,REGION=4M //STEPLIB DD DISP=SHR,DSN=YOUR.DATACOM.AD.CUSLIB // DD DISP=SHR,DSN=YOUR.DATACOM.AD.CAAXLOAD //SYSPRINT DD SYSOUT=* //SYSIN DD * COMM OPTION=STATS,DBID=430 DEFRAG DBID=430
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.
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.CAAXLOAD
//SYSPRINT DD SYSOUT=*
//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 250 N/A 3,000 307 10 10
IXX 430 3,600 N/A 43,200 2,818 26 80
ACH 430 11,250 155,701 67,500 3,923 55 75
HST 430 3,000 88,847 18,000 1,107 46 55
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.CAAXLOAD
//SYSPRINT DD SYSOUT=*
//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
.......
Feedback
