Advanced Restore - DB2 iDataAgent

Table of Contents

Restoring and Recovering an Entire Database to the Same Host

You can restore an entire database after you deactivate the affected database. When you deactivate the database, all the db2 non administrative users will be disconnected. The system will deactivate the database if it is active. After the restore, the system automatically activates whatever database was deactivated by system or users. However, you need to connect the non administrative users manually after the restore operation.

Recovering a Database

By default, you can recover the database along with the restore operation. You cannot recover a partial database.

Use the following steps to recover the database per all the logs associated with the database:

  1. From the CommCell Browser, navigate to 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 is displayed.

  3. On the Time Range tab, select Latest Backup and click View Content.
  4. Select the databases to restore and click Recover All Selected.

    The Restore Options dialog box is displayed.

  5. On the Recover Database tab, select Recover DB check box.
  6. Click OK.

Recovering a Database to a Point- in-Time

Before You Begin

  • Verify that the DB2 archive log path and the DB2 retrieve path are empty.

Procedure

  1. From the CommCell Browser, navigate to 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 is displayed.

  3. On the Time Range tab, select Latest Backup and click View Content.
  4. Select the databases to restore and click Recover All Selected.

    The Restore Options dialog box is displayed.

  5. On the Recover Database tab and select Recover DB check box.
  6. Select To a Point-in-Time and enter the date and time.
  7. Click OK.

Restoring an Entire Database

Use the following steps to restore an entire DB2 database:

  1. From the CommCell Browser, navigate to 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 is displayed.

  3. On the Time Range tab, select Latest Backup and click View Content.
  4. Select the databases to restore and click Recover All Selected.

    The Restore Options dialog box is displayed.

  5. On the General tab, select the data to restore.
    1. Select the Restore Data check box.
    2. Select the Entire Database option.
  6. On the Recover Database tab, clear the Recover DB check box.
  7. On the Restore Arguments tab, select the backup images to restore from the Available Images box.
  8. Click OK.

Restoring an Entire Database to a Point-in-Time

Before You Begin

  • Verify that the DB2 archive log path and the DB2 retrieve path are empty.

Procedure

  1. From the CommCell Browser, navigate to 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 is displayed.

  3. On the Time Range tab, select the time range to use for the restore.
    1. Select Time Range.
    2. Select Absolute Time.
    3. Check the Start Time check box and enter the date and time.
    4. Check the End Time check box and enter the date and time.
    5. Click View Content.
  4. Select the databases to restore and click Recover All Selected.

    The Restore Options dialog box is displayed.

  5. On the General tab, select the data to restore.
    1. Select the Restore Data check box.
    2. Select the Entire Database option.
  6. On the Recover Database tab, clear the Recover DB check box.
  7. On the Restore Arguments tab, select the backup images to restore from the Available Images box.
  8. Click Advanced.

    The Advanced Restore Options dialog box is displayed.

  9. On the Roll-forward tab, select the time range to use for the restore.
    1. Select To a Point in Time.
    2. Enter the date and time.
  10. Click OK.

Redirecting a Restore to a Different DB2 Instance on the Same Host

You can redirect a restore to a different DB2 instance on the same host. When redirecting a restore to a different DB2 instance on the same host, ensure the following:

  • Configure the source DB2 instance, backup set and subclient on CommCell Console.
  • Configure the destination DB2 Instance on CommCell console.
  • Back up your subclient on the source instance.

Use the following steps to redirect a restore to a different instance on the same host.

  1. From the CommCell Browser, navigate to 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 is displayed.

  3. On the Time Range tab, select Latest Backup and click View Content.
  4. Select the databases to restore and click Recover All Selected.

    The Restore Options dialog box is displayed.

  5. On the General tab, select the data to restore.
    1. Select the Restore Data check box and click the Entire Database option.
    2. Select the tablespaces from the Latest Database View list.
    3. Select the Destination Instance from the destination instance list to change the instance on the same host.
    4. To change the target database name and location, type the Target Database Name and enter the path in the Target Database Path box

      For a Windows client, the Target Database Path is with a drive letter.

    5. Click Advanced.

      The Advanced Restore Options dialog box is displayed.

  6. On the Advanced Restore Options dialog box, navigate to the Redirect tab.
    • Select Redirect All Table Spaces/Database to and type the path or click Browse for the path to redirect tablespaces/database.
    • Click OK.
  7. Click OK.

Redirecting a Restore to a New Database

You can redirect a restore to a different database on the same host and same instance.

When you redirect a restore to a different database on the same host and same instance, ensure the following:

  • Configure the source DB2 instance, backup set and subclient on CommCell console.
  • Back up your subclient on the source database.

Note: if you redirect a restore as part of the DB2 transaction log replication for standby database procedure, the standby database name (Restore Options dialog box, General tab, Target Database Name box) must be different than the production (source) database name.

Procedure

  1. From the CommCell Browser, navigate to Client Computers > client > DB2 > instance.
  2. Right-click the backup_set, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. Select the database and click Recover All Selected.

    The Restore Options dialog box is displayed.

  5. On the Recover Database tab, clear the Recover DB check box.
  6. On the Restore Arguments tab, select a cycle of images from the Available Images.
  7. On the General tab, select the restore options.
    1. If this restore is for DB2 transaction log replication, clear the Restore Data check box, otherwise select the Restore Data check box and select Entire Database.
    2. Select the destination for the redirected restore from the Destination Computer list.
    3. In the Target Database Name, enter the target database name.
    4. In the Target Database path, type the location of the target database.
    5. Click Advanced.

      The Advanced Restore Options dialog box is displayed.

  8. If the DB2 is an Automatic Database, on the Storage Path tab, select the storage options.
    1. Select the Storage Paths check box.
    2. In the Paths box, select the existing paths and click Delete.
    3. Add the new paths. Click Add Paths and enter each path on a separate line.
  9. If the DB2 is a Non-Automatic Database, on the Redirect tab, select the redirect options.
    1. Select the Redirect All Table Spaces/Database to check box.
    2. Enter the new path for the tablsepaces and database.
  10. Click OK to close the Advanced Restore Options dialog box.
  11. Click OK to close the Restore Options dialog box.

Restoring and Recovering an Entire Database to a New Host

When restoring the databases to a new client, ensure the following:

  • The operating system on the destination client must be the same as that in the source client.
  • The DB2 application on the destination client should be the same (or later) version as that in the source client.
  • As a DB2 user, you should have sufficient rights to restore the database. See Configuring User Accounts for more information.
  • Install the DB2 Data Agent on both the source and client destination.
  • The destination client should be installed on same CommServe, and the destination DB2 instance should be configured on the CommCell console.
  • Install the DB2 iDataAgent on both the source client and the destination client.
  • Create (discover) instances of DB2 on the CommCell Console for both the source client and the destination client.
  • Configure the instance that you created with a valid user account and password, and storage policies.
  • Run a DB2 database backup on the source client.

