Db2 (On Premises and Cloud)

Expand all | Collapse all

DB2 HADR

  • 1.  DB2 HADR

    Posted 8 days ago
    Hi,
    When implementing HADR with VIP is it necessary to have two NIC's? If we can configure using one NIC, are there any other drawback other than failure of the one adapter such as DB performance?

    ------------------------------
    Steven Drogoszewski
    ------------------------------


  • 2.  RE: DB2 HADR

    Posted 4 days ago
    Hi Steven,
    In my experience sharing the one pair of NICs is usually sufficient. An exception to this would be when you are managing HADR using TSA where the second pair of NICs can help maintain quorum in the cluster especially if the NICs are communicating across different network routes. 
    Cheers

    ------------------------------
    Colin Chapman
    ------------------------------



  • 3.  RE: DB2 HADR

    Posted 2 days ago
    Hi

    Use two NICs can be also useful to isolate the workload, e.g. in the 1st pair (public) you work with the application workload and in the 2nd pair (private) you work with HADR workload. The VIP will be part of the public pair naturally. And remember that HADR is a solution by database and not by instance. This is the default behavior when you use the db2haicu to configure the cluster.

    Hope this helped.

    Cheers,
    Skeff

    ------------------------------
    Daniel Skeff
    ------------------------------



  • 4.  RE: DB2 HADR

    Posted 2 days ago
    We  will be implementing with two NIC's.
    We are following recommendations provided in this document:
    Db2 (On Premises and Cloud)



    Thank you for the response.




    ------------------------------
    Steven Drogoszewski
    ------------------------------