Backup and DR Service for IBM Db2

Db2 is a is a family of relational database management systems within IBM's Information Management division that is centered on several relational database management system offerings. This section explains how to protect Db2 application consistent database data with Backup and DR in Linux environments.

The following are Db2 backup APIs used by Backup and DR:

  • Volume-level backup (Linux CBT and LVM snapshot): The db2 set write suspend for database and db2 set write resume for database API are used for freeze and thaw.

  • Standby (HADR) database: The Db2 database deactivate and Db2 database activate API are used for freeze and thaw.

  • Full+Incremental backup (file-based traditional): The db2 backup db online API (traditional dump backups) provide full and incremental backups of the database in backup format. On recovery the restore db API recovers the database by physically overwriting the data area.

  • Db2 log backup: Logs are flushed using Db2 archive log for database. During a log backup, the payload of the log segments is copied from the log area to the location specified by the parameter logarchmeth1.

How it works: Backup and DR volume-based backup with Linux CBT

Only changed blocks are tracked in the bitmap: no copy-on-writes, no I/O-intensive operations.

Data backup and recovery follows these steps:

  1. The Backup and DR agent has CBT to track changed blocks in the database data area.

  2. The agent calls the database API to freeze or pause database for data backup.

  3. Agent creates LVM snapshot of database data area and synthesizes a bitmap.

  4. Agent call to database API to unfreeze database.

  5. Agent copies changed blocks to backup/recovery appliance, which then deletes the snapshot and catalogs the backup.

  6. The appliance issues an internal snapshot and synthesizes a point-in-time virtual full backup.

  7. For data recovery, Backup and DR instantly mounts a rewritable staging disk and brings the database online.

Db2 with Backup and DR volume-based Backup with Linux CBT.

How it works: traditional file-based backup

Data backup and recovery with traditional file-based backup images follows these steps:

  1. Backup and DR agent is deployed in the database server.

  2. Mount staging disk on the database server.

  3. Invoke Full+Incremental backup using traditional dump backup command, writing the backup image to the mounted disk.

  4. Backup and DR takes an internal snapshot. Log backups are done in a similar fashion directly from the file-system at any desired schedule.

  5. For data recovery, Backup and DR instantly mounts the staging disk to the database server and initiates the database restore operation. Logs can be played to any point in time after the database is restored.

  6. For recovery, Backup and DR instantly mounts the staging disk to the database server and initiates the database restore operation. Logs can be played to any point in time after the database is restored.

Db2 with Backup and DR file-based full+incremental Backup.

What's next

Prepare the database for Backup and DR

Other documentation for Backup and DR for IBM Db2

This page is one in a series of pages specific to protecting and recovering IBM Db2 databases with Backup and DR. You can find additional information at: