DB2 Backup


Backup the SAMPLE database while it is offline. The backup image will be created in your current directory.

[db2inst1@mercury adm]$ db2 backup db sample


Screenshot: Offline Backup

where — SAMPLE.0.db2inst1.NODE0000.CATN0000.20110524073459.001 is the backed up file

Online Backup :
To take Backup the SAMPLE database to the /database1 and /datababase2 directories while the database is still accessible by other users.


[db2inst1@mercury dbbackup]$ backup db sample online to /databasebkp1, /databasebkp2Where /databasebkp1, /databasebkp2 are directories where backup would be created


Screenshot: Online Backup

List recent backups and where they are stored

[db2inst1@mercury dbbackup]$ db2 list history backup all for sample

Screenshot: Backup History

Check the integrity of a backup image

[db2inst1@mercury dbbackup]$ db2ckbkp SAMPLE.0.db2inst1.NODE0000.CATN0000.20110524073459.001
where SAMPLE.0.db2inst1.NODE0000.CATN0000.20110524073459.001 is the backup file



Leave a Reply

Your email address will not be published. Required fields are marked *