Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2009
    Posts
    4

    Unanswered: Move database and rename instance

    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.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    db2relocatedb is the command you want ...

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Dec 2009
    Posts
    4
    Quote Originally Posted by sathyaram_s View Post
    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

  4. #4
    Join Date
    Dec 2009
    Posts
    4
    I found this on the web it seems like a good read.

    The db2relocatedb tool

  5. #5
    Join Date
    Dec 2009
    Posts
    4
    oh sorry this is on a windows machine not sure if this makes any difference

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    This is the only document I refer to for this tool ..

    db2relocatedb features are the same in all supported platforms .. So you are good ..
    Last edited by sathyaram_s; 12-02-09 at 07:10.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •