Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2003
    Posts
    121

    Unanswered: changing owner of an instance

    Anyone has done that before please help to follow the correct procedure to do that so it should not break anything.
    It will be greatly appreciated.

    TIA.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    I would create a new instance and then use db2relocatedb to move the database from one instance to another ..

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

  3. #3
    Join Date
    Nov 2003
    Posts
    121

    Isn't there any shorter way ?

    Thanks for prompt reply Sathyaram!

    Isn't there any other or shorter way as using db2relocate db needs a longer time to do and we do not have that bigger window to achieve that.

    We want to consider all the options.

    If you or anyone else have other options and if successfully done before please share your thoughts.

    Thanks in Advance again!

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Assuming you have enabled archival logging and have enough disk space ,
    a) Create new instance
    b) Online Backup database on old
    c) Restore database on new, but leave rollforward pending
    d) Apply logs from old to new continually, leaving the new in pending state
    e) Stop the old instance
    f) Get the latest logs and apply it on new, and rollforward complete

    If you wish the clients to access the database without any changes to their config, then change the SVCENAME of the new instance to same as old ...

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

  5. #5
    Join Date
    Nov 2003
    Posts
    121

    Thanks..

    This 'd be a great help.

    Anything without creating second instance ??

    Sorry .. just curious..

    TIA.

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    AFAIK, it is not possible
    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
  •