By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,924 Members | 1,686 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,924 IT Pros & Developers. It's quick & easy.

Mixing single partition and multi partition databases in the same instance

P: n/a
Have you seen any significant performance issues mixing single
partition and multi partition databases in the same instance. If so
could you please share your experience on this.

Thanks,
Sam.

Feb 19 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Ian
Sam Durai wrote:
Have you seen any significant performance issues mixing single
partition and multi partition databases in the same instance. If so
could you please share your experience on this.
You can't. An instance is either partitioned or it is not. All
databases within the instance are therefore partitioned or not.

With that said, you can create a database in a partitioned instance
and then alter the nodegroups (except for IBMTEMPGROUP) in that database
such that all data lives on 1 partition.

However, why you'd want to do this (as opposed to just creating a
second instance with only 1 partition) is beyond me.

Feb 26 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.