Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Question on db2 luw architecture configuration

Question on db2 luw architecture configuration

Question on db2 luw architecture configuration

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.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close