TCP/IP errors
The software returns the SQL30081N message (-30081) when a TCP/IP specific communications error is detected. The TCP/IP error that is encountered by the communication subsystem is returned in the list of error tokens for the SQL30081N message.
TCP/IP
The following table lists the common TCP/IP error symbols (errnos
) on Linux®, UNIX, and Windows operating systems. The complete list of the TCP/IP
errors in UNIX operating system can be found in the
/usr/include/sys/errno.h file. On Linux
operating systems, the complete list of the TCP/IP errors are found in the
/usr/include/asm/errno.h file. For Windows operating systems, see Windows Sockets Error Codes.
Error code | AIX® error number | HP-UX error number | Solaris error number | Linux error number | Windows error number | Description |
---|---|---|---|---|---|---|
EINTR | 4 | 4 | 4 | 4 | The function specified was interrupted by a signal. | |
EBADF | 9 | 9 | 9 | 9 | Bad socket. The socket might have been corrupted. | |
EAGAIN | 11 | 11 | 11 | 11 | Resource temporarily unavailable. | |
EFAULT | 14 | 14 | 14 | 14 | Bad address. On connect, bad address. On receive, the data was directed to be received into a nonexistent or protected part of the process address space. The buffer is not valid. |
|
EBUSY | 16 | 16 | 16 | 16 | Resource busy. | |
EINVAL | 22 | 22 | 22 | 22 | Invalid argument that is passed to the specified function or the socket is closed. The EINVAL error can be returned if there was a memory overwrite, or buffer overflow problem. | |
ENFILE | 23 | 23 | 23 | 23 | Too many open files in the system. | |
EMFILE | 24 | 24 | 24 | 24 | The per-process file descriptor table is full. Number of file descriptors/sockets for the process is exceeded. | |
ENOSPC | 28 | 28 | 28 | 28 | No space is left on a device or system table. | |
EPIPE | 32 | 32 | 32 | 32 | Broken pipe. | |
EWOULDBLOCK | 54 | 246 | 11 | 11 | On the connect function, the range that is allocated for TCP/UDP ephemeral ports is exhausted. (Some operating systems return the same error as EAGAIN.) | |
ENOTSOCK | 57 | 216 | 95 | 88 | Socket operation on a non-socket. | |
ENOPROTOOPT | 61 | 220 | 99 | 92 | Option is unknown. | |
EADDRINUSE | 67 | 226 | 125 | 98 | 10048 | The specified address is already in use. Perhaps the previous process that established the connection was terminated abnormally or was not cleaned up properly. |
EADDRNOTAVAIL | 68 | 227 | 126 | 99 | The specified host name or IP address is not available from the local system. | |
ENETDOWN | 69 | 228 | 127 | 100 | The network is down. | |
ENETUNREACH | 70 | 229 | 128 | 101 | No route to the network or host is available. | |
ENETRESET | 71 | 230 | 129 | 102 | The network dropped the connection on reset. | |
ECONNRESET | 73 | 232 | 131 | 104 | 10054 | Connection was reset by the partner. |
ENOBUFS | 74 | 233 | 132 | 105 | 10055 | Insufficient memory or resources were available in the system to complete the call. |
EISCONN | 75 | 234 | 133 | 106 | The socket is already connected. | |
ENOTCONN | 76 | 235 | 134 | 107 | The socket is not connected. | |
ETIMEDOUT | 78 | 238 | 145 | 110 | 10060 | The connection was timed out. |
ECONNREFUSED | 79 | 239 | 146 | 111 | 10061 | The connection was refused. If you are trying to connect to the
database, check that the database manager and TCP/IP protocol support at the server were started
successfully. If you specified the SOCKS protocol support, you must also ensure that the TCP/IP protocol support at the SOCKS server was started successfully. |
EHOSTDOWN | 80 | 241 | 147 | 112 | The host is down. | |
EHOSTUNREACH | 81 | 242 | 148 | 113 | No route to the host is available. | |
SOCECONNABORTED | 72 | 10053 |
Software closed connection If error is reported on client application that uses ODBC/CLI to connect to DB2 UDB server,
disable the Db2 CLI timeout:
|
|||
WSAEINTR | 10004 | Connection closed by client. For Db2 z systems, see the tech note SQL30081n | ||||
WSAEHOSTUNREACH | 81 | 113 | 10065 | No route to host For Windows clients trying to connect to a Linux server, unset the firewall on the Linux server to allow connections to go through from clients. |