We are running IBM Informix Dynamic Server Version 11.50.FC9 on AIX 5.3, just saw these messages in the online log, anybody ever see these before? I searched the 11.50 online docs and did not find anything.



04:15:06 sid 2075149 username informix@ibm496 pid 1560588 terminated.

04:15:06 killed(MCMD_KILL)

04:15:08 sid 2010906 username wicbea@linux12 pid -1 terminated.

04:15:08 killed(MCMD_KILL)

04:15:09 sid 2010904 username wicbea@linux33 pid -1 terminated.

04:15:09 killed(MCMD_KILL)

On Sep 15, 9:16*am, "Plugge, Joe R." <JRPlu... (AT) west (DOT) com> wrote:
That message looks like it's new to 11.50.xC9. When somebody runs an
onmode -z to try to kill a session.

Jacques Renaut
IBM Informix Advanced Support
APD Team

No one should have been running an onmode -z at that time. However we do have some scripts which do fragment detach and attach which are set to force.Could that be doing the kill?

-----Original Message-----
From: informix-list-bounces (AT) iiug (DOT) org [mailto:informix-list-bounces (AT) iiug (DOT) org] On Behalf Of jrenaut
Sent: Thursday, September 15, 2011 9:32 AM
To: informix-list (AT) iiug (DOT) org
Subject: Re: MCMD_KILL Message?

On Sep 15, 9:16*am, "Plugge, Joe R." <JRPlu... (AT) west (DOT) com> wrote:
That message looks like it's new to 11.50.xC9. When somebody runs an onmode -z to try to kill a session.

Jacques Renaut
IBM Informix Advanced Support
APD Team
_______________________________________________
Informix-list mailing list
Informix-list (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list

On Sep 15, 9:45*am, "Link, David A" <DAL... (AT) west (DOT) com> wrote:
A quick look at source didn't show that that would be doing a session
kill when trying to enforce the DDL force. It looks like it should
only be doing a forced open transaction rollback, not killing off the
sessions. The other place I see an internal call to kill sessions off
is in some of the server mode changing via the admin api. Would you
have been trying to switch the server to single user mode or shutdown
with the immediate flag around then? Those are the only 2 places I
can see that sessions would be getting killed with this code path that
would generate that new message (onmode -z or doing an immediate
shutdown or immediate single user mode via the admin api *Note this
was a quick search and the source code database I use I will sometime
screw up building it and leave off directories so I might not have all
the places accounted for*).

Jacques Renaut
IBM Informix Advanced Support
APD Team

Sorry Jacques,

We have a wrapper around the fragment command which does do onmode -z. I thought it was just part of the force. My error.

Thanks for looking.

David

-----Original Message-----
From: informix-list-bounces (AT) iiug (DOT) org [mailto:informix-list-bounces (AT) iiug (DOT) org] On Behalf Of jrenaut
Sent: Thursday, September 15, 2011 10:11 AM
To: informix-list (AT) iiug (DOT) org
Subject: Re: MCMD_KILL Message?

On Sep 15, 9:45*am, "Link, David A" <DAL... (AT) west (DOT) com> wrote:
A quick look at source didn't show that that would be doing a session kill when trying to enforce the DDL force. It looks like it should only be doing a forced open transaction rollback, not killing off the sessions. The other place I see an internal call to kill sessions off is in some of the server mode changing via the admin api. Would you have been trying to switch the server to single user mode or shutdown with the immediate flag around then? Those are the only 2 places I can see that sessions would be getting killed with this code path that would generate that new message (onmode -z or doing an immediate shutdown or immediate single user mode via the admin api *Note this was a quick search and the source code database I use I willsometime screw up building it and leave off directories so I might not have all the places accounted for*).

Jacques Renaut
IBM Informix Advanced Support
APD Team


_______________________________________________
Informix-list mailing list
Informix-list (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list