Incremental restore

Used particularly in warehouse databases in conjunction with an incremental restore, this type of recovery allows for faster recovery time, instead of full database and table space backups. You can use it on complex migrations to ensure rollback points.

An incremental restore can be run in automatic mode.

Getting ready

The database has to be in archive logging mode, and tracking database changes has to be enabled, as explained in the Performing an incremental delta database backup recipe in this chapter.

How to do it...

1. Quiesce database:

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

2. Check restore:

   This command will generate a list of timestamps required for the incremental restore till the timestamp you provide; the commands to use (with a simplified syntax) are also generated:

   [db2inst1@nodedb21...