Pages

Wednesday, December 7, 2011

DB2 Backup and Restore


--- Taking backup
Stop MXServer from was console
su - db2inst2
db2 force application all
db2 backup database maxdb72 to /db2_data1/backup133 compress

--Restoring backup

db2 restore database maxdb72 FROM /db2_data1/backup133 taken at 20110331234149 into maxdb72 replace existing

db2 rollforward db sample to end of logs and complete

db2 Infocenter

In windows case use below


db2 restore database maxdb72 user <username> using <password> from D:\ibm on D:\ibm

No comments:

Post a Comment