Re: Cannot login
Posted in 1995
Topics: Platform-Specific Issues
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 or
more 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 | |
+--------------------------------------+-----------------------------------+