Db2

Db2

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

 View Only

  • 1.  hadr

    Posted Thu March 26, 2020 10:29 AM
    for our hadr setup we use a vip for each database
    I have defined the monitoring based on this vip and not the real ip address - and only defined 1 connection based on this vip
    if hadr monitoring is required, do we need to monitor through the ip and specify the standby ? or can vip be used and standby still needs to be defined  in connections ?

    ------------------------------
    Thank for all update/help
    Best Regards, Guy Przytula
    ------------------------------

    #Db2


  • 2.  RE: hadr

    Posted Mon April 06, 2020 04:11 AM
    Hello Guy,

    When adding connection profile in DMC, there has an option for initializing H​ADR, that will detect all the HADR standbys information base on the primary node's information. The detected host info of the standbys may be an internal IP. With the internal IP, DMC can not establish connections to standby databases so that DMC can not monitor them.

    So if you want to monitor your databases as a HADR group. we suggest to assign a public IP to each HADR member. In the HADR initiate process, we can replace the internal IP to public IP, so that DMC can communicate to the standby database.

    If you don't need to monitor the whole HADR group, I think that's OK to use only one VIP to connect and monitor the only one HADR database.

    ------------------------------
    Tao Wen
    ------------------------------

    Original Message


Related Content