467,907 Members | 1,097 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,907 developers. It's quick & easy.

Relocate DB2 databases part 2

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
  • viewed: 1441
Share:
1 Reply
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

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by wimmie | last post: by
3 posts views Thread by mike.cutts | last post: by
49 posts views Thread by Mike MacSween | last post: by
3 posts views Thread by Frank | last post: by
6 posts views Thread by Alfred | last post: by
8 posts views Thread by situ | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.