RE: Informix in "comatose" mode?
This time no active processing was being done at the time.
A cron job scheduled for midnight ran successfully, whereas
another scheduled for 4:00 a.m. could not even connect. So
the server lost its way some time in between. And except for
some middleware connections (which were not doing any active
processing) there were no users on the server.
-----Original Message-----
From: Carlson@WHSmith [mailto:carlson1@bellsouth.net]
Sent: Thursday, May 20, 1999 11:09 AM
To: informix-list@iiug.org
Subject: Re: Informix in "comatose" mode?
What programs are executing while this is going on?
John Carlson
Informix DBA
WHSmith USA
Alanoly Andrews wrote:
>
> Hi,
>
> Occasionally, our Informix Server (7.22 UC2 on AIX 4.1.4) goes into
> what I would call "comatose" mode, ie, technically alive but
practically
>
> dead. All "onstat" commands work but after an abnormal delay and
> with the initial message of "No response from server process". The
> log file does not indicate anything out of the ordinary.
> No connections can be made to any db on the server. "onmode -k"
> does not work. The only way to handle this seems to be to kill
> shared memory (or the master daemon) and do "oninit".
> And when the server comes back, everything seems normal.
>
> Some of you probably may have had the same experience. Any
> thoughts on what is causing this and whether it is possible to revive
> the server without first killing it?
>
> Alanoly J. Andrews