Setting the DB2 Buffers for Restore

You can improve the performance of restore operations of backup images by increasing the number of buffers.

Procedure

1. From the CommCell Browser, expand Client Computers > client > DB2 > instance.

2. Right-click the backup_set, point to All Tasks, and then click Browse and Restore.

3. On the Browse and Restore dialog box, select Latest Backup and click View Content.

4. Select the database and click Recover All Selected.

   The Restore Options dialog box is displayed.

5. On the Recover Database tab, clear the Recover DB check box.

6. On the Restore Arguments tab, select Offline Restore.

7. Type the Number of Buffers that are a sufficient number to improve performance.

8. Type the Buffer Size.

9. 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.

10. Click OK.