DB2 restore over existing database

Requirement to restore a copy of a backup taken  from another DB2 instance and replace the existing one

 Steps:

1)Take a full backup of the database of INSTANCE 1

db2 force applications all

db2 backup database MYDB

Transfer the backup copy to a relevant path

db2 force applications all

db2 restore db MYDB from /mypath/backups TAKEN AT 20110128111333  INTO MYDB REPLACE EXISTING

 Source:Jack Vamvas

Leave a Reply

Discover more from ciquery

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

Continue reading