Backup, restore, and disaster recovery

It is recommended that you regularly back up the data in your databases. Only a database administrator can perform backup and restore operations.

Configuring IBM Spectrum Protect
Before you can back up or restore IBM® Db2 Warehouse by using IBM Spectrum Protect server, you must configure IBM Spectrum Protect client on Db2 Warehouse. IBM Spectrum Protect was formerly known as IBM Tivoli Storage Manager.
Backing up and restoring a database, schema, or table
You can use the db_backup and db_restore commands to perform different types of backups in your database.
Disaster recovery
Disaster recovery might be required in cases where your data center becomes disabled due to such events as equipment failures, malicious cyberattacks, or even natural disasters. Disaster recovery for Db2 Warehouse involves restoring from the most recent backup.
Snapshot backup and restore on IBM Db2 Warehouse
Snapshot backups have significant advantages over traditional backups. They are completed quickly, regardless of database size, and they allow for fast recovery. Also, snapshots don’t impact many database operations, except momentarily pausing operations that perform writes.

Parent topic: Administering IBM Db2 Warehouse