DB2 – check backup command and contents of a database

 

DB2 – check backup command and contents of a database

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

Author: Jack Vamvas

Leave a Reply

Discover more from ciquery

Subscribe now to keep reading and get access to the full archive.

Continue reading