NetVault Backup DB2 Plugin Primer on Implementation and Use

NetVault Backup’s plugin for DB2 provides DB2 Administrators with the ability to backup and recover/restore DB2 databases with confidence. Through an intuitive GUI user interface, our plugin offers a centralized console to set up, configure and define backup/restore jobs/policies for all your DB2 databases. Support for both online and offline backups give Administrators the flexibility to select their preferred backup method. The NetVault Backup DB2 plugin allows you to restore complete databases, individual table spaces or individual log files quickly and reliably. Because of NetVault Backups integration with a wide range of backup devices, you can be confident that DB2 data is protected and safely stored, meeting your backup needs.

 

Features …

 

  • Online and Offline backup modes
  • Full, Incremental, and Delta Backups
  • Protection down to table space level
  • Restore compete databases, individual archived logs, individual table spaces New in 3.1!
  • Recover point-in-time (PIT) or last backup
  • Point-and-Click GUI
  • Job scheduling
  • Rename and relocate databases during restore New in 3.1!
  • Restore databases to an alternate server
  • Parallellism backup jobs are split to allow multiple streams to backup at once New in 3.1!

 

Installation …

 

Install

  1. Start the NVBU Console on your NVBU Server. Click on Client Management.
  2. In the left selection pane, right-click the NVBU Client running DB2 and select Install Software.
  3. In the browse window, navigate to the location of the .npk installation file for the DB2 plugin.
  4. Select the file named db2-x-x-x-x.npk.
  5. Click Open to begin the installation process.
  6. On completion, a message will be displayed. Click OK to close this.

 

NVBU Configuration

  1. Open the NVBU Backup window.
  2. On the Selections tab, open the NVBU Server.
  3. Right-click DB2 and select Configure.
  4. Configure the following parameter:
    • DB2 Installation Directory – This field contains the default installation directory for DB2.

5. Open the NVBU Backup window on the NVBU Server.

6. On the Selections tab, open the NVBU Client on which the plug-in is installed.

7. Double click on the DB2 plugin to display available DB2 instances.

8. Right-click the applicable instance and select Set Default Login.

    • Default Account Name – Enter the account name for the DB2 Administrator.
    • Default Password – Enter the password for the configured user account.
    • Use Default Login – Select this check box to automatically connect NVBU to the database.

9. Click OK to close the window.

 

DB2 Configuration

  • Circular Logging, is the default behavior for any new DB2 database but it only allows the NVBU DB2 plugin to perform Full and Offline Backups. To do Online Backups the database must be configured for Archive Logging.
  • The DB2 TRACKMOD configuration parameter must be set to YES or the NVBU DB2 plugin will not be able to perform Incremental and/or Delta Backups.

 

NVBU DB2 plugin Backup Concepts …

 

The NVBU plugin for DB2 supports the following backup types:

 

  • Full Backup – A Full Backup includes all the data in the defined database. It serves as the base for the subsequent Incremental and Delta Backups.
  • Delta Backup – Specifies a non-cumulative (Delta) backup image. A delta backup image is a copy of all database data that has changed since the most recent successful backup operation of any type.
  • Incremental Backup – Specifies a cumulative (incremental) backup image. An incremental backup image is a copy of all database data that has changed since the most recent successful full backup operation.

 

A well-designed backup strategy allows Administrators to recover from a failure and resume normal operations as quickly as possible. The examples below offer general guidelines on how the NVBU DB2 plugin achieves this.

 

Full Backups Only – Data protection up to the previous day, performing Full Backups on a daily basis should be sufficient. In the event of a failure, the DB2 plugin will only require Administrators to restore a single backup job.

 

Full Backup + Archived Logs Backup – Data protection up to the current time, but recovery time is not important, Full Backup + Archived Logs Backup should provide the necessary protection. For example, Full Backups can be performed every Sunday, while backups of Archived Logs can be performed Monday through Saturday. This strategy will require the DB2 plugin to restore and apply each Archived Logs Backup between the last Full Backup and the point-of-failure in succession. This can lead to longer recovery as the week progresses. To speed up restores, you can include Incremental or Delta Backups, which will reduce the number of Archived Logs Backup that must be restored.

 

Full Backup + Incremental Backup + Archived Logs Backup – Data protection up to the current time and recovery time needs to be as fast as possible, Full Backup + Incremental Backup + Archived Logs Backup provides the best combination. For example, Full Backups can be performed every Sunday, while Incremental Backups can be performed Monday through Saturday and backups of Archived Logs can be performed every five to six hours. Each Incremental Backup will include all changes since the last Full Backup and the Archived Logs Backup will include the transaction logs since the last Incremental Backup. This strategy leads to quick recovery because the DB2 plugin only has to restore the Full Backup, the last Incremental Backup and the backups of Archived Logs created between the last Incremental Backup and the point-of-failure.

 

Full Backup + Delta Backup + Archived Logs Backup – Data protection up to the current time and backups have to be as fast as possible, Full Backup + Delta Backup + Archived Logs Backup is an ideal strategy. For example, Full Backups can be performed every Sunday, while Delta Backups can be performed Monday through Saturday and backups of Archived Logs Backups can be performed every five to six hours. Each Delta backup will include all the changes since the last Full or Delta Backup, and the Archived Log Backup will include the transaction logs since the last Delta Backup. This strategy can lead to longer recovery because the DB2 plugin must restore the Full Backup, each Delta Backup since the Full Backup and the backups of Archived Logs created between the last Delta Backup and the point-of failure.

 

Implementation …

 

Selecting DB2 data to be backed up:

  1. Open the NVBU Backup window on the NVBU Server.
  2. On the Selections tab Double click the NVBU client with the DB2 plugin installed.
  3. Double click on the DB2 Plug-in to display the added DB2 instances.
  4. Double click on the target DB2 database instance.
  5. When the instance opens, select the items that you want to back up:
    • Full Database Backup – Select the database node.
    • Table space Backup – To back up all table spaces, open the database node, and select the Tablespaces node.
    • To back up individual table spaces, open the Tablespaces node and select one or more table spaces.
    • Archived Logs – To back up the Archived Logs, select the Archived Logs node. Archived logs are required for a roll-forward recovery and must be backed up regularly. You can back up the archived logs separately or together with the table spaces. The DB2 plugin provides the option to delete archived logs from disk after backing them up.

6. To implement a backup strategy that includes Incremental or Delta Backup strategy, save the selected data into a Selection Set.

 

 

Selecting backup options

  1. Click the Backup Options tab, and configure the following options:

a. Backup Mode – Under Backup Mode, select one of the following options:

    • Online
    • Offline

b. Backup Type – Under Backup Type, select one of the following options:

    • Full
    • Incremental
    • Delta

 

 

  1. Define the Number of Sessions – This parameter determines the number of table spaces that will be backed up in parallel. Each session is assigned one table space at a time until all table spaces are backed up.
  2. Purge Logs – Under Purge Logs, configure the following parameters:
    • Purge Archived Logs – To remove the archived logs automatically after they are backed up, select this check box. The DB2 plugin will delete all archived logs except the Active Logs. It will also not delete the number of logs specified in the Logs to Keep Before Active Log option.
    • Logs to Keep Before Active Log Option – This option can be used with the Purge Archived Logs option to specify the number of logs preceding the current active database log in the server that should not be purged.

 

To Finalize and Submit a backup job

  1. Click the Schedule, Target and Advanced Options tabs and configure the required options.
  2. In Job Title, enter a suitable title for the job.
  3. Click Submit on the toolbar.
Anonymous