> CommCell Console > Backup and Restore Agents > Snapshot Management > Supported Agents > DB2 > Restore Operations for DB2 Databases

Restoring a DB2 Backup to a New Host

When a database host is damaged or destroyed, you can restore the database to a new host.

The Commvault software waits 2 minutes for the IntelliSnap operation to complete. If the job does not complete when this time expires, the Commvault software marks the job as failed and brings the database out of the quiesced state. You can set this to a higher value to allow more time for the job to complete. For more information, see Configuring the time the Commvault Software Waits for the IntelliSnap Operation.

Note

When you restore a backup to a new host, if the target DB2 database does not exist, then the Commvault software creates it.

Before You Begin

  1. Install theDB2 Agent on the destination client.

  2. Create and configure a DB2 instance on the CommCell Console at the source and destination clients.

  3. Perform a full backup.

  4. Verify the following requirements:

    • The operating system on the destination client is the same as the operating system on the source client.

    • The DB2 application on the destination client is the same version or a later version of the DB2 application on the source client.

    • The DB2 user has sufficient rights to restore the database.

    • The number of storage paths on the destination must be equal to or less than the number of storage paths on the source, because the Commvault software provides a source to destination mapping to restore and relocate.

    • The user and group IDs on the source and destination are the same.

  5. On Windows computers, verify that no databases exist on the destination directory. If databases exist on the destination directory, then the restore operation destroys the databases because the SQLDBDIR information from the source database overwrites the destination information.

Procedure

  1. From the CommCell Browser, expand Client Computers > client > DB2 > instance.

  2. Right-click the backup_set, point to All Tasks, and then click Browse and Restore.

    The Browse and Restore dialog box appears.

  3. On the Time Range tab, select Latest Backup, and then click View Content.

  4. Optional: Use non-default browse and restore options. See Browse and Restore.

  5. From the Browse window, select the data to restore in the right pane, and then click Recover All Selected.

    The Restore Options dialog box appears.

  6. On the General tab, select the following options:

    1. Select the Entire Database option.

    2. From the Destination Computer list, select the destination client name.

    3. from the Destination Instance list, select the destination instance.

    4. To change the target database name and location, in the Target Database Path box, type the new path.

      For Windows clients, the target database path is the drive letter (for example, E:\).

  7. Optional: Recover the database after the restore. On the Recover tab, select the Recover Database check box.

  8. Click OK.

What to Do Next

When the original database is removed from the DB2 system, after the redirect restore operation on the same instance of the same host, you must manually clean the original data files on the source.

×

Loading...