Use the following steps to restore the database to a new client when the DB2 version are the same on both the source and client destinations.

  1. From the CommCell Browser, navigate to Client Computers > client > DB2 > instance.
  2. Right-click the backup_set, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. Select the database and click Recover All Selected.

    The Restore Options dialog box is displayed.

  5. On the Recover Database tab and clear the Recover DB check box.
  6. On the Restore Arguments tab and select the latest cycle of backup images.
  7. On the General tab, select the destination.
    1. Select the destination client name from the Destination Computer list.
    2. Select the instance name from the Destination Instance list.
    3. Type the database name in the Target Database Name box.
    4. In the Target Database path, type the location of the target database. If you do not specify this value, the tablespace path is the target_db_path+ instance_name+database_name. The tablespaces and online log paths are placed here.
  8. Click OK.

Restoring an Entire Database to a New Host with a Later DB2 Version

Procedure

  1. From the CommCell Browser, navigate to 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 is displayed.

  3. On the Time Range tab, select Latest Backup and click View Content.
  4. Select the databases to restore and click Recover All Selected.

    The Restore Options dialog box is displayed.

  5. On the Recover Database tab, clear the Recover DBcheck box.
  6. On the Restore Arguments tab, select the backup images to restore from the Available Images box.
  7. On the General tab, specify the destination information.
    1. Select the destination client name from the Destination Computer list.
    2. Select the instance name from the Destination Instance list.
    3. Type the database name in the Target Database Name box.
    4. In the Target Database path, type the location of the target database.
    5. Click Advanced.

      The Advanced Restore Options dialog box is displayed.

  8. 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 Storage Database On the Storage Path tab:
    1. Select the Storage Paths check box.
    2. Select the existing Paths in the box and click Delete.
    3. Click Browse to navigate to the target database paths, or click Add Paths to manually enter them.

    Note: If you do not specify a storage path, the SnapProtect software uses the target_database_path+ instance_name+database_name for the storage path. The target database path is the Target Database path (Restore Options dialog box, General tab).

    Non-Automatic Storage Database On the Redirect tab:
    1. Select the Redirect All Table Spaces/Database to check box
    2. Enter the path to redirect the tablespaces and database.

    Note: If you do not specify the tablespace path, the SnapProtect software uses the target_database_path+ instance_name+database_name for the tablespace and database redirect path. The target database path is the Target Database path (Restore Options dialog box, General tab).

  9. Click OK to close the Advanced Restore Options dialog box.
  10. Click OK to close the Restore Options dialog box.

Restoring to a New Host

You can rename and redirect one or more table spaces or table space containers to a different destination on the same or on different (cross-machine) host. The DB2 automatic storage database contains the automatic storage tablespaces, or a mix of both the automatic and non-automatic storage tablespaces. The DB2 non-automatic storage database contains the non-automatic storage tablespaces only.

When you restore to a new host:

  • Configure the source DB2 instance, backup set and subclient on the CommCell Console.
  • Configure the destination DB2 Instance on the CommCell Console.
  • Perform a backup of the source subclient.

Procedure

  1. From the CommCell Browser, navigate to 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 is displayed.

  3. On the Time Range tab, select Latest Backup and click View Content.
  4. Select the databases to restore and click Recover All Selected.

    The Restore Options dialog box is displayed.

  5. On the Recover Database tab, clear the Recover DB check box.
  6. On the Restore Arguments tab, select the backup images to restore from the Available Images box.
  7. On the General tab, specify the destination information.
    1. Select the destination client name from the Destination Computer list.
    2. Select the instance name from the Destination Instance list.
    3. Type the database name in the Target Database Name box.
    4. In the Target Database path, type the location of the target database.

      For a Windows client, the Target Database Path is the drive letter.

    5. Click Advanced.

      The Advanced Restore Options dialog box is displayed.

  8. 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 Storage Database On the Storage Path tab:
    1. Select the Storage Paths check box.
    2. Select the existing Paths in the box and click Delete.
    3. Click Browse to navigate to the target database paths, or click Add Paths to manually enter them.

    Note: If you do not specify a storage path, the SnapProtect software uses the target_database_path+ instance_name+database_name for the storage path. The target database path is the Target Database path (Restore Options dialog box, General tab).

    Non-Automatic Storage Database On the Redirect tab:
    1. Select the Redirect All Table Spaces/Database to check box
    2. Enter the path to redirect the tablespaces and database.

    Note: If you do not specify the tablespace path, the SnapProtect software uses the target_database_path+ instance_name+database_name for the tablespace and database redirect path. The target database path is the Target Database path (Restore Options dialog box, General tab).

  9. Click OK to close the Advanced Restore Options dialog box.
  10. Click OK to close the Restore Options dialog box.

Redirecting Specific Table Space Containers for Non-Automatic Storage Tablespaces

Procedure

  1. From the CommCell Browser, navigate to 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 is displayed.

  3. On the Time Range tab, select Latest Backup and click View Content.
  4. Select the databases to restore and click Recover All Selected.

    The Restore Options dialog box is displayed.

  5. On the Recover Database tab, clear the Recover DB check box.
  6. On the Restore Arguments tab, select the backup images to restore from the Available Images box.
  7. On the General tab, specify the destination information.
    1. Select the destination client name from the Destination Computer list.
    2. Select the instance name from the Destination Instance list.
    3. Type the database name in the Target Database Name box.
    4. In the Target Database path, type the location of the target database.

      For a Windows client, the Target Database Path is the drive letter.

    5. Click Advanced.

      The Advanced Restore Options dialog box is displayed.

  8. On the Redirect tab:
    1. Select the Redirect Table Space Containers check box.
    2. From the Table Space box, select the required table space to be redirected, the associated container name is displayed in the Container Name box.
    3. To redirect a tablespace, select the Container name and click Edit.
    4. In the Editing Container Name for Dataspace dialog box, click Browse to specify a new path. Add the container’s name after the path in the text box of Edit Container Name of Table Space box.
    5. Select the Container Type from the list.
  9. Click OK to close the Advanced Restore Options dialog box.
  10. Click OK to close the Restore Options dialog box.

Redirecting Automatic and Non-Automatic Storage Tablespaces on a Mixed Database

