Restore Options (Recover Database)

Use this tab to recover a DB2 database without selecting backup images.

Recover DB

Specifies that you can recover a DB2 database without selecting backup images from the CommCell Console. This option is selected by default whenever you set up a DB2 iDataAgent restore. Whenever this option is selected, the Restore Arguments and Advanced tabs are disabled. This option is disabled whenever the options for a partial database restore and/or and out-of-place restore are selected.

  • To the End of the Logs

    Specifies whether to restore the DB2 database per all the logs associated with the database. This option is selected by default whenever you choose to recover a DB2 database.

  • To a  Point in Time

    Specifies whether to recover the DB2 database based on the state and contents of the database to a specific point in time.  To change this time, click in the list as appropriate.

  • Overflow Directory

    Displays the alternate log path to be searched for all of the archived logs during the database recovery if the system does not find all of the information that it needs in the history file path (discussed next). Use this option if log files were moved to a location other than that specified by the logpath database configuration parameter.

    The OVERFLOW LOG PATH command parameter overwrites any value of the DB2 logpath database configuration parameter.

  • History File Path

    Click this option and use Browse to select the history file that the system will check in order to select the backup image to restore. If the history file is not available, be sure to restore this file first before you recover the database. If the system does not find all the information in the history file that it needs to recover the database, the Overflow Directory (discussed above) is searched.

Advanced

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.