936 error occurs ( and possiby 25582 ) while running a remote query

Technote (troubleshooting)


Problem(Abstract)

You are running a query involving a remote connection. You unexpectedly receive error 936. Depending on the additional error information your application collects and returns you might see a message like this:

936: Error on remote connection, g_prod, conerr=-25582, oserr=0, err

Cause

-936 Error on remote connection connection-name.

An attempted connection to a remote host failed. Check the name of the
connection that is specified in your particular connection statement
(CONNECT, DATABASE, and so on) to make sure that you correctly
specified the name or path of the connection. Check for incorrect
spelling. Check for the wrong connection name.

As the finderr output above points out, you should first make sure your connection information is correct.

Assuming the connection information is correct then the cause of error 936 is a connection being lost.

Note: There could be other causes.

Diagnosing the problem

The connection might have been lost due to the session being killed on the remote server using onmode -z. If onmode -z was used, then the remote server's online.log will have a message like this in it:

10:21:58  sid 32 username informix@g_prod pid 4194632 terminated.
10:21:58   killed(MCMD_KILL)

If the connection was lost due to a network error it could be difficult to track down the cause. If a network problem is happening consistently and you typically run remote queries, then you will likely see errors in the online.log indicating the same. These would be errors like 22582, 25580, 25579, and possibly other 255** errors.


Resolving the problem

Rate this page:

(0 users)Average rating

Document information


More support for:

Informix Servers

Software version:

10.0, 11.1, 11.5, 11.7, 11.70, 12.1

Operating system(s):

AIX, HP-UX, Linux, Mac OS X, Solaris, Windows

Reference #:

1633445

Modified date:

2013-04-04

Translate my page

Machine Translation

Content navigation