If a mix of both the automatic and non-automatic storage tablespaces exist in your DB2 automatic storage database, you can redirect both automatic and non-automatic tablespaces or tablespace containers to a new destination computer.

  1. From the CommCell Browser, navigate to 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 is displayed.

  3. On the Time Range tab, select Latest Backup and click View Content.
  4. Select the databases to restore and click Recover All Selected.

    The Restore Options dialog box is displayed.

  5. On the Recover Database tab, clear the Recover DB check box.
  6. On the Restore Arguments tab, select the backup images to restore from the Available Images box.
  7. On the General tab, specify the destination information.
    1. Select the destination client name from the Destination Computer list.
    2. Select the instance name from the Destination Instance list.
    3. Type the database name in the Target Database Name box.
    4. In the Target Database path, type the location of the target database.

      For a Windows client, the Target Database Path is the drive letter.

    5. Click Advanced.

      The Advanced Restore Options dialog box is displayed.

  8. On the Storage Path tab:
    1. Select the Storage Paths check box.
    2. Select the existing Paths in the box and click Delete.
    3. Click Browse to navigate to the target database paths, or click Add Paths to manually enter them.

    Note: If you do not specify a storage path, the SnapProtect software uses the target_database_path+ instance_name+database_name for the storage path. The target database path is the Target Database path (Restore Options dialog box , General tab).

  9. On the Redirect tab:
    1. Select the Redirect All Table Spaces/Database to check box
    2. Enter the path to redirect the tablespaces and database.

    Note: If you do not specify the tablespace path, the SnapProtect software uses the target_database_path+ instance_name+database_name for the tablespace and database redirect path. The target database path is the Target Database path (Restore Options dialog box , General tab).

  10. Click OK to close the Advanced Restore Options dialog box.
  11. Click OK to close the Restore Options dialog box.

Adding a Tablespace for Automatic Storage Database

You can add a new storage path if the table spaces reach their maximum capacity.

Use the following steps to add new storage path for automatic storage database:

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <Backup_Set>, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. Select the database and click Recover All Selected.
  5. On the Restore Options dialog box, navigate to the Recover Database tab.
    • Clear the Recover DB check box.
  6. On the Restore Options dialog box, navigate to the Restore Arguments tab.
    1. Select the backup images that include the automatic storage tablespaces from the available images.
    2. Click Advanced.
  7. On the Advanced Restore Options dialog box, navigate to the Storage Paths tab.
    1. Select the Specify Storage paths check box.
    2. Click Add Paths. You can add one or more paths, with a new line as a separator. Each path must exist locally and have an absolute path name. All the automatic storage table spaces will be automatically redirected to these newly defined paths.
    3. Click OK.
  8. Click OK.

Adding a New Container for a Tablespace

Use the following steps to add a table space container for non-automatic Storage tablespaces:

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <Backup_Set>, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. Select the database and click Recover All Selected.
  5. On the Restore Options dialog box, navigate to the Recover Database tab.
    • Clear the Recover DB check box.
  6. On the Restore Options dialog box, navigate to the Restore Arguments tab.
    1. Select the backup images that include the non-automatic storage tablespaces from the available images.
    2. Click Advanced.
  7. On the Advanced Restore Options dialog box, navigate to the Redirect tab.
    1. Select the Redirect Table Space Containers check box.
    2. From the Table Space box, select the required table space to be redirected, the associated container name is displayed in the Container Name box.
    3. To redirect a tablespace, select the Container name and click Add.
    4. In the Browsing Container Name for Dataspace dialog box, click Browse to specify a new path. Add the container’s name after the path in the text box of Edit Container Name of Table Space box. Select the Container Type from the list.
    5. Click OK.
    6. Click OK.
  8. Click OK.

Editing an Existing Container for a Tablespace

Use the following steps to edit a table space container for non-automatic storage tablespaces:

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <Backup_Set>, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. Select the database and click Recover All Selected.
  5. On the Restore Options dialog box, navigate to the Recover Database tab.
    • Clear the Recover DB check box.
  6. On the Restore Options dialog box, navigate to the Restore Arguments tab.
    • Select the backup images that include the non-automatic storage tablespaces from the available images.
    • Click Advanced.
  7. On the Advanced Restore Options dialog box, navigate to the Redirect tab.
    1. Select the Redirect Table Space Containers check box.
    2. From the Table Space box, select the required table space to be redirected, the associated container name is displayed in the Container Name box.
    3. To redirect a tablespace, select the Container name and click Edit.
    4. In the Editing Container Name for Dataspace dialog box, click Browse to specify a new path. Add the container’s name after the path in the text box of Edit Container Name of Table Space box. Select the Container Type from the list.
    5. Click OK.
    6. Click OK.
  8. Click OK.

Finding and Replacing a Container

Use the following steps to find and replace a table space container for non-automatic storage tablespaces:

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <Backup_Set>, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. Select the database and click Recover All Selected.
  5. On the Restore Options dialog box, navigate to the Recover Database tab.
    • Clear the Recover DB check box.
  6. On the Restore Options dialog box, navigate to the Restore Arguments tab.
    1. Select the backup images that include the non-automatic storage tablespaces from the available images.
    2. Click Advanced.
  7. On the Advanced Restore Options dialog box, navigate to the Redirect tab.
    1. Select the Redirect Table Space Containers check box.
    2. From the Table Space box, select the required table space to be redirected, the associated container name is displayed in the Container Name box.
    3. Click Find&Replace to select the new location and replace the existing path with a new location path during redirect restore operation.
    4. Click OK.
    5. Click OK.
  8. Click OK.

Deleting a Container

Use the following steps to delete a table space container for non-automatic Storage tablespaces which has more than one container:

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <Backup_Set>, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. Select the database and click Recover All Selected.
  5. On the Restore Options dialog box, navigate to the Recover Database tab.
    • Clear the Recover DB check box.
  6. On the Restore Options dialog box, navigate to the Restore Arguments tab.
    1. Select the backup images that include the automatic storage tablespaces from the available images.
    2. Click Advanced.
  7. On the Advanced Restore Options dialog box, navigate to the Redirect tab.
    1. Select the Redirect Table Space Containers check box.
    2. From the Table Space box, select the required table space to be redirected, the associated container name is displayed in the Container Name box.
    3. Click Delete to drop the selected (existing) container.
    4. Click OK.
  8. Click OK.

Performing a Cross-Machine Restore for a Standby Database

Use this procedure to restore a production database to a standby database.

Best Practice: If the standby database client machine and instance are the same, you must set the standby database name to a name that is different than the source database name (Restore Options dialog box, General tab, Target Database Name box).

Procedure

  1. From the CommCell Browser, navigate to Client Computers > client > DB2 > instance.
  2. Right-click the backup_set, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. Select the database and click Recover All Selected.

    The Restore Options dialog box is displayed.

  5. On the Recover Database tab, clear the Recover DB check box.
  6. On the General tab.
    1. Select the Restore Data check box and then select the Entire Database option.
    2. Select the destination client name from the Destination Computer list.
    3. If the standby database is on the production database, type the new database name in the Target Database Name box.
    4. Click Advanced.

      The Advanced Restore Options dialog box is displayed.

  7. On the Restore Arguments tab, select the backup images from Available Images and click >.

    The backup images to be restored will be moved to Selection box.

  8. On the Roll-Forward tab, select the Leave in Roll-forward Pending State check box.
  9. If the DB2 database is an Automatic Database, on t the Storage Path tab, delete the original path and type the new path that the tablespaces are redirected to.
  10. If the DB2 database is a Non-automatic Database, on the Redirect tab.
    • To redirect all tablespaces, select the Redirect All Table Spaces/Database to check box and then enter the path for the tablespaces.
    • To redirect tablespaces and containers, select the Redirect Table Space Containers check box. Select the tablespace and then click Edit.
  11. Click OK to close the Advanced Restore Options dialog box.
  12. Click OK to close the Restore Options dialog box

