Example 17: Using timestamp recovery

The inflight resolution technology of the Recovery Management for Db2 solution enables you to perform a consistent recovery to any timestamp or LRSN/RBA.

The ability to resolve inflight units of work at any point in time or to any log point completely eliminates the need to perform quiesces to establish consistent recovery points during application execution. The ability to avoid quiesces can dramatically improve the availability of your Db2 data.

The timestamp recovery feature of Recovery Management for Db2 solution uses inflight resolution technology to perform a consistent point-in-time recovery to any user-specified timestamp. The Recovery Management for Db2 solution translates the timestamp to an RBA or LRSN, recovers the objects, then resolves all inflight units of work for both data sharing and non-data-sharing systems. (The online interface of BMC AMI Recovery Manager for Db2 supports this feature on data sharing systems.)

For more information, see the  Recovery Management for Db2 documentation  and the  BMC AMI Recovery Manager for Db2 documentation .

The following figure is an example of BMC AMI Recover JCL that includes the options for a timestamp recovery.

JCL using RECOVERYPOINT for timestamp recovery

//AFREX18 JOB (PAFR),'EXAMPLE 17', 
//         CLASS=Q,NOTIFY=&SYSUID, 
//         MSGCLASS=X 
//* 
//RECOVER EXEC PGM=AFRMAIN,REGION=0M,                         
//             PARM='DGE,TSREC,NEW/RESTART,MSGLEVEL(2)'       
//STEPLIB  DD DISP=SHR,DSN=product.libraries
//          DD DISP=SHR,DSN=DB2.DSNEXIT
//          DD DISP=SHR,DSN=DB2.DSNLOAD
//SYSIN     DD *                                              
  OPTION BACKOUT YES RECOVERYPOINT TIMESTAMP 2013-01-28.12:25:18  
  RECOVER TABLESPACE WRPDB01.WRPTS01                          
  RECOVER INDEX(ALL) TABLESPACE WRPDB01.WRPTS01               
/* 
//