Relocating the Instance Home Directory

You may also like...

8 Responses

  1. Toben Nelson says:

    Mike, fantastic shortcut method that I literally just employed due to being in the same boat because of a prior consultant’s bad installation. The onsite DB2 DBA, whom I have a lot of respect for, had cobbled together a Rube Goldberg type of solution using dbrelocatedb, rsync, db2move and some fairy dust. I showed her your solution and it worked like a charm and mgmt said they would be sending you a case of their finest malt beverage. Hope iDUG is great this year, and keep up the great postings.

    • mkrafick says:

      And that, ladies and gentlemen, is why I like to blog. You made me smile ear to ear. If I can make someone else not go through the same pain I did – all the better.

      It’s funny, at IDUG, I was asked by some IBM’ers why Id idn’t use relocatedb. In short I didn’t see anyone successfully use it for this purpose. It was either not successful or it became another Rube Goldberg.

      Thank you for the feedback!

  2. Mike – Great post.. Few months ago, I tried few options to change (relocate) the home directory of an instance owner ID but I was not able to do it. I even opened a PMR with IBM and it did not go too far. That one was on AIX 7.1. I will try giving a shot as you suggested. Thank you.

  3. Mark Hopkins says:

    Not sure why IBM (or anyone else) would not “bless” this procedure; it’s all DB2 commands. For me this does not give what I need, as the database data does not move with the instance. I am looking to COMPLETELY move an instance so that I can remove the old location. Of course IBM says yes it can be done using a redirected restore, but their steps do not work.

    • Ember Crooks says:

      The location of the instance is completely separate from the locations of all databases. Each database can be moved using either a redirected restore or db2move.

  1. June 10, 2014

    […] Mike’s blog posts include: 10 Minute Triage: Assessing Problems Quickly (Part I) 10 Minute Triage: Assessing Problems Quickly (Part II) Now, now you two play nice … DB2 and HACMP failover Technical Conference – It’s a skill builder, not a trip to Vegas. Why won’t you just die?! (Cleaning DB2 Process in Memory) Attack of the Blob: Blobs in a Transaction Processing Environment Automatic Storage Tablespaces (AST): Compare and Contrast to DMS DB2 v10.1 Column Masking Automatic Storage (AST) and DMS Reloacting the Instance Home Directory […]

  2. June 12, 2014

    […] Mike’s blog posts include: 10 Minute Triage: Assessing Problems Quickly (Part I) 10 Minute Triage: Assessing Problems Quickly (Part II) Now, now you two play nice … DB2 and HACMP failover Technical Conference – It’s a skill builder, not a trip to Vegas. Why won’t you just die?! (Cleaning DB2 Process in Memory) Attack of the Blob: Blobs in a Transaction Processing Environment Automatic Storage Tablespaces (AST): Compare and Contrast to DMS DB2 v10.1 Column Masking Automatic Storage (AST) and DMS Reloacting the Instance Home Directory […]

Leave a Reply

Your email address will not be published. Required fields are marked *