For information on the table restore parameters, see Table.
General
Use this tab to select the data to restore and the destination for the restore.
Restore Data
Specifies that you can activate the appropriate restore models from the following:
-
Entire Database
Specifies whether to restore all of the data in the backup set. An entire DB2 or DB2 DPF database can be restored only if the affected database is offline.
-
Database Subset
Specifies whether to activate the backup set and its contents and to establish the restore of a subset of database objects. This restore mode can be implemented with the database either online or offline.
-
History Files
Specifies whether to restore the DB2 or DB2 DPF history files. These files contain database records regarding recovery and administration events.
The Latest Database View
By default, displays the database tree as it existed in the latest backup. Use the tree structure to establish either an entire or partial database restore by selecting the appropriate entity.
For Oracle and Informix, if you specify a point-in-time by clicking the New Browse button, the database tree as existing in the specified point-in-time is displayed.
Refresh
Click to display the most current status of the database.
Destination Client/Computer/Server
Displays the name of the client computer to which the selected data will be restored. To change the destination computer, select one from the list. The list includes the following clients:
-
Clients which are established as clients within the CommCell.
-
Clients with operating systems that support the cross-platform restore operation from this client. (Refer to the topic titled Cross Platform Restore Operations in Books Online for additional information.)
By default, data is restored to the same computer from which it was backed up.
Destination Instance
Lists the names of the instances to which you can restore the data. To change a destination instance, click one in the list.
Target Database Name
Displays the name of the backup set that contains the data to be restored. You can use this space to change this name as long as the corresponding backup set has been created.
Note
This option will be disabled if the Recover Database option is enabled.
Target Database Path
Displays the location of the target database. You can use this space to change this location.
For DB2 or DB2 DPF on Windows only, be sure to include in this field just the letter of the appropriate drive followed by a colon (e.g., L:). Otherwise, the target database will not be accessed.
Browse
Click to browse for the location of the target database.
Advanced
Click to select additional restore options.
Save As Script
Click to open the Save As Script dialog box, which allows you to save this operation and the selected options as a script file (in XML format). The script can later be run from the Command Line Interface using qoperation execute command.
When you save an operation as a script, each option in the dialog box has a corresponding XML element in the script file. When you run the script, you can modify the value in any of these XML elements.
For more information on backups performed from the command line, see Command Line Interface for the DB2 Agent.
Table
Users/Tables selected for restore
This box contains the selected tables that will be restored. There is no selection required for this field.
Auxiliary Database
Use a temporary database to duplicate the source database with the required tablespaces to export the tables. If you do not select this option, the Commvault software uses the Target Database Path to stage the restore.
Auxiliary Database
Use a temporary database to duplicate the source database with the required tablespaces to export the tables.
Destination Computer
The host that the tables are restored to.
Destination Instance
The DB2 auxiliary instance that the tables are restored to.
Target Database Name
The DB2 auxiliary database name.
Target Database Path
The path used as the staging area to store datafiles for the auxiliary database and the complete export tables before importing.
Browse
Click to browse and select a staging path.
Export destination for Table dump files
The path where the restored tables dump files are stored.
Browse
Click to browse and select a path.
Cleanup Auxiliary Database after Export
The auxiliary database is deleted once the restore operation completes. This is the default option.
Save As Script
Click to open the Save As Script dialog box, which allows you to save this operation and the selected options as a script file (in XML format). The script can later be run from the Command Line Interface using qoperation execute command.
When you save an operation as a script, each option in the dialog box has a corresponding XML element in the script file. When you run the script, you can modify the value in any of these XML elements.
For more information on backups performed from the command line, see Command Line Interface for DB2 Agent.