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.
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.
[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
Quiesce the database:
[db2inst1@nodedb21 pos]$ db2 "QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS" DB20000I The QUIESCE DATABASE command completed successfully.
Restore the database:
When you are restoring to an existing database, DB2's restore will issue a warning to indicate that you are overwriting...