Performing a DB2 Application-Free Restore

You can restore the backup images of data and logs or multiple backup jobs at the same time directly to a location on a disk without the intervention of the DB2 application. This is useful for restoring multiplexed data on the same media. The data from different backup jobs are passed back to the client so that all of the interleaved backup jobs can be restored in parallel. You can restore the data associated with a specific backup job, such as a full job, in parallel streams. You can also submit multiple restore jobs from full and incremental backups. Later, you can restore the DB2 database from the DB2 command line using the backup image on disk without using the load Commvault library.

Procedure

From the CommCell Browser, expand Client Computers > client > DB2 > instance.
Right-click the backup_set, point to All Tasks, and then click Restore to Disk.

The Restore to Disk filter dialog box appears.
Specify the criteria for the backup jobs to search for, then click OK.

A list of backup jobs appears in the content window.
Right-click the backup job to restore to a disk and select Restore to Disk. You can select multiple backup jobs at the same time and restore them to disk.

The Restore Options for All Selected Items dialog box appears.
On the General tab, specify the restore options:
1. Select the Destination client from the drop down list.
2. Type the path or click Browse to specify the location on the disk to restore the application data.
3. Select Impersonate User if you want to use a different account with the required privileges. In the User Name box, type the user name. The user should have the necessary privileges to restore the application data.
  
  Type the password for the user account and confirm it.
Click OK.

The backup images will be restored to the disk location specified in the Restore Options for All Selected Items dialog box.

The DB2 agent will create a new folder with the current restore job ID on the destination directory which has been specified during the restore operation. This folder contains the backup images and DB2 archive logs.

Log Files
```
<restore_destination_path>/<restore_job_id>/LOGS/DB2/<Node Number>/<Chain number>/Log_files
```
Data
```
<restore_destination_path>/<restore_job_id>/<Backup_images>
```
You can run a disk restore using the backup image at the following location:
```
db2 restore database <db_name> taken at <backup_image_timestamp>
```
You can also use the following command to restore the backup image.
```
db2 restore database <db_name> from <restore_destination_path>/<restore_job_id> taken at <backup_image_timestamp>
```
You can recover the database by reapplying the log files (roll forward). Make sure that the Commvault services are running on this client.
```
db2 rollforward database <db_name> to end of logs and stop overflow log path "(<Restore_Destination_path>/<Restore_Jobid>)"
```

If you are trying to restore one cycle of backup images which includes full, incremental, and deltas, you should use the last backup image timestamp (incremental or delta) with the incremental automatic key word to restore the database:

db2 restore database <db_name> incremental automatic from <restore_destination_path>/<restore_job_id> taken at <late_incremental or delta_backup_image_timestamp>

The multi-streams backup job will have multiple backup images as a number of streams after restoring to disk.