IBM Support

PH34836: UNEXPECTED HA FAILOVER TRIGGERED IF THE FAILOVER CONTROLLER CANNOT CONTACT ZOOKEEPER

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • It is possible to experience a false positive if the
failover controller is not able to contact Zookeeper, which
results in an unexpected and unwanted HA failover.

This fix will add some logic to the failover controller to
double check the HADR state using db2pd -hadr and if the state
is CONNECTED then do not failover. This is for
automated failovers only; user initiated failovers
would proceed as expected.

Local fix

  • Disable automated failover.

Problem summary

  • Please see problem description.

Problem conclusion

  • 



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PH34836
    • 

  • Reported component name
    IBM BIG SQL
    • 

  • Reported component ID
    5737E7400
    • 

  • Reported release
    504
    • 

  • Status
    CLOSED  FIN
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2021-02-25
    • 

  • Closed date
    2021-04-29
    • 

  • Last modified date
    2021-04-29
    • 





    

  • APAR is sysrouted FROM one or more of the following:
    

    • 

  • APAR is sysrouted TO one or more of the following:
    

    • 



Fix information


    



Applicable component levels


    








      
              
                            

              

              [{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCRJT","label":"IBM Db2 Big SQL"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"504"}]
              

                                                                    

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            30 April 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback