DB2 – check backup command and contents of a database

05 March,2012 by Jack Vamvas

Q.What are the contents of a DB backup ?

A. The items contained are dependant on the backup method , such as database or TABLESPACE

Use the backup utility : db2ckbkp  to interrogate the contents of a DB2 backup.  db2ckbkp checks integrity and displays meta information

 For example, if you use the –a   switch this will display all available meta information

       #The example used below  displays the table space details
      
        db2ckbkp -a MYDB.0.db2db2.NODE0000.CATN0000.20120305152355.001
    
      #  The following example displays the table space details 

      #db2ckbkp -t MYDB.0.db2db2.NODE0000.CATN0000.20120305152355.001
     

See Also

 

DB2 – Restore database from a ONLINE backup

 

Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on DB2 – check backup command and contents of a database

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright