Online Documentation for SQL Manager for DB2

Setting target database options


This step of the wizard appears only if the RadioButton Restore to a new database option was selected on the first step. It allows you to define parameters for a newly created database.

 

Restore Database - Setting target database options

 

 

New database alias

Enter any database alias that is convenient for you. This alias will be displayed in the DB Explorer window.

 

Path/Drive

Use the ellipsis EllipsisButton button to specify the location where the new database will reside. If a path is not specified, the database will be created on the default database path specified in the database manager configuration file (dftdbpath parameter).

 

New log path

This parameter allows you to specify a string of up to 242 bytes to change the location where the log files are stored.

 

CheckBox Replace existing database

If a database with the same alias as the target database alias already exists, this parameter specifies that the restore utility is to replace the existing database with the restored database.

 

Click the Next button to proceed to the Selecting backup image step of the wizard.