You can improve restore operation performance by using parallelism.
If the database contains a large number of table spaces and indexes, you can perform a restore operation more quickly when you set a maximum number of concurrent parallelism queries. This takes advantage of the available input/output bandwidth and processor power of the DB2 server.
Procedure
-
From the CommCell Browser, expand Client Computers> client> DB2 > instance.
-
Right-click the backup_set, point to All Tasks, and then click Browse and Restore.
-
On the Browse and Restore dialog box, select Latest Backup and click View Content.
-
Select the database and click Recover All Selected.
The Restore Options dialog box is displayed.
-
On the Recover Database tab, clear the Recover DB check box.
-
On the Restore Arguments tab, select Offline Restore.
-
In the Parallelism box, type the maximum number of parallelism queries to enhance your restore operation.
-
On the Restore Arguments tab, in the Backup Images area, choose an option for selecting backup images:
-
To let the Commvault software select the latest backup images or the latest point-in-time backup images, based on the choice you made on the Time Range tab on the Browse and Restore dialog box, choose Auto Pick Backup Images.
-
To manually select a cycle of backup images, choose Select Backup Images. Select the images from the Available Images box, and then click > to move the selected images to the Selection box.
-
-
Click OK.