Restoring from an incremental backup

You can specify that you want to perform an incremental restore as opposed to a full backup.

About this task

The following steps allow you to restore your database from an incremental backup.

Supplying the automatic option will result in performing a cumulative restore operation so that only one timestamp needs to be specified:

db2_all "<<+0<db2 RESTORE DATABASE ${DBNAME} INCREMENTAL AUTOMATIC FROM backup_dir TAKEN AT backup_image_timestamp INTO ${DBNAME} REPLACE EXISTING WITHOUT PROMPTING"

For multinode configurations, run the following command on each of the other data nodes:

db2_all "<<-0<db2 RESTORE DATABASE ${DBNAME} INCREMENTAL AUTOMATIC FROM backup_dir TAKEN AT backup_image_timestamp INTO ${DBNAME} REPLACE EXISTING WITHOUT PROMPTING"