Hi,

We are facing TCPIP Communication error in DB2 Express C,

Issue:

There are 2 sites which we connecting with Public IP
Site A: server
Site B: Client

we are facing the below mentioned error

Standard connection failed.
SQL30081N A communication error has been detected. Communication protocol
being used: "TCP/IP". Communication API being used: "SOCKETS". Location
where the error was detected: "xxx.xxx.xxx.xxx". Communication function
detecting the error: "connect". Protocol specific error code(s): "10060", "*",
"*". SQLSTATE=08001

CLI connection failed.
SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "xxx.xxx.xxx.xxx". Communication function detecting the error: "connect". Protocol specific error code(s): "10060", "*", "*". SQLSTATE=08001


ODBC connection failed.
[IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "xxx.xxx.xxx.xxx". Communication function detecting the error: "connect". Protocol specific error code(s): "10060", "*", "*". SQLSTATE=0800

Kindly help me how to solve this.

It could be a firewall issue. Make sure the ping the IP and see how it goes.

Is the SVCENAME and DB2COMM set at the server ?

db2 update dbm cfg using SVCENAME <service/port number>
db2set DB2COMM=TCPIP
db2stop
db2start

Regards,
Sawan Gupta