Space announcement

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Example 17: Using timestamp recovery

The inflight resolution technology of the BMC 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 BMC 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.)

Note

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

//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               
/* 
//
Was this page helpful? Yes No Submitting... Thank you

Comments