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.

Related topic

Examples-of-BMC-AMI-Recover-jobs

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.)

Important

Timestamp recovery and inflight resolution technology use features from the BMC AMI Recovery Manager for Db2, BMC AMI Recover for Db2, and BMC AMI Log Master for Db2 components of the Recovery Management for Db2 solution. The Recovery Management for Db2 solution password is required to use the feature.

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

//AFREX17 JOB (PAFR),'EXAMPLE 17',
//         CLASS=Q,NOTIFY=&SYSUID,
//         MSGCLASS=X
//*
//RECOVER EXEC PGM=AFRMAIN,REGION=0M,                         
//             PARM='DEJM,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 2022-03-28.12:25:18  
  RECOVER TABLESPACE WRPDB01.WRPTS01                          
  RECOVER INDEX(ALL) TABLESPACE WRPDB01.WRPTS01               
/*
//

 

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