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.
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.
