Re: Cannot login

Paul, your response is bothering me. > In article <3fdsmu$5l8@c2.eunet.co.at>, kop@genua.ems.co.at (Peter > Kolmhofer) writes:|> Hi everybody, > |> > |> we have encountered a problem with our Informix-Server: > |> > |> Sometimes ist is impossible to connect to the server via > TCP-connection.|> To be more specific, it appears as connections become > impossible when a |> certain limit of connections (in total, not in > parallel) is exceeded, as|> this happens only, when the server was > running 2+ days of processing. |> To the user it seems, that the > application hangs - doing nothing. I |> used onstat -u to verify that > the user is not currently connected to to|> database. It seems to me, as > if the poll-thread or the listener-thread |> have some problems (maybe > the sqlexec cannot be started to whatever |> reason). The only way to > solve this problem is to shutdown and re-init|> the server (which of > course is inconvenient in production-systems).|> > |> BTW, we are using Online 6.00.UE1 on a RS/6000, AIX 3.2.5. > |> > |> Has anyone encountered simelar problems and a solution (or a > workaround)|> or even a explaination for this specific problem? > |> > |> Thanks in advance, > |> > |> Peter > |> > |> > > Im not totally sure about this, but it soundslike the Unix kernel > _might_be hitting a max number of TCP sockets. > To overcome this, you need to re-size your kernel tables to increase one > ormore of these parameters - best see your system administrator for > this.Can anyone confirm or dispute this ? > -- > > Regards > > +--------------------------------------+-------------------------------- > ---+| Motorola | > || International Cellular Subscriber | Phone + 44 > (0)31-469-6969 || Easter Inch, Bathgate | Fax + > 44 (0)31-469-6970 || West Lothian EH48 2EH | > || SCOTLAND | > > |+--------------------------------------+------------------------------- > ----+ Are you saying that, even when the socket is finished with it could be left open by TCP/IP??? If that is the case it is surely an OS problem. Malcolm Weallans Online Database Consultancy 2 Arkley Court Maidenhead Berks SL6 2YR Phone 0628-72154 Fax 0628-37463 CIX - onlinedbc