Followers

Wednesday, March 6, 2013

Restore DB instance

Commands used  to restore WCD2 to WCD1 for a new DB2 instance

  • ​​​db2 restore database WCD2 from /db2backup/WCD1/backup on /db2/WCD1 into WCD1   

(or)
db2 restore db wcd2 from /db2backup/WCD1/backup on /db2/WCD1 into WCD1 logtarget /tmp     

  • db2 rollforward db wcd1 to end of logs and stop overflow log path (/tmp) noretrieve

No comments:

Post a Comment