 | ||
| About using Veritas NetBackup for backup and restore for DB2 | ||
|---|---|---|
| Prev | Backing up and restoring with Netbackup in an SFHA environment | Next |
| ||
| About using Veritas NetBackup for backup and restore for DB2 | ||
|---|---|---|
| Prev | Backing up and restoring with Netbackup in an SFHA environment | Next |
With Veritas NetBackup, you can perform high performance, online (hot) backups of databases that must be available on a 24x7 basis. NetBackup supports the Extended Edition (EE) and the Enterprise Extended Edition (EEE) environments. NetBackup also supports Database Partitioning Feature (DPF) for DB2 8.1 and higher.
Veritas NetBackup enables you to back up and restore database files and directories. You can set up schedules for automatic, unattended database backup, as well as full or incremental backup. These backups are managed entirely by the NetBackup server. You can also manually back up database files from any of the NetBackup clients. Client users can perform database backups and restores from their client systems on demand.
Veritas NetBackup can be configured for DB2 in an Extended Edition (EE), Extended-Enterprise Edition (EEE), or Database Partitioning Feature (DPF) environment. Two types of DB2 backup policies are required. One is used to backup the catalog nodes and the other is used to backup all the nodes, including the catalog node. Detailed information and instructions on configuring DB2 for EEE is available in the system administrator's guide.
See the Veritas NetBackup for DB2 System Administrator's Guide for UNIX.
Veritas NetBackup for DB2 has the following features:
Media and device management
Scheduling facilities
Multiplexed backups and restores
Transparent execution of both DB2 and regular file system backup and restore operations
Shared devices and tapes used during other file backups
Centralized and networked backup operations
Parallel backup and restore operations
Incremental backups of DB2 databases
Table: Options for backing up DB2 with NetBackup
Automatically |
Manually |
DB2 BACKUP DATABASE command |
|
|---|---|---|---|
|
DB2 database log backups |
Supported |
Supported |
Supported |
|
DB2 archive log backups |
Supported |
Supported |
Supported |
|
DB2 policy backups |
Supported |
Supported |
Setting up schedules for automatic backups is the most convenient way to back up your database.
See 'Performing a Backup' in the Veritas NetBackup for DB2 System Administrator's Guide for UNIX.
The procedure for restoring a DB2 database depends on the database involved and the problems that you have on your system. You can browse the backups using the db2 list history command or using the NetBackup bplist command before restoring.
See the DB2 UDB Administration Guide Data Recovery and High Availability Guide.