Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746

    Unanswered: move db to another instance

    Hi, I've got 1 instance serving 2 databases. (aix_5.3/db2_8.2 32bit). Memory management on a 32bit db2 on aix is ... let call it a challenge and one way to wring some extra memory to the bufferpools is to create an extra dedicated instance and move 1 of the databases to that other instance.
    I know it can be done and it should be simple. I know I've read about it in the past, but now I get google-hits pointing to other directions (sanjai never shared how he did it http://www.dbforums.com/db2/1630439-...-instance.html).
    Anyone got a nice link on how to accomplish such a task and are there any pitfalls I should avoid?

    Yes, I know but converting to v9 and/or 64bit is not an option right now
    Last edited by dr_te_z; 02-10-11 at 03:50.

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    You can allocate up to 2GB per database (db shared memory) in a 32-bit instance on AIX. It doesn't matter if 2 databases share one instance or are in separate instances.

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by BELLO4KA View Post
    You can allocate up to 2GB per database (db shared memory) in a 32-bit instance on AIX. It doesn't matter if 2 databases share one instance or are in separate instances.
    Are you sure it's as simple as that? Memory belongs to a process, not a database, and all databases in one instance are managed by the database manager process of that instance...

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    I remember the discussion we had before...
    http://www.dbforums.com/db2/1649813-...-errors-2.html


    I believe each db shared memory can be up to 2GB in a 32-bit instance on AIX.

  5. #5
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    There is more. It is all about a "db2 content manager" system wich uses the LS & RM databases (library server & resource manager). Because of the many connections I've enabled the connection concentrator. Fine for the LS, but not required for the RM. Another reason to split the 2.
    It is not clear documented but this featuere seems to have effect on db2-sort behaviour (same effect as INTRA_PARALLEL). Suddenly I must take the possibility of "shared sorts" into account . After the split I can ignore the shared-sort config for the RM db again.

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    If you want to move it to another instance, then you can use backup/restore or db2relocatedb:
    The db2relocatedb tool

  7. #7
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    I am writing my "plan of approch" now and I want to use the db2relocatedb tool. I wonder who should execute this command?
    - root?
    - the current instance owner?
    - the new instance owner?

  8. #8
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Quote Originally Posted by dr_te_z View Post
    I am writing my "plan of approch" now and I want to use the db2relocatedb tool. I wonder who should execute this command?
    - root?
    - the current instance owner?
    - the new instance owner?
    root copies/moves the files from the current location to the new location and changes ownership of the files to the new instance owner.

    the new instance owner runs the db2relocate command to change the configuration files

    HTH

    Sathyaram
    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
  •