onstat -g top is great, on a primary

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

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 www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ 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.

Way ahead of you. TS003925191 BTW, multiple PMRs on the same issue seem to kick their collective butts into gear. ------------------------------ TOM GIRSCH ------------------------------

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

According to HCL, anything that isn't a crash is "expected behavior." :-/ ------------------------------ TOM GIRSCH ------------------------------

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

Fix for this has already been encoded and set for release in 14.10.xC5. idsdb00106199 ------------------------------ TOM GIRSCH ------------------------------

IT33526: ONSTAT -G TOP ON SECONDARY DOESN'T WORK ------------------------------ TOM GIRSCH ------------------------------