Informix Error Messages and Error Codes From Error 29087 to 29088


Informix Error Code -29087 Network Protocol Communication error. Informix-SQLCODE,native-protocol-rc: code
An Informix communications-related SQLCODE value and a hexadecimal native-network protocol return code are returned as a token in SQLERRM.
Informix-SQLCODE is a platform-independent return code that the Informix communications adaptation service generates. For a more specific description of the error, refer to the explanation of this SQLCODE value.
The native-protocol-rc value is a return code generated by the local network communications service that provides the protocol support on each particular platform. For an explanation of this return code, refer to the manufacturer’s documentation for the protocol support that provides the underlying communications service.

Ensure that the native-network communications service is installed correctly and that the target AS is configured correctly and is currently running.
Example: If the communications protocol is TCP/IP, then the native-protocol-rc value is the return code that the local TCP/IP service generates.

Informix Error Code -29088 Communication buffer size (size) is not valid.
The send buffer that the Informix connectivity network module allocated is less than the minimum DRDA-required size, which is 512 bytes, or more than the maximum size, which is 32,767 bytes.
Check the sqlhosts file on the Gateway computer. If the send buffer size is configurable through the sqlhosts file, make sure that the send buffer size is configured to be from 512 bytes to 32,767 bytes, inclusive.
If the network protocol being used is TCP/IP, an additional 6 bytes are required by the Informix connectivity network module. This means the user specifiable block size minimum is 518 bytes and maximum is 32,773 bytes.

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 *