Tag Archive | db2 backup

DB2 Backup

db2backup

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
db2backup1

List recent backups and where they are stored

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

Screenshot: Backup History
db2backup2

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