TCPIP Network Client Errors
The following table lists TCPIP Network Client error constants, values, SqlState, SqlCode and a description of the error.
| SqlState | SqlCode | Description |
|---|---|---|
| 08S01 | -602 | Message : Could not resolve the specified host name. Reason : The client could not connect to the DB2 server with an incorrect user-specified Network Address or Network Port value. Action : Verify connection information to ensure the Network Address and Network Port specified matches the server. For more information, see Network Address and Network Port. |
| 08S01 | -603 | Message : Could not connect to specified host. Reason : The client could not connect to the DB2 server with an incorrect user-specified Network Address or Network Port value, or the server is unavailable. Action : Verify connection information to ensure the Network Address and Network Port specified matches the server. Contact the network administrator or server administrator. For more information, see Network Address and Network Port. |
| 08S01 | -604 | Message : Socket allocation failed. Reason : The client failed to connect to the DB2 server via a TCP/IP network, when all of the local client socket resources were in use. Action : Close unused client connections. Utilize client connection pooling. For more information, see Connection Pooling. |
| 08S01 | -605 | Message : The network connection was terminated because the host failed to send any data. Reason : The client could not connect to the DB2 server due to an unforeseen problem with the client or server. Action : Contact the client administrator, network administrator, or server administrator. |
| 08S01 | -606 | Message : Enterprise single sign-on failure: Could not contact the SSO server <server-name>. Check that SSO is configured and that the SSO service is running on hat server. Reason : The Enterprise Single Sign-On server is not configured or running. Action : Verify connection information to ensure the ESSO Affiliate Application name matches the value for the server and current user defined by the Enterprise Single Sign-On administrator. Check with your Enterprise Single Sign-On Administrator. Configure an alternative authentication method. For more information, see Security Method. |
| 08S01 | 10093 | Message : A TCPIP socket error has occurred (10014): The sockaddr structure pointed to by the name contains incorrect address format for the associated address family or the namelen parameter is too small. This error is also returned if the sockaddr structure pointed to by the name parameter with a length specified in the namelen parameter is not in a valid part of the user address space. Reason : The client is attempting to connect to the DB2 server using an improperly-formatted IPv6 Network Address. Action : Verify connection information to ensure the Network Address specified matches the server and requirements for either an IPv4 or IPv6 network. For more information, see Network Address. |
| 08S01 | 10049 | Message : A TCPIP socket error has occurred (10022): An invalid argument was supplied. Reason : The client is attempting to connect to the DB2 server using an improperly-formatted IPv4 or IPv6 Network Address. Action : Verify connection information to ensure the Network Address specified matches the server and requirements for either an IPv4 or IPv6 network. For more information, see Network Address. |
| 08S01 | 10047 | Message : A TCPIP socket error has occurred (10024): No more socket descriptors are available. Reason : The client failed to connect to the DB2 server via a TCP/IP network, when all of the local client socket connections were in use. Action : Close unused client connections. Utilize client connection pooling. For more information, see Connection Pooling. |
| 08S01 | 10061 | Message : A TCPIP socket error has occurred (10040): The message was too large to fit into the specified buffer and was truncated. Reason : The client failed to execute a command as requested by the program. Action : Verify that the command syntax and parameter data values are within the limits supported by the DB2 server platform and version. For more information on command and data type limits, see Data Type Mappings. |
| 08S01 | 10014 | Message : A TCPIP socket error has occurred (10043): The specified protocol is not supported. Reason : The client is attempting to connect to the DB2 server using an access method that is not supported by the DB2 server, such as Secure Sockets Layer or Transport Layer Security. Action : Verify connection information to ensure the DB2 server support SSL or TLS. Configure a TCP/IP network without specifying SSL or TLS. Contact the network administrator or server administrator. For more information on TCP/IP Network Connection, see TCP/IP Network Connection. |
| 08S01 | 10051 | Message : A TCPIP socket error has occurred (10047): Addresses in the specified family cannot be used with this socket. Reason : The client is attempting to connect to the DB2 server using an improperly-formatted IPv4 or IPv6 Network Address. Action : Verify connection information to ensure the Network Address specified matches the server and requirements for either an IPv4 or IPv6 network. For more information, see Network Address. |
| 08S01 | 10065 | Message : A TCPIP socket error has occurred (10049): The remote address is not a valid address (such as INADDR_ANY or in6addr_any). Reason : The client is attempting to connect to the DB2 server using an improperly-formatted IPv6 Network Address. Action : Verify connection information to ensure the Network Address specified matches the server and requirements for either an IPv4 or IPv6 network. For more information, see Network Address. |
| 08S01 | 10052 | Message : A TCPIP socket error has occurred (10050): A socket operation encountered a dead network. This could indicate a serious failure of the network system (that is, the protocol stack that the Windows Sockets DLL runs over), the network interface, or the local network itself. Reason : The client could not connect to the DB2 server with an incorrect user-specified Network Address or Network Port value, or the server is unavailable. Action : Verify connection information to ensure the Network Address and Network Port specified matches the server. Contact the server administrator. For more information, see Network Address and Network Port. |
| 08S01 | 10040 | Message : A TCPIP socket error has occurred (10053): The network cannot be reached from this host at this time. Reason : The client could not connect to the DB2 server with an incorrect user-specified Network Address or Network Port value, or the server is unavailable. Action : Verify connection information to ensure the Network Address and Network Port specified matches the server. Contact the server administrator. For more information, see Network Address and Network Port. |
| 08S01 | 10053 | Message : A TCPIP socket error has occurred (10053): For a connection-oriented socket, this error indicates that the connection has been broken due to keep-alive activity detecting a failure while the operation was in progress. For a datagram socket, this error indicates that the time to live has expired. Reason : The server closed the client connection. Action : Contact the network administrator or server administrator. |
| 08S01 | 10060 | Message : A TCPIP socket error has occurred (10052): The connection has been broken due to the keep-alive activity detecting a failure while the operation was in progress. Reason : The server closed the client connection. Action : Contact the network administrator or server administrator. |
| 08S01 | 10054 | Message : A TCPIP socket error has occurred (10053): An established connection was aborted by the software in your host machine. Reason : The server closed the client connection. Action : Contact the network administrator or server administrator. |
| 08S01 | 10052 | Message : A TCPIP socket error has occurred (10054): The virtual circuit was reset by the remote side executing a hard or abortive close. The application should close the socket as it is no longer usable. On a UPD-datagram socket this error would indicate that a previous send operation resulted in an ICMP "Port Unreachable" message. Reason : The server closed the client connection. Action : Contact the network administrator or server administrator. |
| 08S01 | 10055 | Message : A TCPIP socket error has occurred (10055): No buffer space is available. Reason : The client failed to connect to the DB2 server via a TCP/IP network, when all of the local client socket resources were in use. Action : Close unused client connections. Utilize client connection pooling. For more information, see Connection Pooling. |
| 08S01 | 10057 | Message : A TCPIP socket error has occurred (10057): A request to send or receive data was disallowed because the socket is not connected and (when sending on a datagram socket using a sendto call) no address was supplied. Reason : The client could not connect to the DB2 server with an incorrect user-specified Network Address or Network Port value. Action : Verify connection information to ensure the Network Address and Network Port specified matches the server. For more information, see Network Address and Network Port. |
| 08S01 | 10065 | Message : A TCPIP socket error has occurred (10060): The connection has been dropped because of a network failure or because the peer system failed to respond. Reason : The server closed the client connection. Action : Contact the network administrator or server administrator. |
| 08S01 | 10024 | Message : A TCPIP socket error has occurred (10061): The attempt to connect was forcefully rejected. Reason : The client could not connect to the DB2 server with an incorrect user-specified Network Address or Network Port value. Action : Verify connection information to ensure the Network Address and Network Port specified matches the server. For more information, see Network Address and Network Port. |
| 08S01 | 10043 | Message : A TCPIP socket error has occurred (10065): A socket operation was attempted to an unreachable host. Reason : The client could not connect to the DB2 server with an incorrect user-specified Network Address or Network Port value, or the server is unavailable. Action : Verify connection information to ensure the Network Address and Network Port specified matches the server. Contact the server administrator. For more information, see Network Address and Network Port. |
| 08S01 | 10050 | Message : A TCPIP socket error has occurred (10093): A successful WSAStartup call must occur before using this function. For more information, see https://msdn.microsoft.com/library/ms742213(VS.85).aspx. Reason : The client failed to connect to the DB2 server via a TCP/IP network, when all of the local client socket connections were in use. Action : Close unused client connections. Utilize client connection pooling. For more information, see Connection Pooling. |