Informix

nested-group-icon.png

DB2

Expand all | Collapse all

onstat -g top is great, on a primary

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

    Posted 30 days ago

    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
    ------------------------------


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

    Posted 30 days ago
    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

    Posted 30 days ago

    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 30 days ago
    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

    Posted 29 days ago
    According to HCL, anything that isn't a crash is "expected behavior." :-/

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



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

    Posted 29 days ago
    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

    Posted 27 days ago

    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

    Posted 26 days ago
    IT33526: ONSTAT -G TOP ON SECONDARY DOESN'T WORK

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