Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2008

    Unanswered: new db creation on existing instance

    There are already two instance on production server.
    As per requirement We want to create new database.
    So please tell me whats prons and cons if i create new db on existing instance.
    or what will be prons and cons if i create new instance and then create new db under that.

    Reply ASAP

    Thanks & Regards
    Pawan Kumar

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    Please provide OS and DB2 versions including fixpack level. You might also want to provide what the hardware (memory, CPUs, etc). All of this info is needed to allow us to give you the best possible answer.

    In general, a separate instance for the new DB requires more resources, memory, CPU, Disk, etc. than adding the new DB to an existing instance. The disadvantage of using an existing instance is that if the instance crashes, then both DBs are off-line instead of just one.


  3. #3
    Join Date
    Mar 2008
    DB2v8.1.2.89 with fixpack 9....
    12GB Memory

  4. #4
    Join Date
    May 2003
    The advantage of having multiple instances is that you start and stop DB2 at the instance level so this would give you more granular control of the databases. This is probably the most important factor (or non-factor depending on your applications).

    If you had both databases in one instance, you would be able save a little bit of instance level memory (but this a relatively small amount of memory).

    The number of allowed agents (in most cases one agent per connection) is controlled at the instance level.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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