SnapProtect - Advanced Backup - DB2

Table of Contents

Full Backups

Full backups provide the most comprehensive protection of data.

SnapProtect Backups for any client are full backups. You can perform a full backup of an online or offline database.

Note: If a subclient for DB2 SnapProtect backup contains both the data and logs, the log backup is initiated with a separate Job ID. During the data aging process, this may lead to pruning the data backup before a log backup if both the jobs are marked as FULL. Thus, the log backup would be marked as Incremental even though the entire set of logs available in SnapProtect log archive directory are backed up. The log backups are marked as incremental only to make the data and log backups as part of the same cycle.

Online Backups

You can perform a full backup of an online database.

Before You Begin

  1. Create an SnapProtect subclient for online backups.
  2. If this is your first SnapProtect backup, after you changed the LOGARCHMETH1 parameter value, perform a traditional offline backup.

Procedure

  1. From the CommCell Browser, navigate to Client Computers | <Client> | DB2 | <Instance> | <Backup Set>.
  2. Right-click the <Subclient> and click Backup.
  3. On the Backup Options dialog box, select Full as the Backup Type and Immediate as Job Initiation.
  4. Click OK.

    You can track the progress of the job from the Job Controller.  When the backup job has completed, the Job Controller displays Completed.

Offline Backups

You can perform a full backup of an offline database.

Before You Begin

  1. Create an SnapProtect subclient for offline backups.
  2. If this is your first SnapProtect backup, after you changed the LOGARCHMETH1 parameter value, perform a traditional offline backup.

Procedure

  1. From the CommCell Browser, navigate to Client Computers | <Client> | DB2 | <Instance> | <Backup Set>.
  2. Right-click the <Subclient> and click Backup.
  3. On the Backup Options dialog box, select Full as the Backup Type and Immediate as Job Initiation.
  4. Click OK.

You can track the progress of the job from the Job Controller.  When the backup job has completed, the Job Controller displays Completed.

Archive Log Backups

Configure an archive log subclient, or an online subclient with logs, or offline subclient with logs.

DB2 archive logs can be included in SnapProtect subclient that is using a traditional backup method.

Procedure

  1. From the CommCell Browser, navigate to Client Computers | <Client> | DB2 | <Instance> | <Backup Set>.
  2. Right-click the <Subclient> configured for the archive log and click Properties.
  3. On the Properties dialog box, click Advanced.
  4. On the Advanced Properties dialog, navigate to the Backup Archive Logs tab and select the All check box.
  5. Click OK.

Disabling Switch Current Log

When performing archive log backups, the current online log file is closed even if it is not full. The next online log file is written after a Log switch. The closed online log file is then archived during the log phase.

Use the following steps to disable the current log switch:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | DB2 | <Instance> | <Backup Set>.
  2. Right-click the <Subclient> and click Properties.
  3. On the Properties dialog box, navigate to the Content tab and clear the Backup Data check box.
  4. Navigate to the  Backup Arguments tab and select the Backup Log Files and Disable Switch Current Log check boxes.

Delete Log Files After

When performing archive log backups, delete the log files after a backup from the log and archive path, but keep the files on the backup media.

Use the following steps to delete the log files after a backup

  1. From the CommCell Browser, navigate to Client Computers | <Client> | DB2 | <Instance> | <Backup Set>.
  2. Right-click the <Subclient> and click Properties.
  3. On the Properties dialog box, navigate to the Content tab and clear the Backup Data check box.
  1. Navigate to the  Backup Arguments tab and select the Backup Log Files and Delete Log Files After check boxes.

NFS SnapProtect Backup for DB2

You can perform a SnapProtect backup for DB2 when the database is on a NFS Volume. However, you will require a root access in the storage device's NFS configuration to be able to read and write on the accessible DB2 files i.e., the host on which the NFS Volume is mounted.

Consider the following while performing an SnapProtect backup for data or databases that reside on an NFS Volume:

  • The export name on the storage device should be the same as the storage path on the storage device.

    E.g., if the storage path of the storage device is /vol/Volume/Qtree, use /vol/Volume/Qtree as the export name and not an alias such as /ExportName.

  • You can use the exports both at the root of a NetApp volume and at subdirectory levels below the root of the volume.
  • Make sure that the storage device is accessible from the source and proxy machine (even if they exist in different domains) using the storage device's short name while mounting NFS exports from the storage device. Make sure to enter the storage device credentials using its short name. Do not use an IP address or the fully qualified domain name.

    E.g., use a short name for the server such as server1 or server2.

