Db2

Db2

Connect with Db2, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  Multiple DB2 HADR on same server

    Posted Mon November 10, 2025 10:01 AM

    Hi All,

    We have one instance with 2 databases install on single server.

    Now our plan is to create 2 hadr environment. We have 2 servers.

    2 HADR database on 1st server (primary) and corresponding standby's databases on 2nd server.

    Need recommendation, should we go with single instance or 2 instances (separate instance for each HADR database).



    ------------------------------
    masheed ullah
    ------------------------------


  • 2.  RE: Multiple DB2 HADR on same server

    Posted Mon November 10, 2025 12:54 PM

    HADR is a relation between databases - so unless you have way too big server - I would recommend single instance with 2 databases.



    ------------------------------
    Jan Nelken
    Db2 (LUW) DBA
    Open for work
    Katowice or Krakow
    +48 783 109 863
    ------------------------------



  • 3.  RE: Multiple DB2 HADR on same server

    Posted Tue November 11, 2025 03:01 AM

    Hi Masheed,

    I agree with Jan - I would also go with a single instance here, because that is easier to set up and maintain, but still gives you the freedom of failing over each of the Db2 databases independently.

    Unless you want to be able to upgrade one database environment to a newer Db2 level and keep the other one on the older level, in that case you will need two separate instances.

    Regards, Damir



    ------------------------------
    Damir Wilder
    Senior Consultant
    Triton Consulting
    London
    ------------------------------