Need the experts , Informix freeze or down
Posted in 2003
Topics: General Discussion
Hi gurus,
I need urgent help ,informix freeze for some reason and no command can
be run except onstat command.
I cannot stop the service and restart ,don't see any locks (onstat
-u).
The CPU is free also the memory.
Users cannot connect to informix and connected users cannot work.
I really don't know where to start checking.
Database is small 1.5 GB number of users 70 .
The server is w2k server, 2 CPU , 3 GB
informix 7.31 TD1.
I need way to check what is the problem or any suggestions .
Thanks
Shay
On Tue, 16 Dec 2003 04:52:50 -0500, shay wrote:
What does the header line output from onstat show? Is it possible that your
logical logs are full? If you are not sure, post onstat -l output including
the header line.
Art S. Kagel
> Hi gurus,
>
> I need urgent help ,informix freeze for some reason and no command can be run
> except onstat command.
> I cannot stop the service and restart ,don't see any locks (onstat -u). The
> CPU is free also the memory.
> Users cannot connect to informix and connected users cannot work. I really
> don't know where to start checking. Database is small 1.5 GB number of users
> 70 . The server is w2k server, 2 CPU , 3 GB informix 7.31 TD1.
>
> I need way to check what is the problem or any suggestions .
>
> Thanks
>
> Shay
Is w2k supported for 7.31?
Andy
shay@formula-travel.com (shay) wrote in message news:<c08a9d47.0312160152.3fd1af4f@posting.google.com>...
> Hi gurus,
>
> I need urgent help ,informix freeze for some reason and no command can
> be run except onstat command.
> I cannot stop the service and restart ,don't see any locks (onstat
> -u).
> The CPU is free also the memory.
> Users cannot connect to informix and connected users cannot work.
> I really don't know where to start checking.
> Database is small 1.5 GB number of users 70 .
> The server is w2k server, 2 CPU , 3 GB
> informix 7.31 TD1.
>
> I need way to check what is the problem or any suggestions .
>
> Thanks
>
> Shay