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
------------------------------
Original Message:
Sent: Fri July 10, 2020 11:44 AM
From: TOM GIRSCH
Subject: onstat -g top is great, on a primary
Way ahead of you.
TS003925191
BTW, multiple PMRs on the same issue seem to kick their collective butts into gear.
------------------------------
TOM GIRSCH
Original Message:
Sent: Fri July 10, 2020 11:21 AM
From: Art Kagel
Subject: onstat -g top is great, on a primary
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.
Original Message:
Sent: 7/10/2020 11:10:00 AM
From: TOM GIRSCH
Subject: onstat -g top is great, on a primary
But run it against an HDR secondary and you get this:
$ onstat -g topIBM 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