Oninit
Talk to an expert →

Informix Error -29011: SNA communication error. Informix-SQLCODE,native-SNA-rc: Informix-communication-SQLCODE,native-SNA-return-code.

Cause and resolution

SNA communication error. Informix-SQLCODE,native-SNA-rc: Informix-communication-SQLCODE,native-SNA-return-code.

An Informix communication-related SQLCODE and a hexadecimal native SNA service return code are returned as a token in SQLERRM.

The Informix communication-related SQLCODE is a platform-independent return code that the Informix communication adaptation service generates. Refer to the explanation of this SQLCODE for a more specific description of the error.

The native SNA service return code is a return code generated by the local SNA service that provides the SNA support on each particular platform. Refer to the manufacturer's documentation for the SNA support that provides the underlying communication service for an explanation of this return code.

Ensure that the native SNA/APPC service is installed correctly. Check that all the required SNA daemon processes (if any) are running. Also check that the connection file for the target RDB is set up correctly. In a Sun environment, also check that the Sun APPC Gateway is set up correctly.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-29011 fires on an SNA-layer communication error — per the official guidance, an Informix communication-related SQLCODE (platform-independent) and a native SNA service return code (platform-specific) are returned as tokens in SQLERRM.

  1. An underlying SNA/APPC service problem, per the official guidance — see the platform's SNA support documentation for the native return code's meaning.
Solutions / Resolution
  1. Ensure the native SNA/APPC service is installed correctly, per the official guidance.
  2. Check that required SNA daemon processes are running, per the official guidance.
  3. Check that the connection file for the target RDB is set up correctly, per the official guidance.
  4. On Sun, also check that the Sun APPC Gateway is set up correctly, per the official guidance.
Examples
N/A

No specific triggering statement is documented beyond an SNA communication failure.

Diagnostic Checks
  1. Extract the Informix SQLCODE and native SNA return code from SQLERRM, and check SNA/APPC service installation, daemons, and the RDB connection file.
Related Errors / Related Topics

No closely related error codes are cross-referenced for -29011 in this set yet.

An SNA-layer communication error occurred — check SNA/APPC service installation, daemons, and the RDB connection file.