NetMaster Database Administration › How to Implement NDB Journaling › Add the Duplicates to the Batch Forward Recovery JCL

Add the Duplicates to the Batch Forward Recovery JCL

The batch forward recovery utility (UTIL0010) applies the NDB journal to a duplicate copy of the NDBs.

Add the data set name of the NDB duplicate to your batch forward recovery JCL (use sample $NDUT010).

Make sure you have updated the JOURNL1 and JOURNL2 DD statements in the sample with the two journal data set names you defined in Task 1.

Include in the utility JCL all NDBs which require forward recovery. By default, the utility attempts to forward recover all NDBs which have journal records present in the journal data set. The DD name for the NDB should be the same as the NDB name used to identify it to the product region.

Use the control cards on the U10IN data set to specify a subset of NDBs.

The format of a U10IN control card is:

RECOVER NDB=ndbid [,DD=name]

where the DD operand can be used to specify an override DD name for the NDB.

RECOVER ALL is used to indicate that all NDBs are to be forward recovered. This is the default.

The following is a sample JCL specification for the forward recovery utility:

//FWDRECVR EXEC PGM=UTIL0010,PARM='JOURNAL=JOURNL1'
//STEPLIB DD DSN=steplib,DISP=SHR
//U10PRINT DD SYSOUT=*
//U10IN DD*
  RECOVER ALL
//JOURNL1 DD DSN=USER.NDB.JOURNAL1,DISP=SHR
//JOURNL2 DD DSN=USER.NDB.JOURNAL2,DISP=SHR
//*
//NDB1 DD DSN=USER.NDB.BACKUP.NDB1,DISP=SHR
//NDB2 DD DSN=USER.NDB.BACKUP.NDB2,DISP=SHR
//NDB3 DD DSN=USER.NDB.BACKUP.NDB3,DISP=SHR
//*

Note: The JOURNAL=JOURNL1 parameter specified on the EXEC UTIL0010 statement is used to override the journal DD name. If this parameter is not specified, then the DD name used is JOURNAL.