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.
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.
9. Click OK to close the window.
NVBU DB2 plugin Backup Concepts …
The NVBU plugin for DB2 supports the following backup types:
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.
Selecting DB2 data to be backed 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
a. Backup Mode – Under Backup Mode, select one of the following options:
b. Backup Type – Under Backup Type, select one of the following options:
To Finalize and Submit a backup job