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 for full database restores, tablespace restores, and history files 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.
Parallelism
Use this space to specify the number of table spaces to be read in parallel for restore. If the number is not set, optimal value will be chosen automatically.
Select Backup Images
Specify backup images for restore.
-
Use latest backup image
The software uses the latest backup image when it performs the restore operation.
Note
Beginning in Service Pack 12, this option is the default option.
-
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)
Restore a full backup image. You can do this when 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.
-
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 or DB2 DPF Report File path per the preceding field.
Save As Script
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 by 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 you run the script, you can modify the value for any of these XML parameters.
For more information on backups performed from the command line, see Command Line Interface for DB2 Agent.