Backup and DR Service for SAP IQ

SAP IQ, formerly Sybase IQ, is a family of relational database management systems within SAP Information Management division that is centered on several relational database management system offerings. This documentation explains how to protect SAP IQ application consistent database data with Backup and DR in a Linux environment.

Backup and DR uses these SAP IQ backup APIs:

  • File-based backups: SAP IQ dump database file-based backups API: This provides the 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.

  • Log backup: SAP IQ PITR log backup: During a PITR log backup, the SAP IQ API Backup database point in time recovery logs only to $TARGET_MOUNTPOINT command is used for log backup. OS-level commands are used for logs purging.

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

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.

How it works: SAP IQ with volume-based backup.

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.

How it works: SAP IQ with file-based backup.

What's next

Prepare the database for Backup and DR

Other documentation for Backup and DR for SAP IQ

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