Recreating a Standby DB2 Database Using Commvault Backups

You can create a standby database using Commvault backups. If you restore the DB2 standby database using a Commvault backup, you need to reconfigure HADR.

Note: The destination target database path (Restore Options dialog box, General tab, Target Database path) and the destination storage path (Advanced Restore Options dialog box, Storage Path tab, Paths) must match the values that you used on the source.

Before You Begin

Configure the standby database to be in roll-forward pending state.

Procedure

On the standby database server client, add an instance.
From the CommCell Browser, navigate to Client Computers > client > DB2 > instance.
Right-click the backup_set, point to All Tasks and then click Browse and Restore.

The Browse and Restore dialog box appears.
On the Time Range tab, select Latest Backup and click View Content.
Select the databases to restore and click Recover All Selected.

The Restore Options dialog box appears.
On the Recover Database tab, clear the Recover DB check box.
On the Restore Arguments tab, in the Backup Images area, choose an option for selecting backup images:
- To let the Commvault software select the latest backup images or the latest point-in-time backup images, based on the choice you made on the Time Range tab on the Browse and Restore dialog box, choose Auto Pick Backup Images.
- To manually select a cycle of backup images, choose Select Backup Images. Select the images from the Available Images box, and then click > to move the selected images to the Selection box.
On the General tab, specify the destination information.
1. From the Destination Computer list, select the standby database server client.
2. From the Destination Instance list, select the standby database instance name.
3. In the Target Database Name box, type the standby database name.
4. In the Target Database path, type the location of the standby database.
Click Advanced.

The Advanced Restore Options dialog box is displayed.
In the Roll-Forward tab, select the Leave in Roll-forward Pending State checkbox.
Specify the storage path if you have an automatic database, or the redirect information if you have a non-automatic database:

Database Type	Procedure
Automatic or Mixed Databases	Note DB2 storage paths are displayed only if there are GUI backup jobs that have run for this database. You won't see storage paths displayed for third-party command line backup jobs. To specify the storage path, on the Storage Paths tab: Select the Redirect storage groups check box. The DB2 storage groups appear. From the Storage group box, select the DB2 storage group to view the existing path on the source database. In the Path box, select the path on the DB2 storage device. To change a path for this storage group, click it, then click Edit. Type the changes to the path. To add a path for this storage group, click Add, and then type the path.
Non-Automatic Databases	On the Redirect tab: Select the Redirect All Table Spaces/Database to check box Enter the path to redirect the tablespaces and database. Note The path must contain 'SQL0001.

Database Type

Procedure

Automatic or Mixed Databases

Note

DB2 storage paths are displayed only if there are GUI backup jobs that have run for this database. You won't see storage paths displayed for third-party command line backup jobs.

To specify the storage path, on the Storage Paths tab:

Select the Redirect storage groups check box.

The DB2 storage groups appear.
From the Storage group box, select the DB2 storage group to view the existing path on the source database.
In the Path box, select the path on the DB2 storage device.
- To change a path for this storage group, click it, then click Edit. Type the changes to the path.
- To add a path for this storage group, click Add, and then type the path.

Non-Automatic Databases

On the Redirect tab:

Select the Redirect All Table Spaces/Database to check box
Enter the path to redirect the tablespaces and database.

Note

The path must contain 'SQL0001.

Click OK to close the Advanced Restore Options dialog box.
Click OK to close the Restore Options dialog box.
After the restore operation is completed, go to the IBM DB2 help website and follow the instructions to configure HADR on both the primary and standby databases.

For information on how to configure the primary server, go to the IBM DB2 help website, Configuring the HADR primary server.

For information on how to configure the standby server, go to the IBM DB2 help website, Configuring the HADR standby server.

You must configure the following database parameters:
- Local IP Address (HADR_LOCAL_HOST)
- Local Service Name/Port (HADR_LOCAL_SVC)
- Remote IP Address (HADR_REMOTE_HOST)
- Remote Service Name/Port (HADR_REMOTE_SVC)
- Remote DB2 Instance Name (HADR_REMOTE_INST)
- Synchronization Mode (HADR_SYNCMODE)
Use the DB2 command line interface to start HADR on the standby database.

Substitute the standby_database_name parameter with the name of your standby database.
```
 
db2 start HADR ON DB standby_database_name as standby
```
Use the DB2 command line interface to start HADR on the primary database.

Substitute the primary_database_name parameter with the name of your standby database.
```
 
db2 start HADR ON DB primary_database_name as primary
```