CA Datacom DBUTLTY RETIX command for CA Scheduler Job Management Database.

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

Description:

When using the CA Datacom RETIX command to rebuild the Index data set for the CA Scheduler JM DBID 430, both the CA Scheduler JM Data area (ACH) and History area (HST) must be included. Failure to include these areas will result in CA Datacom OPEN ERROR Return code 69(071) when bringing up the CA Scheduler JM started task.

Solution:

Before running the CA Datacom RETIX command, the following must be done:

  • All users must log off from CA Scheduler JM ISPF

  • The CA Scheduler JM started task must be shutdown

  • The CA Scheduler JM DBID 430 must be closed using the CA Datacom "COMM OPTION=CLOSE,DBID=430" command.

Sample RETIX JCL:

//RETIX EXEC PGM=DBUTLTY,REGION=4M
//STEPLIB DD DISP=SHR,DSN=your.cai.datacom.CUSLIB
// DD DISP=SHR,DSN=your.cai.datacom.CAILIB
//SYSPRINT DD SYSOUT=*
//CXX DD DISP=SHR,DSN=your.cai.datacom.cxx
//IXX430 DD DISP=SHR,DSN=your.cai.scheduler.ixx
//SORTWK01 DD UNIT=SYSDA,SPACE=(CYL,(x,y))
//SORTWK02 DD UNIT=SYSDA,SPACE=(CYL,(x,y))
//SORTWK03 DD UNIT=SYSDA,SPACE=(CYL,(x,y))
//SYSIN DD *
ACCESS STATUS=OFF,DBID=430,USERS=WAIT
INIT AREA=IXX,DBID=430
RETIX DBID=430,OPTIMIZE=YES,SORT=99000000
ACCESS STATUS=WRITE,DBID=430
/*

The RETIX DBID=430 command is equivalent to coding the following two commands:

RETIX AREA=ACH,DBID=430
RETIX AREA=HST,DBID=430