Hi All,

I'm new here and I hope to be able to help people here so hello

I have installed db2 v9.5 and have created 1 instance with two databases but now I would like to move one of the databases to a new instance so they are independent.

Then I would like to rename the first instance to tidy things up.

Is this something that can be done and if so whats the best way ?

Current setup

Instance name = fred and database1 name = bob & database2 name = Jack

I would like to have

New setup
Instance1 name = fred with database1 name = bob
&
Instance2 name = jack with database2 name = Jack

Thank you for your help.

db2relocatedb is the command you want ...

Cheers
Sathyaram

Thanks Sathyaram... do you have a dummy's guide for this ? is this command all I need ? are there any other steps to complete this ?

thanks for your quick reply

I found this on the web it seems like a good read.

The db2relocatedb tool

oh sorry this is on a windows machine not sure if this makes any difference

This is the only document I refer to for this tool ..

db2relocatedb features are the same in all supported platforms .. So you are good ..