Restore from 6 node to 8 node database...

awesomeness · #1 (**permalink**) 09-28-11, 16:46

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

Marcus_A · #2 (**permalink**) 09-28-11, 21:54

I don't believe so. You can create a 6-node partition group and do restore, and then add new partitions, and then rebalance.

awesomeness · #3 (**permalink**) 09-29-11, 06:41

Thanks Marcus, That is what I thought. I guess it was wishful thinking from my part.

awesomeness · #4 (**permalink**) 09-29-11, 11:16

So how would you guys do this, what is the simplest to accomplish this?

db2girl · #5 (**permalink**) 09-29-11, 17:41

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