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.
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.|
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.
|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.|
|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
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.|
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.