Performing a DB2 Differential or Delta Backup

Updated

A DB2 differential/delta backup contains only data that is new or has changed since the last backup (full, incremental, or delta), regardless of the type. On average, DB2 differential/delta backups consume less media and use less resources than full backups.

If you want to have a differential backup that only contains the data, create a subclient for data only backups.

When the DB2 TRACKMOD parameter is set to ON and you add a new tablespace to the database, DB2 generates a SQL2426N error when you perform a delta or an incremental backup. To avoid the error, the Commvault software automatically converts the backup to a full backup when it detects that you added a new tablespace.

Procedure

  1. From the CommCell Browser, expand Client Computers > client> DB2 >instance > backup_set.

  2. Right-click the subclient and click Backup.

  3. On the Backup Options for Subclient dialog box, select the backup type and job initiation:

    1. In the Backup Type section, select Differential/Delta/Data Only.

    2. In the Job Initiation section, specify whether to run the backup now or if it will be scheduled.

      Note

      If you selected Schedule, set up the schedule.

      For information about configuring a backup schedule, see Schedule Backups.

  4. Click OK to close the Backup Options dialog box.

Was this page helpful?