Prepare the H2 Database Backup

Managing Databases › Back Up the H2 Database › Prepare the H2 Database Backup

Prepare the H2 Database Backup

As a CA Chorus administrator, you must perform a one-time setup to prepare for the H2 database backup. This setup includes determining the volume allocation for the H2 database and creating an H2 database backup JCL member. When you are performing this setup, we recommend that you consult with the storage administrator and scheduling administrator.

Follow these steps:

Review and gather volume allocation information:
1. Determine the amount of space that is allocated for the CETJB data set.
  Note: The CETJDB allocation is given in tracks.
2. Determine where the backup data set will be located.
3. Verify that the selected location has enough space available for the backup data set, on a single volume or multiple volumes.
  Note: Multiple volume allocations are required when a data set allocation is expected to consume more space than what is available on a single volume. We recommend that you use multiple volumes. Doing so makes it easier to secure the necessary allocation for the H2 database. For more information about multiple volumes, see the Installation Guide.
Create a JCL member for your H2 database backup and save it to a location that meets your site requirements. The following example provides an outline of what to include in the H2 database backup JCL member:
1. Delete the previous H2 database backup data set:
```
DELETE (h2_backup_dataset_old) PURGE
```
  h2_backup_dataset_old
  
  Name of the previous H2 database backup data set.
  
  Example: CHORUS.RUNTIME.H2.PACKAGE
2. Specify the amount of space that is allocated to the H2 database backup:
```
SPACE=(CYL,(primary_allocation,secondary_allocation),RLSE),
```
  primary_allocation
  
  Value of the primary space allocation in cylinders. This value is allocated when the backup data set is created. This file system can grow to be much larger than the original allocation. Therefore, we recommend that you use a primary allocation value that is equal to the current size of the CETJDB data set.
  
  Example: 1500
  
  secondary_allocation
  
  Value of the secondary space allocation in cylinders. Use this value if your H2 database backup data set requires more space than what is specified in the primary allocation. This value can be used up to 15 times.
  
  Example: 100
3. Specify your site-specific storage class:
```
STORCLAS=storage_class, 
```
  storage_class
  
  Name of your storage class. Typically, this name is the storage class that is used for application backup data sets.
  
  Example: SCWORK
4. Specify the volume allocations that you determined in step 1.
  Note: For non-SMS allocations, list the individual volumes in the VOLUME subparameter.
```
UNIT=(volume1, volume2) 
```
  volume1
  
  Value for the first volume allocation.
  
  Example: SYSALLDA
  
  volume2
  
  Number of extra units of space for the volume allocation.
  
  Example: 6
5. Specify the data set name for the database file system that you are backing up:
```
DATASET(INCLUDE(dataset_for_backup))
```
  dataset_for_backup
  
  Data set name for the database file system (INSTALL_HOME/database) that you are backing up.
  
  Example: CHORUS.RUNTIME.CETJDB

Example

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

//* Remove the previous backup 
//*                                                                   
//DELPKG  EXEC PGM=IDCAMS                                             
//SYSPRINT DD SYSOUT=*                                                
//SYSIN    DD *                                                       
  DELETE (CHORUS.RUNTIME.H2.PACKAGE) PURGE                           
  SET MAXCC=0                                                         
/*                                                                    
//*                                                                   
//PACKAGE EXEC PGM=ADRDSSU                                            
//OUTPUT   DD DSN=CHORUS.RUNTIME.H2.PACKAGE,                          
//            DISP=(NEW,CATLG,DELETE),                                
//            SPACE=(CYL,(1500,100),RLSE),                           
//            STORCLAS=SCWORK,                                        
//            UNIT=(SYSALLDA,6)                                      
//SYSPRINT DD SYSOUT=*                                                
//SYSIN    DD *                                                       
 DUMP -                                                               
      OUTDDNAME(OUTPUT) -                                             
      DATASET(INCLUDE(CHORUS.RUNTIME.CETJDB)) -                       
      ALLEXCP                                                         
/*                                                                    
//

You have determined the volume allocations for the H2 database backup and have created the H2 database backup JCL member.