Restoring the Backup Images

When you restore a full backup image, make sure to select all associated incremental or delta backup images.

Restoring Backup Images in an Offline State

Use the following steps to restore the backup images in an offline state:

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <Backup_Set>, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. Select the database and click Recover All Selected.
  5. On the Restore Options dialog box, navigate to the Recover Database tab.
    • Clear the Recover DB check box.
  6. On the Restore Options dialog box, navigate to the Restore Arguments tab.
    1. Select the Offline Restore check box.
    2. Select the backup images from Available Images and click >. The backup images to be restored will be moved to Selection box.
  7. Click OK.

Restoring Backup Images in an Online State

Use the following steps to restore the backup images in an online state for tablespaces or history file restore :

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <Backup_Set>, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. Select the database and click Recover All Selected.
  5. On the Restore Options dialog box, navigate to the Recover Database tab.
    • Clear the Recover DB check box.
  6. On the Restore Options dialog box, navigate to the Restore Arguments tab.
    1. Select the Online Restore check box.
    2. Select the backup images from Available Images and click >. The backup images to be restored are moved to Selection box.
  7. Click OK.

Incremental Restores from One Full Backup Image

This option is applicable if the restore fails in the middle of the selected backup images. For example, if you have full backup image along with an incremental and a delta, the restore fails during the incremental backup image then you need restart again with this option after you resolve the issue. Select the full backup image only.

Use the following steps to perform an incremental restore from one full backup image:

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <Backup_Set>, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. Select the database and click Recover All Selected.
  5. On the Restore Options dialog box, navigate to the Recover Database tab.
    • Clear the Recover DB check box.
  6. On the Restore Options dialog box, navigate to the Restore Arguments tab.
    1. Select the Offline Restore check box.
    2. Select the Full backup images from the Available Images and click >. The backup images to restore are moved to Selection box
    3. Select Incremental Restore (from one Full backup image) check box.
  7. Click OK.

Restoring from Multiple Incremental Images

One backup image consists of one full backup with number of incremental or delta backups. You need to select a full backup, the last incremental backup and all the delta backups to perform a restore from multiple incremental images. Use the following steps to perform a restore from multiple incremental images:

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <Backup_Set>, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. Select the database and click Recover All Selected.
  5. On the Restore Options dialog box, navigate to the Recover Database tab.
    • Clear the Recover DB check box.
  6. On the Restore Options dialog box, navigate to the Restore Arguments tab.
    1. Select the Offline Restore .
    2. Select the LAST FULL, LAST INCREMENTAL, and all the DELTA backup images after LAST INCREMENTAL backup from Available Images and click >. The backup images to be restored will be moved to Selection box.
  7. Click OK.

Setting the Buffers for Restore

When you backup the database to multiple locations, you can give sufficient buffer value to improve the backup performance. The default value is 2.

Use the following steps to restore the backup images using buffers. When you backup the database to multiple locations, you can give sufficient buffer value to improve the backup performance. The default value is 2.

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <Backup_Set>, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. Select the database and click Recover All Selected.
  5. On the Restore Options dialog box, navigate to the Recover Database tab.
    • Clear the Recover DB check box.
  6. On the Restore Options dialog box, navigate to the Restore Arguments tab.
    1. Select the Offline Restore check box.
    2. Type of enter the Number of Buffers that a are a sufficient number to improve performance.
    3. Type of enter the Buffer Size.
    4. Select the backup images from Available Images and click >. The backup images to be restored will be moved to Selection box.
  7. Click OK.

Using Parallelism for Enhancing Restore Performance

If the database contains large number of tablespaces and indexes, you can perform a restore operation faster when you set a maximum number of concurrent parallelism queries to take advantage of available Input/Output bandwidth and processor power of DB2 server.

Use the following steps to enhance your restore operation:

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <Backup_Set>, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. Select the database and click Recover All Selected.
  5. On the Restore Options dialog box, navigate to the Recover Database tab.
    • Clear the Recover DB check box.
  6. On the Restore Options dialog box, navigate to the Restore Arguments tab.
    1. Select the Offline Restore check box.
    2. On the Parallelism box, type or select the maximum number of parallelism queries to enhance your restore operation.
    3. Select the backup images from Available Images and click >. The backup images to be restored will be moved to Selection box.
  7. Click OK.

Restoring Individual Tablespaces (Partial DB)

By default, you can restore an entire database in an Offline mode (default option - Offline restore). You can perform an online restore of the individual tablespaces excluding the SYSCATSPACE and TEMPSPACE tablespaces. When you perform a tablespace restore, the SnapProtect switches the restore to an online restore.

Use the following steps to restore individual tablespaces:

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <Backup_Set>, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. Select the database and tablespace and then click Recover All Selected.
  5. On the Restore Options dialog box, navigate to the General tab.
    1. Select the Restore Data check box.
    2. Select the Database Subset option.
    3. Select the tablespaces from the Latest Database View list.
  6. On the Restore Options dialog box, navigate to the Recover Database tab.
    • Clear the Recover DB check box.
  7. On the Restore Options dialog box, navigate to the Restore Arguments tab.
    1. Select the Online Restore or Offline Restore option.
    2. Select the Backup Images option.
    3. Select the backup images from Available Images and click >. The backup images to be restored will be moved to Selection box.
  8. Click OK.

Restoring Logs

Archive logs can be restored separately or along with the database if all logs have been backed up.

By default, the log files are restored to the DB2 Retrieve Path that was specified during the installation of the DB2 iDataAgent.

Archive Log restores are useful in the following scenarios:

  • If there is a database failure and you need to recover the database to the recent state, you restore all the logs along with the database.
  • If the logs from a specific time range were lost due to a hard disk corruption, you can restore them by performing a point-in-time restore of the logs.
  • In certain cases, you might need to restore only specific logs that are missing in the database. Such logs can be identified and then restored using a serial number or time ranges.

All Logs

