Managing Databases › Back Up the TSF Database › Prepare for the TSF Database Backup

Prepare for the TSF Database Backup

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

Follow these steps:

1. Review and gather volume allocation information:
   1. Determine the amount of space that is allocated for the CETJNTSF data set.

      Note: The CETJNTSF 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 TSF database. For more information about multiple volumes, see the Installation Guide.

2. Create a JCL member for your TSF 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 TSF database backup JCL member:
   1. Delete the previous TSF database backup data set:

      DELETE (tsf_backup_dataset_old) PURGE
      

      tsf_backup_dataset_old

      Name of the previous TSF database backup data set.

      Example: CHORUS.RUNTIME.TSF.PACKAGE

   2. Specify the amount of space that is allocated to the TSF database backup:

      SPACE=(CYL,(primary_allocation,0),RLSE),
      

      primary_allocation

      Value of the primary space allocation in cylinders. This value is allocated when the backup data set is created. The administrator sets the value of the original TSF database that was created during CA Chorus configuration based on metrics requirements. However, the administrator may have increased the size of the file system to prevent metric purging. Therefore, we recommend that you use a primary allocation value that is equal to the current size of the CETJNTSF data set.

      Example: 1500

   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/ntsf) that you are backing up.

      Example: CHORUS.RUNTIME.CETJNTSF

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.TSF.PACKAGE) PURGE                           
  SET MAXCC=0                                                         
/*                                                                    
//*                                                                   
//PACKAGE EXEC PGM=ADRDSSU                                            
//OUTPUT   DD DSN=CHORUS.RUNTIME.TSF.PACKAGE,                          
//            DISP=(NEW,CATLG,DELETE),                                
//            SPACE=(CYL,(1500,0),RLSE),                           
//            STORCLAS=SCWORK,                                        
//            UNIT=(SYSALLDA,6)                                      
//SYSPRINT DD SYSOUT=*                                                
//SYSIN    DD *                                                       
 DUMP -                                                               
      OUTDDNAME(OUTPUT) -                                             
      DATASET(INCLUDE(CHORUS.RUNTIME.CETJNTSF)) -                       
      ALLEXCP                                                         
/*                                                                    
//         

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