Topic Thread

Db2 Warehouse / IIAS auto client failover/reroute

  • 1.  Db2 Warehouse / IIAS auto client failover/reroute

    Posted Wed July 03, 2019 05:37 AM
    Hi,

    Can someone clarify how Db2 Warehose (on Premise) manages client connections in case of node failover? As per documentation, it seems if we dont use HAProxy load balancer for IBM Db2 Warehouse between DB2WH and client, Db2 warehouse cannot reroute and restart client connections automatically to new head node because there is no service/vip address like in similar systems?

    Also, how this works in IIAS?

    Tnx,
    Ivan

    ------------------------------
    Ivan Milojevic
    Comtrade System Integration
    Belgrade
    ------------------------------