What is the overhead or multiple db2 instances on the same sever/processor?
Posted on 2008-10-17
With Oracle, SQL Server, MySQL and most other DBMS, I typically encounterone, maybe two instances (if the server is beefy) running on a single server. I've occasionally seen 3 or 4 in non-production environments for testing and qa.
Is DB2 any different? Can someone (estimate or at least explain how to guess) the extra overhead associated with six instances with six databases rather than one instance with six databases? For the sake of context, assume AIX/POWER architecure, 8gb ram with data stores of 200gb each, 20 concurent users each with moderatly complex queries.
Thanks in advance