Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only

Db2 Warehouse / IIAS auto client failover/reroute

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

    Posted 07/03/19 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
    ------------------------------

    #Db2