Use this tab to administer the type of restore, the backup images available for restore, and the report file. Note that all the options described in this help may not be available and only the options displayed in the dialog box are applicable to the agent or enabler for which the information is being displayed.
Online Restore
Specifies whether to run a restore with the database online. If a restore is run with the database online, other applications can access the database or database partitions while the restore is in progress. Online restores are available only for partial database restores (and not for full database restores).
Offline Restore
Specifies whether to run a restore with the database offline. If a restore is run with the database offline, this job has an exclusive connection to the database; therefore, any other access to the database is not allowed while the restore is in progress. On the other hand, an offline restore cannot run if any other applications are already running on the database. Offline restores are available only for full database restores.
Number of Buffers
Use this space to specify the number of buffers for the restore. Default is 2. However, if you are restoring to multiple locations, you should use a sufficient number of buffers to improve performance. If you do not specify a sufficient number of buffers, the restore might fail.
Buffer Size
Use this space to specify the size (in 4 KB pages) of each buffer to be used for building the backup image. The minimum value is 8, and the default value is 1024. If you select value 0, the value of the backbufz database manager configuration parameter will be used as the buffer allocation size.
Select Backup Images
Specify backup images for restore.
Lists the available images for restore. Click the appropriate full backup image and (if present) any associated incremental and delta incremental backup images and then click > to move these images to the Selection list (and thereby select the images for restore).
Lists the appropriate images for restore according to the explanation provided for the Available Images list. To move any images in this list back to the Available Images list, click the appropriate image(s) and click <.
Specifies whether to restore only a full backup image. This should be done only whenever both of the following statements are true:
Report File
(Optional field) Displays the name of the file containing the names of the files that have become unlinked during a restore operation as a result of a fast reconcile. File names, if specified, must be fully qualified. This option is used only if the table being restored has a DATALINK column type and linked files. To generate this file, you must either enter or browse for and then select the appropriate DB2/DB2 DPF Report File path. You can use this space to change the name of the report file.
Browse
Click to browse for and select the DB2/DB2 DPF Report File path per the preceding field.
Advanced
Click to select additional restore options.