Hello,

I receive en my message log un error such 2 minutes,listed as below :

-----------------------------------------------------------------------
16:51:18 listener-thread: err = -27001: oserr = 0: errstr = : Read
error occurred during connection attempt.
16:49:18 listener-thread: err = -25582: oserr = 9: errstr = :
Network connection is broken. System error = 9.

16:47:18 listener-thread: err = -27001: oserr = 0: errstr = : Read
error occurred during connection attempt.

--------------------------------------------------------------
En my sqlhosts file i have this information :

mydbserver ontlitcp myhost 1525
mydbalias onipcshm myhost 1526
-------------------------------------------------------------
En my onconfig file i have :

DBSERVERNAME mydbserver
DBSERVERALIASES mydbalias
NETTYPE tlitcp,2,400,NET
NETTYPE ipcshm,1,20,cpu
-------------------------------------------------------------------
and my number of connections is <= 100 connections
===> it is not a problem of POLLTHREAD and LISNERTHREAD.

WHERE IS THE PROBLEM ?

Thanks.

Output from "finderr 25582"

-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.



Output from "finderr 27001":

-27001 Read error occurred during connection attempt.

This error can occur on either the client or database server side.

When you encounter this error on the client side, it indicates that a
network I/O error occurred when the client tried to connect to a
database server. Probably the connection attempt timed out because the
database server or the network was very busy, too many clients were
attempting to connect to the database server simultaneously, or the
database server was taken off-line during the connection attempt.

If you are using IBM Informix Dynamic Server, IBM Informix Universal Server, or
IBM Informix OnLine Dynamic Server, verify that the database server is still
online. If you are using IBM Informix SE, verify that the sqlexecd daemon for the
database server is still running. Use either or both of the environment
variables INFORMIXCONTIME and INFORMIXCONRETRY on the client side to increase
the connection time and number of retry attempts.

When you encounter this error on the database server side, it is a
warning that a network I/O error is detected while the database server
is accepting a connection request from a client. This error usually
occurs when the database server or the network is very busy or when too
many clients are trying to connect to the database server at once. The
database server might be taking so long to respond to a client that the
client's connection request timed out before the connection is
complete. Or possibly a client terminated its connection attempt before
the connection is completely established.

If this error is seen only occasionally in the server message log, it
is just a warning. No corrective action is required on the server
side.

If this error occurs frequently on a database server that runs on a
host with multiple processors, you might want to tune the database
server by increasing the number of poll threads and/or listener
threads.

Thanks for the detail of the error -27001.I know it.
But we haven't I/O network error.

Hi,

Please change the following and test.
In SQLHOSTS file:
mydbserver ontlitcp myhost 1525
mydbalias onipcshm myhost 1526
For
mydbalias ontlitcp myhost 1525
mydbserver onipcshm myhost mydbserver ########

In ONCONFIG file
DBSERVERNAME mydbserver
DBSERVERALIASES mydbalias

The connection by ipc does not need I number on services file.
I suggest it to him connection of "ipc" is by CPU.

Gustavo.