By default, all the log files are restored. Use the following steps to restore all the log files:

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <Backup_Set>, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. Select the database and click Recover All Selected.
  5. On the Restore Options dialog box:
    1. On the General tab clear the Restore Data check box.
    2. On the Recover Database tab, clear the Recover DB check box.
    3. Click Advanced.
  6. On the Advanced Restore Options dialog box, navigate to the Log Files tab.
    1. Select the Restore Log Files check box.
    2. Select the All Log Files option.
    3. Click OK.
  7. On the Advanced Restore Options dialog box, navigate to the Roll-forward tab and clear the Roll-forward (Reapply the logs) check box.
  8. Click OK.

To a Specific Point-in-Time

Use the following steps to restore the log files to a specific point-in-time:

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <Backup_Set>, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. Select the database and click Recover All Selected.
  5. On the Restore Options dialog box:
    1. On the General tab clear the Restore Data check box.
    2. On the Recover Database tab, clear the Recover DB check box.
    3. Click Advanced.
  6. On the Advanced Restore Options dialog box, navigate to the Log Files tab.
    1. Select the Restore Log Files check box.
    2. Select the Point in Time option.
    3. Enter the Start and End Time.
    4. Click OK.
  7. On the Advanced Restore Options dialog box, navigate to the Roll-forward tab and clear the Roll-forward (Reapply the logs) check box.
  8. Click OK.

To a Specific Log Serial Number

Use the following steps to restore the log restore the log identified by a serial number:

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <Backup_Set>, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. Select the database and click Recover All Selected.
  5. On the Restore Options dialog box:
    1. On the General tab clear the Restore Data check box.
    2. On the Recover Database tab, clear the Recover DB check box.
    3. Click Advanced.
  6. On the Advanced Restore Options dialog box, navigate to the Log Files tab.
    1. Select the Restore Log Files check box.
    2. Select the By Log Serial Number option.
    3. Enter the Start and End Log Serial Numbers. To find Start and End Log Serial Numbers, view the Job Details for the job you want to use for the restore and look at the Range of Log Files.
    4. Click OK.
  7. On the Advanced Restore Options dialog box, navigate to the Roll-forward tab and clear the Roll-forward (Reapply the logs) check box.
  8. Click OK.

Recovering Databases by Reapplying the Logs (Roll-Forward)

You can recover the database by reapplying the log files containing transactions that are not part of any database backup image. The roll-forward capability is applied after a database or table space image is restored.

Before reapplying the logs (roll-forward) on the restored database, you must enable the logarchmeth1 database configuration parameter to perform log archiving. Whenever log files are restored with the roll-forward capability, DB2 searches for the following target restore paths:

  • DB2's own directory path for log file restores
  • The retrieve Path that was specified during the installation of the DB2 iDataAgent
  • The archive Path that was specified during the installation of the DB2 iDataAgent
  • The path identified (if any) in the Overflow Directory field within the Roll-Forward.

If it is unable to find any of these paths, the appropriate error is reported in a file within the DB2 Audit Error Path that was specified during installation of the DB2 iDataAgent.

After recovering the database, you will not be able to reapply the logs.

To the End of Logs

Use the following steps to reapply all of the logs to the database after a restore:

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <Backup_Set>, point to All Tasks and then click Browse and Restore.
  3. Select Time Range.
  4. Select the Absolute Time option and enter the End Time date and time.

    The default Time Zone is the CommServe computer's time zone.

  5. Select the database and click Recover All Selected.
  6. On the Restore Options dialog box, navigate to the Recover Database tab.
    • Clear the Recover DB check box.
  7. On the Restore Options dialog box, click Advanced.
  8. On the Advanced Restore Options dialog box, navigate to the Roll-Forward tab.
    1. Select the Roll-forward (Reapply the Logs) check box.
    2. Select the To the End of the logs option.
    3. Click OK.
  9. Click OK.

To a Point-in-Time

Use the following steps to reapply the logs till a point-in-time after a restore:

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <Backup_Set>, point to All Tasks and then click Browse and Restore.
  3. Select Time Range.
  4. Select the Absolute Time option and enter the End Time date and time.

    The default Time Zone is the CommServe computer's time zone.

  5. Select the database and click Recover All Selected.
  6. On the Restore Options dialog box, click Advanced.
  7. On the Advanced Restore Options dialog box, navigate to the Roll-Forward tab.
    1. Select the Roll-forward (Reapply the Logs) check box.
    2. Select the To a Point in Time option.
    3. Select the date and time to reapply the logs to.
    4. Click OK.
  8. Click OK.

To an Alternative Log Path

Use the following steps to reapply and restore the logs in an alternative (new) log path:

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <Backup_Set>, point to All Tasks and then click Browse and Restore.
  3. Select Time Range.
  4. Select the Absolute Time option and enter the End Time date and time.

    The default Time Zone is the CommServe computer's time zone.

  5. Select the database and click Recover All Selected.
  6. On the Restore Options dialog box, click Advanced.
  7. On the Advanced Restore Options dialog box, navigate to the Roll-Forward tab.
    1. Select the Roll-forward (Reapply the Logs) check box.
    2. Select the Alternate Log Path check box.
    3. Click Browse to select an alternative location within the DB2 directory for the log files.
    4. Click OK.
  8. Click OK.

To an Overflow Directory

This option allows you to specify a location for DB2 to find log files that are needed for a roll-forward operation.

If the required log file is not present in the location specified by the logpath database configuration parameter, DB2 searches the overflow directory.

Use the following steps to reapply and restore the logs in an overflow directory path:

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <Backup_Set>, point to All Tasks and then click Browse and Restore.
  3. Select Time Range.
  4. Select the Absolute Time option and enter the End Time date and time.

    The default Time Zone is the CommServe computer's time zone.

  5. Select the database and click Recover All Selected.
  6. On the Restore Options dialog box, click Advanced.
  7. On the Advanced Restore Options dialog box, navigate to the Roll-Forward tab.
    1. Select the Roll-forward (Reapply the Logs) check box.
    2. Click Browse to select the overflow directory.
    3. Click OK.
  8. Click OK.

Leaving the Database in Roll Forward Pending State

Use the following steps to keep the database in a pending state till the logs are reapplied:

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <Backup_Set>, point to All Tasks and then click Browse and Restore.
  3. Select Time Range.
  4. Select the Absolute Time option and enter the End Time date and time.

    The default Time Zone is the CommServe computer's time zone.

  5. Select the database and click Recover All Selected.
  6. On the Restore Options dialog box, click Advanced.
  7. On the Advanced Restore Options dialog box, navigate to the Roll-Forward tab.
    • Select the Roll-forward (Reapply the Logs) check box.
    • Select the Leave in Roll-forward Pending State check box to leave the database in a roll-forward pending state.
    • Click OK.
  8. Click OK.

Restoring History Files

You can recover history file if it is damaged or DB2 cannot access it. DB2 history file stores all information about backup, restore, and changes in the database.

By default, the DB2 database will be in Offline mode. However, you need to set the database in online mode to restore the history files. You cannot restore history files which contain database records regarding recovery and administration events along with the log files. Hence, make sure to disable the restoring of log files and reapplying the logs (roll-forward) on restored database.

