Tips for Verifying Successful DB2 database backup

Successful backup is very important for DB2 users. How can we ensure that your backup is successful?

DB2 provides a very simple verification tool, db2ckbkp. A simple example: on AIX, we made a backup for a database named sample. The backup file name is SAMPLE.0.db2inst1. node).catn).20041123142456.001.

Below is the output of running db2ckbkp. if you see successful information, it indicates that the backup media is available and you can use this backup to recover it with confidence. however, please note that this command can only verify that the backup media on the disk exists, but not on the tape.

Db2ckbkp SAMPLE.0.db2inst1. node1_.catn0000.20041123142456.001

[1] Buffers processed :######

Image Verification Complete-successful

(