Scheduling Backups

  1. From the CommCell Browser, navigate to Client Computers | <Client> | DB2 Instance | DB2 Backupset.
  2. Right-click the <Subclient> and click Backup.
  3. On the Backup Options for Subclient dialog box:
    • Select the Backup Type and set the Oracle Incremental Level and Cumulative check box as needed
    • Select the Job Initiation
    • To schedule a backup, click the Configure button.  This opens the Schedule Details dialog box, where you:
      • Enter the Schedule Name.
      • Select how often to run the backup (e.g. Weekly).
      • Select the Start Time.
      • Select the days to run the backup.
      • Select the Repeat options.
    • Click OK.

The backup job will execute as per the schedule.

Additional Options

The following table describes the available additional options to further refine your backup operations:

Option Description Related Topics
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> | < BackupSet> .
  1. Right-click the Subclient in the right pane and click Backup.
  2. Click Advanced and click Startup tab.
  3. Select the Change Priority checkbox.
  4. Enter a priority number - 0 is the highest priority and 999 is the lowest priority.
  5. Select the Start up in suspended State check box to start the job in a suspended state.
  6. Click OK.
Refer to Job Priority and Priority Precedence.
Alerts

This option enables users or user groups to get automatic notification on the status of the data protection 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>| <BackupSet>.
  1. Right-click the Subclient in the right pane and click Backup.
  2. Click Advanced and select the Alert tab.
  3. Click Add Alert.
  4. From the Add Alert Wizard dialog box, select the required threshold and notification criteria and click Next.
  5. Select the required notification types and click Next.
  6. Select the recipients and click Next.
  7. Click Finish.
  8. Click OK.
Refer to Alerts and Notifications.
Vault Tracker

This feature provides the facility to manage media that is removed from a library and stored in offsite locations. Depending on your Vault Tracker setup, select the required options. Use the following steps to access and select the Vault Tracker options.

  1. From the CommCell Browser, navigate to Client Computers | <Client> | DB2 | <Instance>| <BackupSet>.
  1. Right-click the Subclient in the right pane and click Backup.
  2. Click Advanced and select the Vault Tracking tab.
  3. Select the required options.
  4. Click OK.
Refer to Vault Tracker.
Extended Data Retention

This option allows you to extend the expiration date of a specific job. This will override the default retention set at the corresponding storage policy copy. Follow the steps given below to extend the expiration date:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | DB2 | <Instance>| <BackupSet>.
  1. Right-click the Subclient in the right pane and click Backup.
  2. Click Advanced and select the Media tab.
  3. Select one of the following options:
    • Infinite - Select this option to extend the expiration date by infinite number of days
    • Number of day - Select this option to specify the number of days to extend the expiration date and then enter the number of days.
  4. Click OK.
Refer to Extended Retention Rules.
Allow Other Schedules To Use Media Set

The Allow Other Schedules to use Media Set option allows jobs that are part of the schedule or schedule policy and using the specific storage policy to start a new media. It also prevents other jobs from writing to the same set of media.

  1. From the CommCell Browser, navigate to Client Computers | <Client> | DB2 | <Instance>| <BackupSet>.
  1. Right-click the Subclient in the right pane and click Backup.
  2. Click Advanced and select the Media tab.
  3. Select the Allow Other Schedules To Use Media Set check box.
  4. Click OK.
Refer to Creating an Exportable Media Set.
Mark Media Full

This option marks the media as full, two minutes after the successful completion of the data protection job. This option prevents another job from writing to this media. Follow the steps given below:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | DB2 | <Instance>| <BackupSet>.
  1. Right-click the Subclient in the right pane and click Backup.
  2. Click Advanced and select Media tab.
  3. Select the Mark Media Full on Success check box.
  4. Click OK.
Refer to Start New Media.
Start New Media

The Start New Media option enables you to start the data protection operation on a new media. This feature provides control over where the data physically resides. Use the following steps to start the data protection operation on a new media:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | DB2 | <Instance>| <BackupSet>.
  1. Right-click the Subclient in the right pane and click Backup.
  2. Click Advanced and select the Media tab.
  3. Select the Start New Media check box.
  4. Click OK.
Refer to Start New Media.
Data Path Options

Data Protection 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>| <BackupSet>.
  1. Right-click the Subclient in the right pane and click Backup.
  2. Click Advanced and select the Data Path tab.
  3. Select the MediaAgent and Library.
  4. Select the Drive Pool and Drive for tape library.
  5. Click OK.
Refer Change Data Path.
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.
Backup Job Summary Report The Backup Job Summary Report provides you with information about all of the backup jobs that are run in last 24 hours for a specific subclient. You can get information such as status, time, data size, and so on for each backup job. It is useful to run this report after performing the backup. 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 Management.
  5. Select the Computers tab.
  6. Select Subclient, and then select the Edit sub tab.
  7. Navigate to Client Computers | <Client> | File System | Backup Set | <Subclient>.
  8. Click Run.

    The report appears in your default Web browser.

Refer to Backup Job Summary Report.

Related Topics

Scheduling

Provides comprehensive information on scheduling jobs.

Job Management

Provides comprehensive information on managing jobs.