To the Same Host:

Use the following steps to restore history files to the same host:

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <Backup_Set>, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. Select the database and click Recover All Selected.
  5. On the Restore Options dialog box, navigate to the General tab.
    1. Select the Restore Data check box.
    2. Select the History Files option.
  6. On the Restore Options dialog box, navigate to the Restore Arguments tab.
    1. Select the Online Restore option.
    2. Click Advanced.
  7. On the Advanced Restore Options dialog box, navigate to the Roll-Forward tab.
    • Clear the Roll-forward (Reapply the Logs) check box.
  8. On the Advanced Restore Options dialog box, navigate to the Log Files tab.
    1. Clear the Restore Log Files check box.
    2. Click OK.
  9. Click OK.

To a History File Path

The system will check the history file in order to select the backup image to restore. If the history file is not available, make sure to restore this file first before you recover the database. If the system does not find all the information in the history file that it needs to recover the database, you need to specify an alternative overflow directory.

Use the following steps to recover the database to a history file path:

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <Backup_Set>, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. Select the database and click Recover All Selected.
  5. On the Restore Options dialog box, navigate to the General tab.
    1. Select the Restore Data check box.
    2. Select the History Files option.
  6. On the Restore Options dialog box, navigate to the Recover Database tab.
    1. Select the Recover DB check box.
    2. Select the History File check box.
    3. Click Browse to select a History Path file.
  7. Click OK.

Creating Directories on the Target for Disaster Recovery and Cross-Machine Restores

In the event of a disaster, the recovery to the new target database may include creating the data directories on the target (destination) host if they do not exist. A similar situation may occur when performing a cross-machine restore.

The Create_Db_dir.ps1 or Create_Db_Dir.sh scripts are run on either a Windows or UNIX configuration and create the directory structure needed for a disaster recovery or cross-machine restore. This is mandatory when the data directory path does not exist on the target machine. If the directory structure exists and the script is run, the directory structure is NOT overwritten.

Further details on DB2 Disaster Recovery can be found here.

This script described in this procedure does not support table level or duplicate database restores. This script can only be used to restore a database to the same Oracle instance name on the same or a different server.

Procedure

Parameters

The following table defines the parameters for both scripts.

If you do not use the BackupJobID or PointInTime parameters, the current time is used for the Point-in-Time.

Parameter Description
clientName Specifies the name of the client as displayed in the CommCell Browser (e.g., client1).
SimpanaInstance The name of the SnapProtect instance.
DatabaseInstanceName The name of the database instance.
BackupJobID The Backup Job ID
PointInTime The Point-in-Time
BackupSetName For DB2 only. The name of the backup set.

UNIX

  1. You must be a database instance user in the UNIX group of SnapProtect to run this utility.
  2. Log onto the CommServe.
  3. Go to the <SnapProtect>/Base directory to locate the Create_Db_Dir.sh utility.
  4. Run the Create_Db_Dir.sh utility to create the directory

Usage

Create_Db_dir.sh -c <clientName> -i <SimpanaInstance> -d <DatabaseInstanceName> -j <BackupJobID> OR -p <PointInTime> -b <BackupSetName>

Windows

  1. The script Create_Db_Dir.ps1 is located under SnapProtect location.
  2. The Windows powershell needs to run it from SnapProtect_installation\Create_Db_Dir.ps1.
  3. Open the PowerShell prompt and verify the version is 2.0 or above.

    powershell Get-Host

  4. Verify the Execution Policy for PowerShell is 'Unrestricted'.

    powershell Get-ExecutionPolicy

    If needed, set the Execution Policy to 'Unrestricted'

    powershell Set-ExecutionPolicy Unrestricted

  5. Execute the script:

    powershell.\SnapProtect_installation\Create_Db_dir.sh -c <clientName> -i <SimpanaInstance> -d <DatabaseInstanceName> -j <BackupJobID> OR -p <PointInTime> -b <BackupSetName>

  6. Disable the powerShell script execution on the system:

    powershell Set-ExecutionPolicy Restricted

Usage

Create_Db_dir.ps1 -c <clientName> -i <SimpanaInstance> -d <DatabaseInstanceName> -j <BackupJobID> OR -p <PointInTime> -b <BackupSetName>

Restoring to Disk (App Free Restore)

You can restore the backup images of data and logs or multiple backup jobs at a time directly to a location on a disk using CommCell console without the intervention of DB2 application. This is useful for restoring multiplexed data on the same media. The data from different backup jobs are passed back to the client so that all of the interleaved backup jobs can be restored in parallel. You can restore the data associated with a specific backup job s such as full, incremental, log etc., in parallel streams. You can also submit multiple restore jobs from full and incremental backups. Later, you can restore DB2 database from DB2 command line using backup image from Disk without using the load SnapProtect library.

Use the following steps to restore a backup image on a disk using CommCell console :

  1. From the CommCell Browser, navigate to Client Computers | <Client> | DB2 | <Instance>.
  2. Right-click the <Backup_Set>, point to All Tasks and then click Restore to Disk.
  3. Click OK.
  4. On the Restore to Disk dialog box, select the backup job that you want to restore to a disk. Right click on the job and select Restore to Disk. You can select multiple backup jobs at a time and restore them to disk.
  5. On the Restore Options dialog box, navigate to the General Tab.
    1. Select the Destination Client from the drop down list.
    2. Type the path or click Browse to specify the location of the disk to restore the application data.
    3. Select the Impersonate User if you want to use a different account with the required privileges. In the User Name box, type the user name. The User should have necessary privileges to restore the application data.

      In the Password box, type the password for the user account.

      In the Confirm Password box, re-type the password.

  6. Click OK.
  7. The backup images will be restored to the disk location specified in the Restore Options for All Selected Items dialog box.

    DB2 iDataAgent will create a new folder with the current restore job id on the destination directory which has been specified during the restore operation. This folder contains the backup images and DB2 archive logs.

    Log Files

    <restore_destination_path>/<restore_job_id>/LOGS/DB2/<Node Number>/<Chain number>/Log_files

    Data

    <restore_destination_path>/<restore_job_id>/<Backup_images>

    You can run a disk restore using this backup image at the following location:

    db2 restore database <db_name> taken at <backup_image_timestamp>

    You can also use the following command to restore the backup image.

    db2 restore database <db_name> from <restore_destination_path>/<restore_job_id> taken at <backup_image_timestamp>

    You can recover the database by reapplying the log files (roll forward). Make sure that the SnapProtect services are running on this client.

    db2 rollforward database <db_name> to end of logs and stop overflow log path "(<Restore_Destination_path>/<Restore_Jobid>)"

If you are trying to restore one cycle of backup images which include Full, incremental and deltas, you should use the last backup image timestamp (incremental or delta) with incremental automatic key word to restore:

