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

Configuration Advisor, Several Instances

P: n/a
Hello Friends;
I have a general question on Configuration Advisor, as I get to know it
better I may have more focused questions. I have a feeling that the
Advisor may assume that there is only one instance on a server. I have
a situation where I have many instances on one server, with many small
databases, about 20 instances with about 45 databases. Sounds great so
far doesn't it? Anyway my question at this point is when trying to
utilize Configuration Advisor for tuning a database in regard to the
physical memory, it sets the target memory at 80%. My question is,
since I have many instances and databases is there some sort of formula
I should be using to calculate what I should be allocating to the
target memory bar? Any suggested reference material that addresses
this would be appreciated. For information sake I am working with DB2
UDB 8.1 on a RedHat 7.2 Intel based environment. Currently in the
process of moving all this to a DB2 UDB 8.2 on Suse 9 Intel based
environment. Thanks.
Claude

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.