SQL30081N A communication error has been detected SQLSTATE=08001 DB2 --- toad client issue

Toad for IBM DB2
1

I am facing the below error while connecting to DB with Toad client.

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: . Communication function detecting the error: “selectForRecvTimeout”. Protocol specific error code(s): “0”, “", "”. SQLSTATE=08001

I have re-started the Toad, uncataloging and cataloging is done.

It looks toad is not viewing these settings.

All ports are enabled and there is no firewall issue.

Can any one help me to resolve this.

2

Are you able to connect to the database using DB2 CLI? E.g. with command “db2 connect to sample”?

What is the database version and client version you are using? That is your Toad for DB2 version?

3

Also, If you are using Toad DB2 v6.3 or later, please try to create a ‘connection string’ connection profile (where you do not have to use a DB2 cataloged database).

Try that and try connecting from the IBM DB2 CLP too - as Ondrej stated…