DB2

You can use the Commvault software to back up and restore DB2 databases.

Backups

Data You Can Back Up

• Individual databases

• Table spaces

• Logs

Data You Cannot Back Up

You can use a file server to back up the following content, which is not included in the backup data of DB2 databases:

• Operating system data

• DB2 application files

Backups You Can Perform

• Full backups

• Full backups, using IntelliSnap

• Incremental backups

• Differential backups

• Transaction log backups

When You Can Perform Backups

• On a schedule: The server plan that you assign manages scheduled backups

• On demand: You can perform on-demand backups at any time

Restores

Restores You Can Perform

• DB2 system databases

• DB2 user databases

• DB2 databases (data and logs)

Backups You Can Use for Restores

• The most recent backup: For example, restore the most recent backup to its original location

• A backup from a specific date: For example, restore data to a point in time before it became unusable

• Backups from a date range: For example, restore data that was accidentally deleted

Destinations You Can Restore To

• The current location (in place)

  • Restore data to the same client and the same location on the client from which it was backed up.

• A different location (out of place)

  • A different client from which the database was backed up

  • A different path on the same client from which the database was backed up

  • A different database on the same client from which the database was backed up

  • A different instance on the same client from which the database was backed up