Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    United States
    Provided Answers: 1

    Question Unanswered: DB2 Instances - Planning


    What is the best approach for deploying DB2 instance(s) for enterprise production environment.

    Options :

    One database per instance (easy to do upgrade and failovers, but more maintenance work on per instance basis)

    OR Is it ok to have muliple databases on an instance - this will reduce the number instance that I have to upgrade or maintain. But will affect more users if I have to bring down the instance for any maintenance purposes.

    Some of my databases are critical and some are not

    Some are metadata repository for the products like Informatica.

    Thanks for you help!

    - G's
    >> Learn PHP/MySQL for free
    >> Free Web Hosting with PHP, MySQL, Website Builder :

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    I think you should only have one instance per server. That way you maximize the server resources for the instance. Using multiple instances on the same server can cause serious issues, especially regarding how to allocate the server resources.


Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts