SnapProtect - Advanced Restore - DB2

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 automatically activate the database after the restore operation. However, you need to connect the non administrative users manually after the restore operation.

When the database is corrupted or lost, you can restore and recover it from the latest offline or online full backup (depending on how the subclient was configured for backups).

By default, the database is restored to the same location from where it was backed up. Once the database is restored, it is recovered to the current time.

When the SnapProtect software start an SnapProtect operation, it quiesces the database. The database remains in that state until the SnapProtect operation completes. To prevent the operation from causing the database to be in the quiesced state, the SnapProtect software waits 2 minutes for the SnapProtect operation to complete. 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 SnapProtect Software Waits for the SnapProtect Operation.

Recovering an Entire Database

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

Use the following steps to recover the database:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | DB2 | <Instance>.
  2. Right-click the <BackupSet>, 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 General tab of the Restore Options dialog box, select the Use Snap Restore check box.
  6. On the Recover Database tab of the Restore Options dialog box, select the Recover DB check box and select the To the End of the logs option.
  7. 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 <BackupSet>, point to All Tasks and then click Browse and Restore.
  3. Select  Time Range, select the Start Time and End Time check boxes, enter the times and click View Content.
  4. Select the database and click Recover All Selected.
  5. On the General tab of the Restore Options dialog box, select the Use Snap Restore check box.
  6. On the Recover Database tab of the Restore Options dialog box, select the Recover DB check box and select the To Point-in-Time option and enter the date and time.
  7. Click OK.

Using a Hardware Revert Capability

This option allow you to revert the data to the time when the snapshot was created. Selecting this option brings back the entire volume to the point when the snapshot was created, overwriting all the modifications to data since the snapshot creation. This option is available if the snapshot engine used for the SnapProtect Backup supports the revert operation.

Use the following steps to restore and recover a database using a hardware revert capability:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | DB2 | <Instance>.
  2. Right-click the <BackupSet>, point to All Tasks and then click Browse and Restore.
  3. Click View Content.
  4. From the Browse window, select the data to restore in the right pane and click Recover All Selected.
  5. On the General tab of the Restore Options dialog box, select the Use Snap Restore check box.
  6. On the Recover Database tab of the Restore Options dialog box:
    1. Select the Recover DB check box.
    2. Select the Use hardware revert capability if available check box.
    3. Select the To a Point-in-Time option and enter the date and time.
  7. Click OK.

When the original database is removed from the DB2 system, after the redirect restore on same instance of same host, you must manually clean the original data files on the source.   On the same instance of same host, the original database is overwritten after the name/path change.

Restoring and Recovering an Entire Database to a New Host

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

  • On Windows configurations, make sure there are no databases existing on the destination's directory. If there are databases, the restore will destroy the databases because the SQLDBDIR information from the source database overwrites the destination information.
  • The operating system on the destination client must be the same as that in the source client.
  • The DB2 application on the destination client must be the same (or later) version as that in the source client.
  • The DB2 user must have sufficient rights to restore the database. See Configuring User Accounts for more information.
  • The database path (db_path) and storage path must be the same on the destination for redirected restores.
  • When performing a restore for storage paths, the number of storage paths on the destination must be equal or less than the number on the source because the SnapProtect software provides a source to destination mapping to restore and relocate.
  • When you restore the database to a new client, use the same user/group IDs of the DB2 instance.
  • Install the DB2 iDataAgent on both the source client and the destination client.
  • Create and configure an instance of DB2 on both the source client and the destination client on the CommCell.
  • Run a DB2 database backup on the source client.
  • When the original database is removed from the DB2 system, after the redirect restore on the same instance of the same host, you must manually clean the original data files on the source.

When the SnapProtect software start an SnapProtect operation, it quiesces the database. The database remains in that state until the SnapProtect operation completes. To prevent the operation from causing the database to be in the quiesced state, the SnapProtect software waits 2 minutes for the SnapProtect operation to complete. 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 SnapProtect Software Waits for the SnapProtect Operation.

