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

Create the H2 Database Restore JCL

As a CA Chorus administrator, you must create a JCL member to restore the H2 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 H2 database restore JCL member:

1. Delete the existing data set for the H2 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.CETJDB

2. Specify the data set for the H2 database directory file system:

   INPUT    DD DSN=h2_backup_dataset,DISP=SHR
   

   h2_backup_dataset

   Data set name for the H2 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.H2.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.CETJDB)      PURGE             
  SET MAXCC=0                                            
/*                                                       
//DEPLOY EXEC PGM=ADRDSSU                                
//INPUT    DD DSN=CHORUS.RUNTIME.H2.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 H2 database restore JCL member.