RE: Network / TCP problem (?) - sorry for Mime, can't send
Posted in 2004
-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of TBP
Sent: Friday, January 23, 2004 12:20 PM
To: informix-list@iiug.org
Subject: Re: Network / TCP problem (?) - sorry for Mime, can't send
Dirk Moolman wrote:
> This is a multi-part message in MIME format.
>
> We've been battling with network problems over here, and will install =
> BMC next week to help us find the problem. Maybe you can help me with =
> this one.
>
> Solaris 8
>
> IDS7.31FD3
>
> I am getting the following errors in my online.log. I monitored this, =
> and my poll threads are ok as I am not getting this on a regular basis. =
> But is does affect very important applications, which we cannot afford =
> to drop.
>
> Any ideas ? Anyone had a similar experience ? We work ok most of the =
> time, but drop sessions (telnet AND odbc) every now and then, and we =
> can't pinpoint the problem - it's like it keeps moving around.
>
> We tested the network by plugging a user directly into our SUN server =
> with a spare network card (peer-to-peer). She worked fine and didn't =
> drop session anymore.
>
> BUT - to make things weird - I have a cron running on this same server =
> opening tcp connections to Informix, and this will be unable to open the =
> tcp connection about once or twice a week - doesn't make any sense.
>
> Extract from online.log -
>
> 08:34:26 listener-thread: err = -25582: oserr = 9: errstr = : =
> Network connection is broken.
>
> System error = 9.
>
>
> -25582 Network connection is broken.
>
> This error might indicate that the database server has terminated, or a
> problem might exist on the network itself. Check that the network is
> functioning and that the server is still running.
>
> -9 Bad file number.
>
> An operating-system error code with the meaning shown was unexpectedly
> returned to the database server. Look for other operating-system error
> messages that might give more information. If the error recurs, please
> note all circumstances and contact Informix Technical Support.
>Check your open file limits :
>
>run sar -v 5 5 and see if there are any entries under "ov".
No luck, I tried this, but all the values in column "ov" are zero
________________________________
<< ella for Spam Control >> has removed 952 Spam messages and set aside 159 Newsletters for me
You can use it too - and it's FREE! www.ellaforspam.com
sending to informix-list