Select an entry from the list
Change the media information if necessary
Manually enter the backup information
OK
Cancel
Backup image page
Use the Backup Image page of the Restore Database to New notebook to specify the backup image that you want to use to create the database.
Select an entry from the list
Change the media information if necessary
Manually enter the backup information
OK
Cancel
Select an entry from the list
Click on this radio button to use one of the listed backup images to restore the database.
Change the media information if necessary
This control, and its associated fields, is only displayed if you select a backup image from the list of available images from the list box above it (that is, Select an entry from the list is selected). If you know that the information displayed in the Media Type column for that backup image is not correct, you can change this information by specifying the correct media of the backup image in the Media Type box. The choices are as follows:
You can specify more than one path to the backup image if the database was backed up to more than one location. In this situation, the backup image will be listed in multiple locations, and all the images will have the same time stamp. All portions of the backup image must be concurrently available for the restore database operation to complete.
Manually enter the backup information
This control, and its associated fields, is only displayed if you do not select a backup image from the list of available images from the list box above it (that is, Select an entry from the list is not selected). Specify the media of the backup image in the Media Type box. The choices are as follows:
You can specify more than one path to the backup image if the database was backed up to more than one location. In this situation, the backup image will be listed in multiple locations, and all the images will have the same time stamp. All portions of the backup image must be concurrently available for the restore database operation to complete.
The remaining fields for this group of controls are as follows:
You can either type the date, or you can click on the arrow to open a calendar on which you select the date. Click on the arrows at the top of the calendar to display the month that you want, then on a date to select it. The calendar closes, and the date you selected will be displayed in the field.
| Note: | You do not have to specify the date and time if only one backup image exists at the location specified for the backup image. |
Description page
New database name
Default drive
Alias
Comment
OK
Cancel
New database name
Type the name of the new database in this field. The name can be from one to eight characters, and can contain any of the following: a-z, A-Z, 0-9, @, #, and $. The first character in the string must be an alphabetic character, @, #, or $. It cannot be a number or the letter sequences SYS, DBM, or IBM.
| Note: | The name that you specify for the new database must be unique for the instance. |
Default drive
Use the Default drive field to display all available drives on which you can create the database from the backup image. (For UNIX-based systems, this field is called Default directory.) To display the list of available drives, click on the arrow. When you see the drive that you want, click on it.
| Note: | You must ensure that the drive contains enough unused space to hold the new database. |
Alias
Use the Alias field to specify an alias for the database. If you do not specify an alias, the database name is used.
Comment
Use the Comment field to specify a comment for the
database. The maximum length for a comment is 30 characters.
Containers page
Redirect table space containers
Allow new container creation during
roll-forward
Table spaces
Container name
Add
Change
Remove
OK
Cancel
Redirect table space containers
Click on this check box to perform a redirected restore. When you select this check box, you must select another control on the Containers page to specify the type of container modification that you want to do.
You may not be able to perform a restore operation because a container is in the not valid state. In this situation, you must modify the container. You can either change the container's path or remove the container, then, if you want, perform an add operation to replace the deleted container with another container.
The state of the container is rolled up into that of its table space. To display the container that is in the not valid state, select the table space whose state is not valid. That table space's containers will be displayed in the Container name box, and their states will also be displayed. Select the container that you want, then specify the container modification.
Allow new container creation during roll-forward
Select this check box to allow information in the Containers field of the Table spaces box to be modified by the roll-forward phase of the restore to new database operation. If any create, remove, or alter container operations are recorded in the database logs, these operations will be reapplied during the roll-forward phase.
If you are not doing roll-forward recovery, this option has no effect.
Table spaces
This box displays the table spaces that are in the backup image that you are restoring to the new database. The columns are:
| Note: | If an attempt is made to overwrite an existing container, an error will occur. |
If the state of a table space is not valid, at least one of its containers has a path that will overwrite the container of another database. In this situation, you must modify the container. You can either change the container's path or remove the container, then, if you want, perform an add operation to replace the deleted container with another container.
To display the container that is in the not valid state, select the table space whose state is not valid. That table space's containers will be displayed in the Container name box, and their states will also be displayed. Select the container that you want, then specify the container modification.
Container name
This box displays all the containers for the table space that is selected in the Table spaces box. For a system-managed space (SMS), the absolute path and the state of the container are displayed. For a database-managed space (DMS), the absolute path, file size, and the state of the container are displayed. The states are as follows:
| Note: | If an attempt is made to overwrite an existing container, an error will occur. |
You cannot restore the database if the container is in this state because the container path will overwrite the container of another database: you must modify the container. You can either change the container's path or remove the container, then, if you want, perform an add operation to replace the deleted container with another container.
Add
Click on this push button to open a container editor window, in which you specify the container to add. The type of container editor window that opens will be the same as that of the table space:
Change
Click on this push button to open a window in which you can change the name, drive, and path of the selected container. If you select multiple containers, you can only change the drive.
| Note: | If the container state is not valid, you must either change its path, or remove it. If you remove the container, you can add a new container to replace it. |
Remove
Click on this push button to delete the selected container.
Roll-Forward page
Roll-Forward
Overview directory
Leave in roll-forward pending state
Alternate log path
OK
Cancel
Roll-Forward
Click on this check box to do roll-forward recovery on the database. There are two types of roll-forward recovery:
You can either type the date, or you can click on the arrow to open a calendar on which you select the date. Click on the arrows at the top of the calendar to display the month that you want, then on a date to select it. The calendar closes, and the date you selected will be displayed in the field.
Overflow directory
The roll-forward operation checks for logs in the location specified by the logpath database configuration parameter. If you have moved any logs from the location specified by the logpath parameter, use the Overflow directory field to specify the path to the logs that you moved.
To display the list of available directories, click
.
Leave in roll-forward pending state
Click on this check box to leave the database in the roll-forward pending state at the end of the restore database operation. This is the default because it allows you to roll forward changes after the restore-to-new-database operation completes.
A database in the roll-forward pending state cannot be used. To turn the roll-forward pending state off and make the database usable, you can:
| Note: | You cannot select Stop Roll-Forward if a roll-forward operation is in progress on the database. |
Alternate log path
The logpath database configuration parameter specifies the location of logs. The value in the Alternate log path field overwrites the default location of the logs, for the current roll-forward operation and for any subsequent operations.
If you want to overwrite the default location of logs, type a string of up
to 242 bytes, or, to search for and select a path, click:
The string can point to either a path name, or to a raw device. If the string points to a path name, it must be a fully qualified path name, not a relative path name.
| Note: | In a partitioned database environment, the node number is automatically appended to the path. This is done to maintain the uniqueness of the path in multiple logical node configurations. |
To specify a device, specify a string that the operating system identifies as a device. For example:
| Note: | You must have Windows NT Version 4.0 with Service Pack 3 installed to be able to write logs to a device. |
| Note: | You can only specify a device on AIX, Windows NT, and Solaris platforms. |
The new setting does not become the value of logpath until both of the following occur:
When the first new connection is made to the database, the database manager
will move the logs to the new location specified by logpath.
Options page
Process while
Performance
OK
Cancel
Process while
Select one of the following radio buttons to specify whether the restore database operation is to be done online or offline.
| Note: | When you restore a backup image to a new database, the operation is always offline because the database is not yet available for any other user to connect to it. |
Performance
Use the following fields to specify the number and size of the buffers to be used for the restore operation. You can increase the number of buffers or the size of each buffer (or both) to cause the restore operation to complete faster. Note that increasing the value specified for either option causes the restore operation to use more memory.