Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2011
    Posts
    3

    Unanswered: Restore from 6 node to 8 node database...

    Is there a way in DB2 9.7 UDB to restore from a 6 node multipartition backup into a new 8 node multipartition database?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I don't believe so. You can create a 6-node partition group and do restore, and then add new partitions, and then rebalance.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Sep 2011
    Posts
    3
    Thanks Marcus, That is what I thought. I guess it was wishful thinking from my part.

  4. #4
    Join Date
    Sep 2011
    Posts
    3
    So how would you guys do this, what is the simplest to accomplish this?

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    As Marcus mentioned, restore into a 6-node and then add new partitions/redistribute. You can find an example here
    IBM DB2 9.5 Information Center for Linux, UNIX, and Windows

Posting Permissions

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