Managing Databases › Restore the TSF Database › Create the TSF Database Restore JCL

Create the TSF Database Restore JCL

As a CA Chorus administrator, you must create a JCL member to restore the TSF database. When doing so, we recommend that you consult with the storage administrator and scheduling administrator.

Follow these steps:

Create a JCL member for your restore and save it to a location that meets your site's requirements. The following example provides an outline of what to include in the TSF database restore JCL member:

1. Delete the existing data set for the TSF database directory file system:

   DELETE (dataset_backup_existing) PURGE
   

   dataset_backup_existing

   Data set name for the existing database file system. This name must match the name that you used in your backup job for (DATASET(INCLUDE in the SYSIN DD statement.

   Example: CHORUS.RUNTIME.CETJNTSF

2. Specify the backed-up data set for the TSF database directory file system:

   INPUT    DD DSN=tsf_backup_dataset,DISP=SHR
   

   tsf_backup_dataset

   Backed-up data set name for the TSF database directory file system. This name must match the name that you used in your backup job for the OUTPUT DD DSN.

   Example: CHORUS.RUNTIME.TSF.PACKAGE

3. (SMS Only) Specify the storage class that is used for the CA Chorus runtime data sets:

   STORCLAS(storage_class)
   

   storage_class

   Storage class name.

   Example: SCPERM

Example

In this example, the bold text indicates the instances where you specify your configuration values.

//DELETE   EXEC PGM=IDCAMS                               
//SYSPRINT DD   SYSOUT=*                                 
//SYSIN    DD   *                                        
  DELETE (CHORUS.RUNTIME.CETJNTSF)      PURGE             
  SET MAXCC=0                                            
/*                                                       
//DEPLOY EXEC PGM=ADRDSSU                                
//INPUT    DD DSN=CHORUS.RUNTIME.TSF.PACKAGE,DISP=SHR      
//SYSPRINT DD SYSOUT=*                                   
//SYSIN    DD *                                          
 RESTORE               -                                 
 INDDNAME(INPUT)       -                                 
 DATASET(INCLUDE(**))  -                                 
 REPLACEUNCONDITIONAL  -                                 
 WRITECHECK            -                                 
 STORCLAS(SCPERM)        /*For SMS only*/ -                            
 CANCELERROR           -                                 
 WAIT(2,2)                                               
/*                                                       
//                

You have created the TSF database restore JCL member.