Use the following steps to restore the database to a new client:

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <BackupSet>, 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 General tab of the Restore Options dialog box:
    1. Select the Use Snap Restore check box.
    2. Select the Entire Database option.
    3. Select the destination client name from the Destination Computer list.
    4. To change the instance, select the Destination Instance from the destination instance list.
    5. To change the target database name and location, enter it in the Target Database Name or click Browse to select the Target Database Path.

      For Windows clients, the Target Database Path is the drive letter (for example: E:\).

  6. Click OK.

Redirecting a Restore to a New Host

You can redirect all tablespaces/database to a different path in the destination client while performing a restore. This is useful when the destination server has a different storage management solution (automatic or non-automatic storage databases or for troubleshooting purposes. Currently, you can redirect an entire database (all tablespaces) to a new client.

When redirecting a restore to a new host, ensure the following:

  • Configure the source DB2 instance, backupset and subclient with SnapProtect enabled on the CommCell console.
  • Configure the destination DB2 Instance on the CommCell console.
  • Backup your SnapProtect Subclient on the Source client.

Use the following steps to redirect a restore to a new host:

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <BackupSet>, 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 General tab of the Restore Options dialog box:
    1. Select the Use Snap Restore check box.
    2. Select the Entire Database option.
    3. Select the destination client name from the Destination Computer list.
    4. To change the instance, select the Destination Instance from the destination instance list.
    5. To change the target database name and location, enter it in the Target Database Name. or click Browse to select the Target Database Path.
    6. Click Advanced.
  6. On the Redirect tab of the Advanced Restore Options dialog box:
    1. Select Redirect All Table Spaces/Database to check box and type the path or click Browse for the path to redirect all tablespaces/database. See Redirecting All Tablespaces/Database to a New Directory for more information.
    2. To change the destination storage paths of an automatic storage database, see Modifying the Destination Storage Paths.
    3. Click OK.
  7. Click OK.

Redirecting 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, backupset and subclient with SnapProtect enabled on CommCell console.
  • Configure the destination DB2 Instance on CommCell console.
  • Backup your SnapProtect Subclient on Source instance.

The target database and online log files are created in the Target Database Path you set in Step #5d. 

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

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 | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <BackupSet>, 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 General tab of the Restore Options dialog box:
    1. Select the Use Snap Restore check box.
    2. Select the Entire Database option.
    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, you can type the Target Database Name. Enter the location or click Browse to select the Target Database Path.
    5. Click Advanced.
  6. On the Redirect tab of the Advanced Restore Options dialog box:
    1. To change the destination tablespaces/containers of non-automatic storage database, select Redirect All Table Spaces/Database to and type the path or click Browse for the path to redirect all tablespaces/database. See Redirecting All Tablespaces/Database to a New Directory for more information.
    2. To change the destination storage paths of an automatic storage database, see Modifying the Destination Storage Paths.
    3. Click OK.
  7. Click OK.

Redirecting a Restore to a New Database on the Same Host and Same Instance

When redirecting 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 with SnapProtect enabled on CommCell Console.
  • Backup your SnapProtect Subclient on Source backup set (database).

The original database name is gone on the DB2 system, but the database (backup set) is kept on the CommCell Console for restore purposes.

You must manually remove the database files.

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

Note: The software uses the DB2 db2relocate command.  Do not user this procedure if you do not want to change any of the following when you copy or move a database to the same or a different host:

  • The database name
  • The path or drive that the database was created on
  • A tablespace container

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 General tab:
    1. Select the Use Snap Restore check box.
    2. Select the Entire Database option.
    3. Enter a different database name on the same host and same instance from the Target Database Name list. Enter the location.
    4. Click Advanced.

      The Advanced Restore Options dialog box is displayed.

  6. On the Redirect tab:
    1. To change the destination tablespaces or containers of non-automatic storage database, select Redirect All Table Spaces/Database to and type the path or click Browse for the path to redirect all tablespaces/database. See Redirecting All Tablespaces/Database to a New Directory for more information.
    2. To change the destination storage paths of an automatic storage database, see Modifying the Destination Storage Paths.
    3. Click OK.
  7. Click OK.

Redirecting All Tablespaces and Database to a New Directory

You can redirect all the tablespaces\database and tablespace containers to a new destination computer from CommCell console.

Use the following steps to redirect all the tablespaces/database:

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <BackupSet>, 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 Recover Database tab of the Restore Options dialog box click Advanced.
  6. On the Restore Arguments tab of the Restore Options dialog box:
    1. Select the backup images from the Available Images.
    2. Click Advanced.
  7. On the Redirect tab of the Advanced Restore Options dialog box:
    1. To change the destination tablespaces/containers of non-automatic storage database, select the Redirect All Table Spaces/Database to check box.
    2. Click Browse to select a new location to redirect the databases during the restore operation.
    3. Click OK.
  8. Click OK.

Redirecting Tablespaces Containers to a New Location

Use the following steps to redirect tablespace containers to a new location:

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <BackupSet>, 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 Recover Database tab of the Restore Options dialog box, click Advanced.
  6. On the Restore Arguments tab of the Restore Options dialog box:
    1. Select the backup images from the Available Images.
    2. Click Advanced.
  7. On the Redirect tab of the Advanced Restore Options dialog box:
    1. To change the destination tablespaces/containers of non-automatic storage database, select the Redirect Table Space Containers check box.
    2. Select the required tables to redirect from the Table Space box.  The associated container name is displayed in the Container Name box.
    3. Click OK.
  8. Click OK.

Modifying the Destination Storage Paths

You will be able to change the destination storage paths of an automatic storage database. The existing storage paths as defined within the backup image are no longer used. All the automatic storage databases will be automatically redirected to the newly defined paths.

Use the following steps to change the storage paths for automatic storage database:

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <BackupSet>, 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 Recover Database tab of the Restore Options dialog box:
    1. Clear the Recover DB check box.
  6. On the Restore Arguments tab of the Restore Options dialog box:
    1.  Select the backup images that includes the automatic storage databases from the Available Images.
    2. Click Advanced.
  7. On the Storage Path tab of the Advanced Restore Options dialog box:
    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.
    3. Click OK.
  8. Click OK.

The automatic storage databases will be automatically redirected to these newly defined paths

Restoring Logs

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

When the SnapProtect software start an SnapProtect operation, it quiesces the database. The database remains in that state until the SnapProtect operation completes. To prevent the operation from causing the database to be in the quiesced state, the SnapProtect software waits 2 minutes for the SnapProtect operation to complete. 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 SnapProtect Software Waits for the SnapProtect Operation.

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 <BackupSet>, 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 General tab of the Restore Options dialog box:
    1. Select  the Use Snap Restore checkbox.
    2. Click Advanced.
  6. On the Log Files tab of the Advanced Restore Options dialog box:
    1. Select the All Log Files option.
    2. Click OK.
  7. 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 <BackupSet>, 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 General tab of the Restore Options dialog box:
    1. Select  the Use Snap Restore checkbox.
    2. Click Advanced.
  6. On the Log Files tab of the Advanced Restore Options dialog box:
    1. Select the By Point-In-Time option.
    2. Select the Start and End check boxes to specify the point in time (date and time) for restoring the log files.
    3. Click OK.
  7. 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 <BackupSet>, 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 General tab of the Restore Options dialog box:
    1. Select  the Use Snap Restore checkbox.
    2. Click Advanced.
  6. On the Log Files tab of the Advanced Restore Options dialog box:
    1. Select the By Log Serial Number option.
    2. 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.
    3. Click OK.
  7. 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. If you are trying to recover the database using the backup image, you will not be able to reapply the logs for restore.

Before reapplying the logs (roll-forward) on the restored database, you must enable the userexit database configuration parameter to perform log archiving.

Whenever the log files are restored with 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.

When the SnapProtect software start an SnapProtect operation, it quiesces the database. The database remains in that state until the SnapProtect operation completes. To prevent the operation from causing the database to be in the quiesced state, the SnapProtect software waits 2 minutes for the SnapProtect operation to complete. 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 SnapProtect Software Waits for the SnapProtect Operation.

Use the following steps to recover the database by reapplying the logs:

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <BackupSet>, 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 General tab of the Restore Options dialog box:
    1. Select  the Use Snap Restore check box.
    2. Click Advanced.
  6. On the Roll-Forward tab of the Advanced Restore Options dialog box:
    1. Select the Roll-forward check box.
    2. Select the To the End of the logs option to reapply all of the logs.
    3. Click OK.
  7. Click OK.

To an Alternative Log Path

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

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <BackupSet>, 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 General tab of the Restore Options dialog box:
    1. Select  the Use Snap Restore check box.
    2. Click Advanced.
  6. On the Roll-Forward tab of the Advanced Restore Options dialog box:
    1. Select the Roll-forward check box.
    2. Select the Alternate Log Path check box, and then click Browse to select an alternative location within the DB2 directory for the log files.
    3. Click OK.
  7. Click OK.

To an Overflow Directory

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 <BackupSet>, 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 General tab of the Restore Options dialog box:
    1. Select  the Use Snap Restore check box.
    2. Click Advanced.
  6. On the Roll-Forward tab of the Advanced Restore Options dialog box:
    1. Select the Roll-forward check box.
    2. Select the To the End of the logs option.
    3. Click Browse to select the Overflow Directory.
    4. Click OK.
  7. 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 <BackupSet>, 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 General tab of the Restore Options dialog box:
    1. Select  the Use Snap Restore check box.
    2. Click Advanced.
  6. On the Roll-Forward tab of the Advanced Restore Options dialog box:
    1. Select the Leave in Roll-forward Pending State check box to leave the database in a roll-forward pending state.
    2. Click OK.
  7. Click OK.

Restoring Data from a Backup Copy

You can perform a restore from the backup copy by setting the appropriate copy precedence number.

When the SnapProtect software start an SnapProtect operation, it quiesces the database. The database remains in that state until the SnapProtect operation completes. To prevent the operation from causing the database to be in the quiesced state, the SnapProtect software waits 2 minutes for the SnapProtect operation to complete. 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 SnapProtect Software Waits for the SnapProtect Operation.

  1. From the CommCell Browser, navigate to Client Computers | <SourceClient> | DB2 | <Instance>.
  2. Right-click the <BackupSet>, 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 General tab of the Restore Options dialog box:
    1. Select  the Use Snap Restore check box.
    2. Click Advanced.
  6. On the Copy Precedence tab of the Advanced Restore Options dialog box:
    1. Select the Restore from Copy Precedence check box.
    2. In the Copy Precedence box, type the copy precedence number for the backup copy.
    3. Click OK.
  7. 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
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 | <Instance>.
  2. Right-click the <BackupSet>, point to All Tasks and then click Browse and Restore.
  3. Click View Content.
  4. From the Browse window, select the data you want to restore in the right pane and click Recover All Selected.
  1. 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.
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 | <Instance>.
  2. Right-click the <BackupSet>, point to All Tasks and then click Browse and Restore.
  3. Click View Content.
  4. From the Browse window, select the data you want to restore in the right pane and click Recover All Selected.
  5. 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.
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 | <Instance>.
  2. Right-click the <BackupSet>, point to All Tasks and then click Browse and Restore.
  3. Click View Content.
  4. From the Browse window, select the data you want to restore in the right pane and click Recover All Selected.
  1. 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 | <Instance>.
  2. Right-click the <BackupSet>, point to All Tasks and then click Browse and Restore.
  3. Click View Content.
  4. From the Browse window, select the data you want to restore in the right pane and click Recover All Selected.
  1. 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 | <Instance>.
  2. Right-click the <BackupSet>, point to All Tasks and then click Browse and Restore.
  3. Click View Content.
  4. From the Browse window, select the data you want to restore in the right pane and click Recover All Selected.
  1. 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.