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.)
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 and the .
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 /* //