DB2 Version 9.7 for Linux, UNIX, and Windows

Recover overview

The recover utility performs the necessary restore and roll-forward operations to recover a database to a specified time, based on information found in the recovery history file. When you use this utility, you specify that the database be recovered to a point-in-time or to the end of the log files. The utility will then select the best suitable backup image and perform the recovery operations.

For recovering databases, you can use the task assistant available in IBM® Data Studio Version 3.1 or later. Task assistants can guide you through the process of setting options, reviewing the automatically generated commands to perform the task, and running these commands. For more details, see Administering databases with task assistants.

The recover utility does not support the following RESTORE DATABASE command options:

TABLESPACE tablespace-name. Table space restore operations are not supported.
INCREMENTAL. Incremental restore operations are not supported.
OPEN num-sessions SESSIONS. You cannot indicate the number of I/O sessions that are to be used with TSM or another vendor product.
BUFFER buffer-size. You cannot set the size of the buffer used for the restore operation.
DLREPORT file name. You cannot specify a file name for reporting files that become unlinked.
WITHOUT ROLLING FORWARD. You cannot specify that the database is not to be placed in roll-forward pending state after a successful restore operation.
PARALLELISM n. You cannot indicate the degree of parallelism for the restore operation.
WITHOUT PROMPTING. You cannot specify that a restore operation is to run unattended

In addition, the recover utility does not allow you to specify any of the REBUILD options. However, the recovery utility will automatically use the appropriate REBUILD option if it cannot locate any database backup images based on the information in the recovery history file.

For the RECOVER DATABASE command, you cannot use the TABLESPACE option or the INCREMENTAL option from the RESTORE DATABASE command.

For the RECOVER DATABASE command, restore option is automated. Same applies for the REBUILD option in the RESTORE command.