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

Products

• Datacom
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
• Scheduler Job Management

Issue/Introduction

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.

Environment

Release:
Component: CA Scheduler 

Resolution

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.CAAXLOAD
//SYSPRINT DD SYSOUT=*
//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