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> online to <path> compress
or use a background process on a linux/unix machine
nohup db2 backup db <dbname>online to <path> 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 delta 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>
No comments:
Post a Comment