Loading...

Restoring a DB2 Database Out of Place

You can browse backed up data to run an out-of-place DB2 database restore operation. You can redirect table spaces and storage groups during the database restore operation.

Procedure

  1. From the navigation pane, go to Protect > Databases.

    The Instances page appears.

  2. Click the instance.

    The instance page appears.

  3. On the Overview tab, in the Recovery points section, select the database from the list, and then click Restore.

    The Backup content page appears.

  4. Select the data to restore, and then click Restore.

    The Restore options dialog box appears.

  5. On the Out of place tab, select the destination host and the destination instance.
  6. In the Target database name box, enter a name for the restored database.
  7. To define the path for the target database, in the Target database path box, enter the full path to the location of the target database.
  8. To roll forward the logs as part of the restore operation, select the Roll forward checkbox.
    • To roll forward to the end of all the logs, click To end of the logs.
    • To roll forward to a point in time, click Point in time, and then enter the point in time.

    If you don't roll forward the logs the target database will be in the "rollforward pending" state after the restore.

  9. To redirect table spaces for a non-automatic database or to redirect storage groups for an automatic or mixed database, click Redirect.

    The Redirect path options dialog box appears.

    1. Complete the steps for the type of redirect operation you want:
      • To redirect all table spaces, on the Tablespaces tab click Redirect all tablespaces, and then in the box enter the full path for the location of the table spaces.
      • To redirect only some table spaces, on the Tablespaces tab click Redirect individual tablespaces. To redirect a table space, expand the table space name and in the Datafiles text box change the path to the new location for the table space.
      • To redirect storage groups, on the Storage groups tab expand a storage group name, and then in the Paths text boxes change the paths to the new locations for the storage group.
    2. Click Save.
  10. To restore the logs, in the Advanced options section select the Restore logs checkbox, and then specify the time period of the logs to restore.
  11. Click Submit.

Last modified: 9/29/2020 4:57:47 PM