Relocate DB2 databases part 2

Frank

Hi, thanks already for your info in a previous post Ian, Dave and Gert.

What I understood from your answers (and believe me when I tell you I know
nothing about DB2) the best and easied way to move the databases is to
backup both databases, stop the database server (db2stop force), move (or
should I copy?) the entire folder c:\db2 to the d-drive and start the
database server (db2start).

Then goto the DB2 command line processor and issue the command
"db2relocatedb -f c:\temp\relocate.cfg".

The content of the relocate.cfg file should be:

DB_NAME=DATABASEA
DB_PATH=C:,D:

After running this command, issue the same command, but change the DB_NAME
to DATABASEB.

Am I correct?

Sorry for asking, but it is very important both databases will work like
before with everything in it, only on a d-drive and not on the c-drive.

Kind regards,

Frank

Mar 15 '06 #1

Raj

easiest way is to redirect restore

You can restore a DB2 backup and redirect it into another DB2 database
that is running under the same type of operating system. The DB2
command statements required to perform a redirected restore are:

One DB2 RESTORE DATABASE INTO command
One SET TABLESPACE CONTAINERS command for each table space in the
database
One DB2 RESTORE DATABASE CONTINUE command.

checkout this link
http://www-128.ibm.com/developerwork...2mulligan.html

Mar 16 '06 #2