db2 restore database <db_name> incremental automatic from <restore_destination_path>/<restore_job_id> taken at <late_incremental or delta_backup_image_timestamp>

The multi streams backup job will have multiple backup images as number of streams after restoring to disk.

Restoring a Non-recoverable Database with an Offline Backup

DB2 supports backup and restore of an non-recoverable database.

Follow these steps.

  1. From the CommCell Browser, navigate to Client Computers | <Client> | DB2 | <Instance>.
  2. Right-click the <Backup_Set>, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Time Range and Absolute Time with the Start Time and End Time and then click View Content.
  4. Select the databases and click Recover All Selected.
  5. On the Restore Options dialog box, select the Restore Data check box and select the Entire Database option.
  6. On the Restore Options dialog box, navigate to the Recover Database tab and clear the Recover DB check box.
  7. On the Restore Options dialog box, navigate to the Restore Options tab and select an offline backup from Available Images. Click Advanced.
  8. On the Advanced Restore Options dialog box, navigate to the Roll-Forward tab and clear the Roll-forward (Reapply the logs) check box. Click OK.
  9. Click OK.

Performing a Restore on a Restore Only Client

Make sure to perform the following prior to performing a restore on a Restore Only Client.

  • Backup the DB2 database on a source client which has full license. When a component is installed on a client computer in restore only mode, license for that component will not be consumed and you will be able to use that client only as a destination for restoring backed up data that is residing on a different computer. You cannot perform backup operations on that client computer. See Installing Restore Only Agents for more information on installing restore only client.
  • Install the DB2 iDataAgent in regular mode on a target client.
  • Release the license using the following steps:
    1. From the CommCell Browser, navigate to Client Computers | <Client>
    2. Right-click the DB2, point to All Tasks and then click Release License.
    3. Click Yes to release the license.

    Use the following steps to perform a restore on a restore only client:

    1. From the CommCell Browser, navigate to Client Computers | <Client> | DB2 iDataAgent | <Instance>.
    2. Right-click the <Backup_Set>, point to All Tasks and then click Browse and Restore.
    3. Select Latest Backup and click View Content.
    4. Select the database and click Recover All Selected.
    5. On the Restore Options dialog box, navigate to the Recover Database tab and clear the Recover DB check box.
    6. On the Restore Options dialog box, navigate to the Restore Arguments tab. Select a cycle of backup images from the available images.
    7. On the Restore Options dialog box, navigate to the General tab.
    8. On the Restore to Disk dialog box, select the backup job that to restore to a disk. Right click on the job and select Restore to Disk. Select multiple backup jobs at a time and restore them to disk.
    9. On the Restore Options dialog box, navigate to the General Tab.

      Select the target client/DB2 instance name from the Target Database Name list.

      In the Target Database path, type the location of the target database/tablespaces. Alternatively, click Browse to select the path.

    10. Click OK.

    Scheduling a Restore

    Use the following steps to schedule a restore job:

    1. From the CommCell Browser, navigate to Client Computers | <Client> | DB2 iDataAgent | <Instance>.
    2. Right-click the <Backup_Set>, point to All Tasks and then click Browse and Restore.
    3. Select Latest Backup and click View Content.
    4. Select the database and click Recover All Selected.
    5. Select the required restore options.

    6. Click Job Initiation tab and then click Schedule.
    7. Click Configure.

    8. Select the appropriate scheduling options. For example:
      • Click Weekly.
      • Check the days you want the run the restore job.
      • Change the Start Time to 9:00 PM.

    9. Click Options for the following advanced schedule options:
      • Range of recurrence
      • Repeat times
      • Time Zone
    1. Click OK.

      The restore job will execute as per the schedule.

    Managing Restore Jobs

    Once you initiate the restore operation, a restore job is generated in the Job Controller. Jobs can be managed in a number of ways. The following sections provide information on the different job management options available:

    Restarting Jobs

    Jobs that fail to complete successfully are automatically restarted based on the job restartability configuration set in the Control Panel. Keep in mind that changes made to this configuration will affect all jobs in the entire CommCell.

    To Configure the job restartability for a specific job, you can modify the retry settings for the job. This will override the setting in the Control Panel. It is also possible to override the default CommServe configuration for individual jobs by configuring retry settings when initiating the job. This configuration, however, will apply only to the specific job.

    Restore jobs for this Agent are resumed from the point-of-failure.

    Configure Job Restartability at the CommServe Level

    1. From the CommCell Console toolbar, click Control Panel.
    2. Under the System section, click Job Management.
    3. Click Job Restarts tab and select a Job Type.
      • Select Restartable to make the job restartable.
      • You can change the value for Max Restarts to change the maximum number of times the Job Manager will try to restart a job.
      • You can change the value for Restart Interval (Mins) to change the time interval between attempts for the Job Manager to restart the job.
    4. Click OK.

    Controlling Jobs

    The following controls are available for running jobs in the Job Controller window:

    Suspend

    Temporarily stops a job. A suspended job is not terminated; it can be restarted at a later time.

    Resume

    Resumes a job and returns the status to Waiting, Pending, Queued, or Running. The status depends on the availability of resources, the state of the Operation Windows, or the Activity Control setting

    Kill

    Terminates a job.

    Suspending a Job

    1. From the Job Controller of the CommCell Console, right-click the job and select Suspend.
    2. The job status may change to Suspend Pending for a few moments while the operation completes. The job status then changes to Suspended.

    Resuming a Job

    1. From the Job Controller of the CommCell Console, right-click the job and select Resume.
    2. As the Job Manager attempts to restart the job, the job status changes to Waiting, Pending, or Running.

    Killing a Job

    1. From the Job Controller of the CommCell Console, right-click the job and select Kill.
    2. Click Yes when the confirmation prompt appears if you are sure you want to kill the job. The job status may change to Kill Pending for a few moments while the operation completes. Once completed, the job status will change to Killed and it will be removed from the Job Controller window after five minutes.

    Resubmitting Jobs

    If a restore job fails to complete successfully, you can resubmit the job without the need to reconfigure the original job's restore options using the Resubmit Job feature. When a job is resubmitted, all the original options, restore destinations, and other settings configured for the job remain in tact.

    Resubmit a Restore Job

    1. From the CommCell Browser, right-click a client computer whose data recovery history you want to view, click View, then click to view a job history.
    2. From the Job History Filter dialog box, select Restore.
      • If you want to view more advanced options for restores, from the Job History Filter, select Restore, then click Advanced.
      • From the Data Recovery History Advanced Filter select the destination client computer of the restores you would like to view, then click OK.
    3. The system displays the results of the options you selected in the Data Recovery Job History window.
    4. Right-click on any job, and select Resubmit.
    5. Select the job options.
    6. Click OK.

    Additional Restore Options

    Several additional options are available to further refine your restore operations. The following table describes these options, as well as the steps to implement them.

    Be sure to read the overview material referenced for each feature prior to using them.

    Option Description Related Topics
    Use hardware revert capability if available This option allow you to revert the data to the time when the snapshot was created. Selecting this option brings back the entire LUN to the point when the snapshot was created, overwriting all modifications to the data since the snapshot creation. This option is only available if the storage array used for SnapProtect Backup supports the revert operation.
    1. From the CommCell Browser, navigate to Client Computers | <Client> | DB2 iDataAgent | <Instance>.
    1. Right-click the <Backup_Set> point to All Tasks, and then click Browse Backup Data.
    2. Click OK.
    3. In the right pane of the Browse window, select the data you want to restore and click Recover All Selected.
    4. Click Recover Database tab.
    5. Select Use hardware revert capability if available check box.
    6. Click OK.
    Startup Options

    The Startup Options are used by the Job Manager to set priority for resource allocation. This is useful to give higher priority to certain jobs. You can set the priority as follows:

    1. From the CommCell Browser, navigate to Client Computers | <Client> | DB2 iDataAgent | <Instance>.
    1. Right-click the <BackupSet> point to All Tasks, and then click Browse Backup Data.
    2. Click OK.
    3. In the right pane of the Browse window, select the data you want to restore and click Recover All Selected.
    4. Click Advanced.
    1. Click Startup tab.
    2. Select Change Priority.
    3. Select a priority number - 0 is the highest priority and 999 is the lowest priority.
    4. Select the Start up in suspended State check box to start the job in a suspended state.
    5. Click OK.
    Refer to Job Priority and Priority Precedence.
    Copy Precedence By default, the system retrieves data from the storage policy copy with the lowest copy precedence. If the data was pruned from the primary copy, the system automatically retrieves data from the other copies of the storage policy in the lowest copy precedence to highest copy precedence order. Once the data is found, it is  retrieved, and no further copies are checked.

    You can retrieve data from a specific storage policy copy (Synchronous Copy or Selective Copy). If data does not exist in the specified copy, the data retrieve operation fails even if the data exists in another copy of the same storage policy. Follow the steps given below to retrieve the data from a specific storage policy copy:

    1. From the CommCell Browser, navigate to Client Computers | <Client> | DB2 iDataAgent | <Instance>.
    1. Right-click the <BackupSet> point to All Tasks, and then click Browse Backup Data.
    2. Click OK.
    3. In the right pane of the Browse window, select the data you want to restore and click Recover All Selected.
    4. Click Advanced.
    1. Click Copy Precedence tab.
    2. Select the Restore from copy precedence check box.
    3. Select the number from Copy Precedence list.
    4. Click OK.
    Refer to Recovering Data From Copies.
    Data Path Options

    The data recovery operations use a default Library, MediaAgent, Drive Pool, and Drive as the Data Path. You can use this option to change the data path if the default data path is not available. Follow the steps given below to change the default data path:

    1. From the CommCell Browser, navigate to Client Computers | <Client> | DB2 iDataAgent | <Instance>.
    1. Right-click the <BackupSet> point to All Tasks, and then click Browse Backup Data.
    2. Click OK.
    3. In the right pane of the Browse window, select the data you want to restore and click Recover All Selected.
    4. Click Advanced.
    1. Click Data Path tab.
    2. Select the MediaAgent from Use MediaAgent list.
    3. Select the Library from Use Library list.
    4. Select the drive pool and drive from Use Drive Pool and Use Drive lists for tape library.
    5. Select the name of the Proxy server  from Use Proxy list, if you wish to restore using a proxy server.
    6. Click OK.
    Refer to Change Data Path.
    Encryption

    If the client's data is encrypted with a pass phrase, you must enter the pass-phrase to start the data recovery operation. Follow the steps given below to enter the pass-phrase:

    1. From the CommCell Browser, navigate to Client Computers | <Client> | DB2 iDataAgent | <Instance>.
    1. Right-click the <BackupSet> point to All Tasks, and then click Browse Backup Data.
    2. Click OK.
    3. In the right pane of the Browse window, select the data you want to restore and click Recover All Selected.
    4. Click Advanced.
    1. Click Encryption tab.
    2. Type the pass phrase in Pass Phrase box.
    3. Re-type the pass phrase in Re-enter Pass Phrase box.
    4. Click OK.
    Refer to Data Encryption.
    Alerts

    This option enables users or user groups to get automatic notification on the status of the data recovery job. Follow the steps given below to set up the criteria to raise notifications/alerts:

    1. From the CommCell Browser, navigate to Client Computers | <Client> | DB2 iDataAgent | <Instance>.
    1. Right-click the <BackupSet> point to All Tasks, and then click Browse Backup Data.
    2. Click OK.
    3. In the right pane of the Browse window, select the data you want to restore and click Recover All Selected.
    4. Click Advanced.
    1. Click Alerts tab.
    2. Click Add Alert.
    3. From the Add Alert Wizard box, select the required threshold and notification criteria and click Next.
    4. Select the required notification types and click Next.
    5. Select the recipients and click Next.
    6. Click Finish.
    7. Click OK.
    Refer to Alerts and Notifications.
    CommCell Readiness Report The CommCell Readiness Report provides you with vital information such as connectivity and readiness of the Client, MediaAgent, and CommServe. It is useful to run this report before performing a backup or a recovery operation. Follow the steps given below to generate the report:
    1. On the CommCell Console menu bar, select the Reports tab.
    2. Click Readiness.

      The Report Selection dialog box appears.

    3. If necessary, select Reports | CommServe | CommCell Readiness in the left pane.
    4. Select the Computers tab, and then click Modify below the Computers list.
    5. In the dialog box that appears, clear Include All Client Computers and All Client Groups.
    6. Select the appropriate client from the Exclude list, and then click Include >.
    7. Click OK.
    8. Select the MediaAgent tab, and then clear Include All MediaAgents.
    9. Select the appropriate MediaAgent from the Exclude list, and then click Include >.
    10. Click Run.

      The report appears in your default Web browser.

    Refer to CommCell Readiness Report.
    Restore Job Summary Report

    The Restore Job Summary Report provides you with information about all the data recovery jobs that are run in last 24 hours for a specific client and agent. You can get information such as failure reason, failed objects, job options, and so on. It is useful to run this report after performing the restore. Follow the steps given below to generate the report:

    1. On the CommCell Console menu bar, select the Reports tab.
    2. Click Summary.

      The Report Selection dialog box appears.

    3. If necessary, select Reports | Jobs | Job Summary in the left pane.
    4. On the General tab, select Data Recovery Jobs.
    5. Select the Computers tab.
    6. Select the appropriate client and the appropriate agent.
    7. Click Run.

      The report appears in your default Web browser.

    Refer to Restore Job Summary Report.