Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Question on db2 luw architecture configuration

Status
Not open for further replies.

SnowCrash7

Programmer
Jun 10, 2001
6
US
Running DB2 9.7 LUW on AIX and Red Hat Linux.

I am asking for thoughts on architecting this environment going forward.
Most of my background has been with huge OLTP and EDW databases with mostly a 1 or 2 databases to one instance configuration.
So this is very different for me.

Taking a new job I inherited the following:

Dev - 1 server 9 instances with a total of 32 databases
QA - 1 server 9 instances with a total of 25 databases
Prod - 1 server 9 instances with a total of 23 databases

Thats 27 instances with a total of 90 databases

Most of these databases, except one in each environment, are small metadata databases with backup in seconds and minutes.

I am supposed to reduce the number of (virtual) servers we use. Reconfiguring the number of instances and databases per instance is fine.

Would you consider putting all 90 databases on one server? Ok stupid question but as I said, this type of configuration is totally alien to me.

Thanks


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top