Toad World® Forums

Connection to Db2 database is slow

When I try to connect cataloged DB using toad I am getting below error.

ERROR [08001] [IBM] SQL30081N A communication error has been detected. Communication protocol being used: “TCP/IP”. Communication API being used: “SOCKETS”. Location where the error was detected: “IP Removed”. Communication function detecting the error: “selectForRecvTimeout”. Protocol specific error code(s): “0”, “", "”. SQLSTATE=08001.

After making changes to tools>options>databases>timeouts>connection timeout to 60 I am able to connect but it is slow. do anyone has any idea on this error or slowness.

Ravi,

IBM has a tech article regarding this error message which states the following:

"There are some situations in which no return code is returned such as the following example:

SQL30081N A communication error has been
detected. Communication protocol being used: “TCP/IP”. Communication
API being used: “SOCKETS”. Location where the error was detected:
“192.168.1.200”. Communication function detecting the error: “recv”.
Protocol specific error code(s): ", "”, “0”. SQLSTATE=08001

,,0 indicates the connection was closed by the peer. This could be any network device (i.e. firewall, router, workload balancing device, etc…) between the client and DB2 server, or the DB2 server itself. "

Here is the link to the article:
www-01.ibm.com/…/docview.wss

Hopefully this helps.

Thanks,

Eric Sheridan