Informix

 View Only
  • 1.  onstat -g top is great, on a primary

    IBM Champion
    Posted Fri July 10, 2020 11:10 AM

    But run it against an HDR secondary and you get this:

    $ onstat -g top
    
    IBM Informix Dynamic Server Version 14.10.FC4W1 -- Read-Only (Sec) -- Up 18:56:54 -- 960512 Kbytes
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    


    ------------------------------
    TOM GIRSCH
    ------------------------------

    #Informix


  • 2.  RE: onstat -g top is great, on a primary

    IBM Champion
    Posted Fri July 10, 2020 11:22 AM
    PMR time! I will pass that along, but a PMR will help get it fixed.

    Art

    Art S. Kagel, President and Principal Consultant
    ASK Database Management


    Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference.  Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.








  • 3.  RE: onstat -g top is great, on a primary

    IBM Champion
    Posted Fri July 10, 2020 11:44 AM

    Way ahead of you.

    TS003925191

    BTW, multiple PMRs on the same issue seem to kick their collective butts into gear.



    ------------------------------
    TOM GIRSCH
    ------------------------------



  • 4.  RE: onstat -g top is great, on a primary

    Posted Fri July 10, 2020 01:27 PM
    It depends on the instance type. For example, I tested with an ER cluster and the command worked however ER nodes are fully independent. HA secondaries are a different animal since they are linked to the primary much more closely. Let's see what development comes back with but this may well be expected behavior because of how the instances operate.

    ------------------------------
    Carlton Doe
    ------------------------------



  • 5.  RE: onstat -g top is great, on a primary

    IBM Champion
    Posted Fri July 10, 2020 06:36 PM
    According to HCL, anything that isn't a crash is "expected behavior." :-/

    ------------------------------
    TOM GIRSCH
    ------------------------------



  • 6.  RE: onstat -g top is great, on a primary

    IBM Champion
    Posted Fri July 10, 2020 06:37 PM
    I'd add that if you're using an HDR secondary for reporting and workload distribution, as we do, being able to run this command on one is pretty crucial.

    ------------------------------
    TOM GIRSCH
    ------------------------------



  • 7.  RE: onstat -g top is great, on a primary

    IBM Champion
    Posted Mon July 13, 2020 03:08 PM

    Fix for this has already been encoded and set for release in 14.10.xC5.

    idsdb00106199



    ------------------------------
    TOM GIRSCH
    ------------------------------



  • 8.  RE: onstat -g top is great, on a primary

    IBM Champion
    Posted Mon July 13, 2020 04:09 PM
    IT33526: ONSTAT -G TOP ON SECONDARY DOESN'T WORK

    ------------------------------
    TOM GIRSCH
    ------------------------------