DB2 Backup and Restore Commands

IBM DB2 UDB for Linux, Unix and Windows Command Examples


Take an OFFLINE backup 

db2 connect to <dbname>

db2 quiesce database immediate force connections

db2 connect reset

db2 backup database <dbname> to <path> compress without prompting

after backup completes:

db2 connect to <dbname>

db2 unquiesce database

db2 connect reset

Take an ONLINE Backup

db2 backup db <dbname> to <path> online compress

or use a background process on a linux/unix machine

nohup db2 backup db <dbname> to <path> online compress &

List recent backups and where they are stored

=>db2 list history backup all for <dbname>

Check the integrity of a backup image

=>db2ckbkp <image name>

Restore from Incremental Backup Automatic

=>db2 restore db <dbname> incremental automatic taken at <timestamp>

If you need to restore an incremental backup manually this command will give you the required previous backups.

=>db2ckrst -d <dbname> -t <timestamp of image>