DEFRAG the CA Scheduler Job Management Index (IXX) data set after DELETE HISTORY/AUDIT/MAILBOX.

Products

• Datacom
• Datacom/AD
• Scheduler Job Management

Issue/Introduction

To reduce the CA Scheduler data base space utilization, a frequent cleanup job is recommended. There are three types of records that can be deleted from the Scheduler database: AUDIT, MAILBOX, 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.

 

Environment

Release: SCHED.00200-11-Scheduler-Job Management
Component:  SCHDMS

Resolution

CA Scheduler JM CAIJCL(CHCLEAN) member contains a sample job to DELETE expired AUDIT, MAILBOX and HISTORY records from the CA Scheduler database. After these records are deleted, run the following CA Datacom job to DEFRAG the CA Scheduler 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=430
 COMM OPTION=STATS,DBID=430             
/*

The CHCLEAN and DEFRAG job should be defined to CA Scheduler and should run daily after AUTOSCAN. See CA Scheduler SAMPJCL(ISTEP34) member for an example on how to define the CHCLEAN job to CA Scheduler. The CHCLEAN and DEFRAG job can run while CA Scheduler is active.

To determine the current data space utilization, run the following CA Scheduler job:

//REPORT EXEC CAJUTIL0
//SYSPRINT DD SYSOUT=*
//SYSIN DD * 
REPORT DATACOM
/*

Sample job output:

REPORT DATACOM
 
CA-DATACOM RELEASE  : 15.0   
CA-DATACOM TASK NAME: DB11MUFS
CA-DATACOM CXX NAME : PRODCXX

The following CA Datacom statistics reflect the entire CA Datacom address space. If you have more than one copy of CA Scheduler sharing the CA-Datacom database, then the statistics below are for all copies of CA Scheduler using this CA Datacom database, not just this copy.

DBID  430  AREA ACH DATASET CAI.DB11.SCHDB0.DATA
INUSE/MAX USED %:  04/ 04  INUSE/PARTIAL BLOCKS: 000771/000117
 
DBID  430  AREA HST DATASET CAI.DB11.SCHDB0.HIST
INUSE/MAX USED %:  00/ 00  INUSE/PARTIAL BLOCKS: 000014/000001
 
DBID  430  AREA IXX DATASET CAI.D11.SCHDB0.INDEX
INUSE/MAX USED %:  06/ 06  INUSE/PARTIAL BLOCKS: 000650/ *N/A*
..........

CA Scheduler data space usage is also displayed when CA Scheduler is started. Here's a sample display from the CA Scheduler STC job log:

CACM335I SCHD CA-DATACOM AREA ACH IS  04% FULL
CACM335I SCHD CA-DATACOM AREA HST IS  00% FULL
CACM335I SCHD CA-DATACOM AREA IXX IS  05% FULL