Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see Recovery Management for Db2 13.1.

Example 6: Using standard image copies and Instant Snapshots


This example illustrates how to use both Instant Snapshot copies and standard image copies based on the size of the data.

Output data sets are defined for each type of copy. To do so, the example uses the following commands and options:

  • OUTPUT commands that define output data sets for each type of copy—Instant Snapshots and standard image copies
  • OUTSIZE option on the OPTIONS command to define the threshold at which Instant Snapshots will be made
  • BIGDDN option on the COPY command to identify the output file names for the consistent copies

The following figure shows an example of the JCL necessary to perform this task. For more information, see Standard-image-copies.

 //NSCCOPY  EXEC PGM=ACPMAIN,                            
//          PARM='&SSID,SZC233,MSGLEVEL(1)',REGION=0M   
//      INCLUDE MEMBER=NSCSTEP                          
//      INCLUDE MEMBER=DB2LIBS                          
//STEPLIB   DD DISP=SHR,DSN=PRODUCT.LOAD.LIBS
//          DD DISP=SHR,DSN=DSNEXIT
//          DD DISP=SHR,DSN=DSNLOAD  
//SYSPRINT  DD DSN=RMD.NSC.&SSID..&CASE..SYSPRINT,      
//            DISP=(NEW,CATLG),UNIT=SYSALLDA,           
//            SPACE=(CYL,(1,1)),                        
//            DCB=(RECFM=FB,LRECL=133,BLKSIZE=13300)    
//SYSOUT   DD SYSOUT=*                                  
//ALPPRINT DD SYSOUT=*                                  
//AFRSTMT  DD SYSOUT=*                               
//AFRPRINT DD SYSOUT=*                               
//AFRSUMRY DD SYSOUT=*                               
//AFROSUM  DD SYSOUT=*                               
//*  SMALL DATASETS WILL USE STANDARD IMAGE COPIES            
//*  LARGE DATASETS WILL USE INSTANT SNAPSHOT COPIES            
//SYSIN DD *                                         
 OPTIONS IXDSNUM DATASET                             
     XBMID XBMDB2                                    

 OUTSIZE 250K     


OUTPUT COPY0001     
    CATLG YES                                        
    DSSNAP NO                                        
    SPACE CYL                                        


OUTPUT COPY0002  
    CATLG YES                                              
    DSSNAP YES                                             
    SPACE CYL                                              

 COPY TABLESPACE NSCDB52.*                                 
         DSNUM DATASET                                     
         INDEXES YES                                       
         COPYDDN(COPY0001)                                 
         COPYDSN(DEC2CAT.&DB.&TS.&TYPE&PART.T&TIME)        

         BIGDDN(COPY0002)                                  
         BIGDSN(DEC2CAT.&DB.&TS.B&TYPE&PART.T&TIME)        
    RESETMOD NO                                            
    SHRLEVEL CHANGE CONSISTENT YES                                        
/*




 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*