Connecting Tech Pros Worldwide Help | Site Map
 
 
LinkBack Thread Tools Search this Thread
  #1  
Old March 15th, 2006, 04:15 PM
Frank
Guest
 
Posts: n/a
Default 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





  #2  
Old March 16th, 2006, 04:45 PM
Raj
Guest
 
Posts: n/a
Default Re: Relocate DB2 databases part 2

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

 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 205,414 network members.