Informix Error Messages and Error Codes From Error 27001 to 27002


Informix Error Code -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 Informix Dynamic Server or INFORMIX-OnLine Dynamic Server, verify that the database server is still on-line. If you are using INFORMIX-SE, verify that the sqlexecd daemon for the database server is still running. Use the environment variables INFORMIXCONTIME and/or 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.
Informix Error Code -27002 No connections are allowed in quiescent mode.
You are attempting to connect to a database server that is in quiescent mode. Verify that your INFORMIXSERVER environment variable is set correctly. Ask the database server administrator to bring the appropriate database servers to on-line mode.

Above are list of Informix Error Messages and Errors Codes or Status Codes or Exit Codes along with Error and Warning messages received while performing certain operation against Informix applications or related products.

What are Informix Error Messages?
All Informix messages returned by the Informix server are assigned an error code.

In general, each Informix error contains the following information:
• The Informix Error Code or Informix Error status
• The message text. This text is usually returned with the Error code. Some messages employ word substitution, where the word substituted represents the system-replacement of a term more specific to the occurrence.
• An explanation of how the error may have occurred.

Hope this was helpful.

SQLServerF1 Team
Information about Informix Error Codes or Status Codes or Exit Codes and Error Messages on Windows, Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *