Database rollforward recovery

This type of recovery allows for a restore of the database, as well as all transactions recorded in the logs since the backup. All transactions, from backup to the point of failure, can be recovered by this process.

Getting ready

We will have to quiesce the database and perform a database restore first. Make sure all necessary archived logs are available for recovery. When that is done, we'll be ready to roll forward the archived logs.

How to do it...

1. Connect to the database:

   [db2inst1@nodedb21 pos]$ db2 CONNECT TO POS
   
      Database Connection Information
   
    Database server        = DB2/LINUXX8664 9.7.4
    SQL authorization ID   = DB2INST1
    Local database alias   = POS
   

2. Quiesce the database:

   [db2inst1@nodedb21 pos]$ db2 "QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS"
   DB20000I  The QUIESCE DATABASE command completed successfully.
   

3. Restore the database:

   When you are restoring to an existing database, DB2's restore will issue a warning to indicate that you are overwriting...