Oninit
Talk to an expert →

Informix Error -29087: Network Protocol Communication error. Informix-SQLCODE,native-protocol-rc: code

Cause and resolution

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.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-29087 fires on a network-protocol-layer communication error — per the official guidance, an Informix communications-related SQLCODE (platform-independent) and a native protocol return code (platform-specific, e.g. from the local TCP/IP service) are returned as tokens in SQLERRM.

  1. A network communications service problem, per the official guidance — see the platform's protocol documentation for the native return code's meaning.
Solutions / Resolution
  1. Ensure the native-network communications service is installed correctly, per the official guidance.
  2. Ensure the target application server is configured correctly and running, per the official guidance.
Examples
N/A

No specific triggering statement is documented beyond a network protocol communication error.

Diagnostic Checks
  1. Extract the Informix SQLCODE and native protocol return code from SQLERRM, and check the network service installation and target server status.
Related Errors / Related Topics
  • -29011 — "SNA communication error. Informix-SQLCODE,native-SNA-rc: Informix-communication-SQLCODE,native-SNA-return-code." A related communication error, specific to SNA/APPC rather than the general network protocol layer.

A network-protocol communication error occurred — check the native network service installation and the target server's status.