Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2003

    Question Unanswered: Multiple instances of db2

    We are using db2 version 9.5 on windows nt server.
    So far only one instance (default) DB2 exists.
    Planning on starting another instance that will run in parallel with the current. The same java applications will use both the instances at the same time. The motivation behind this idea is to enable circular logging in one Database, and retain logs in the other. I know that this can be achieved by having two databases as well (instead of two instances). But there may be some performance tuning that we can apply differently in these two instances. So we've to decide whether to go with two instances or with two databases.

    How does running multiple instances on the same server affect performance etc? Any info on pros and cons or known problems of running multiple db2 instances would help me.

    Last edited by preetim; 08-24-09 at 15:23.

  2. #2
    Join Date
    Jan 2009
    Zoetermeer, Holland
    I prefer 1:1 relationship between instances & databases. So each database has its dedicated instance. It is more easy to manage & to monitor. You know exactly which database goes down when you issue a db2stop and which database is monitored with - DB2 Monitor. With v9 stmm can manage various databases in 1 server in more instances. No problem.

  3. #3
    Join Date
    Aug 2004
    just do it
    I am a java and database developer.

  4. #4
    Join Date
    May 2003
    Each intance requires memory for the DB2 code and some misc memory heaps, but if you have enough memory it should be no problem.
    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