Restore Options (Restore Arguments)

Use this tab to administer the type of restore, the backup images available for restore, and the report file.

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.

  • Available Images

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

  • Selection

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

  • Incremental Restore (from one Full backup image)

    Specifies whether to restore only a full backup image. This should be done only whenever both of the following statements are true:

    • You tried to restore a full backup image along with one or more associated delta backup images and/or one or more associated incremental backup images.
    • The full backup image restore failed (thereby causing the restore in general to fail).

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.


Click to browse for and select the DB2/DB2 DPF Report File path per the preceding field.


Click to select additional restore options.

Save As Script

Click to open the Save As Script dialog, which allows you to save this operation and the selected options as a script file (in XML format). The script can later be executed from the Command Line Interface using qoperation execute command.

When you save an operation as a script, each option in the dialog will have a corresponding XML parameter in the script file. When executing the script, you can modify the value for any of these XML parameters as per need.