Question & Answer
Question
How do I resolve an SQL30081N error connecting to DB2?
Answer
SQL30081N A communication error has been detected. Communication protocolbeing used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "XX.XX.XX.XX". Communication function detecting the error: "connect". Protocol specific error code(s): "110", "*", "*".SQLSTATE=08001
Resolution: Check that the Firewall on the server prevents a successful connection.
On Linux, the command "sudo iptables -L" is useful in determining if any firewall rules may be preventing communiction.
Resources used in troubleshooting:
Firewall may block connection between client and server
http://www.ibm.com/support/docview.wss?uid=swg21499220
On server set DB2 communications to tcpip
http://www.ibm.com/support/knowledgecenter/SSEPGG_10.1.0/com.ibm.db2.luw.qb.server.doc/doc/t0004714.html
On server set database manager configuration file to use tcp/ip communications
http://www.ibm.com/support/knowledgecenter/SSEPGG_10.1.0/com.ibm.db2.luw.qb.server.doc/doc/t0006065.html
On client catalog a TCP/IP node
http://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.1.0/com.ibm.db2.luw.qb.client.doc/doc/t0005621.html?view=embed
On client update hosts and services files for TCP/IP connections
http://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.1.0/com.ibm.db2.luw.qb.client.doc/doc/t0004712.html?view=embed
On client catalog database
http://www.ibm.com/support/knowledgecenter/SSEPGG_10.1.0/com.ibm.db2.luw.qb.client.doc/doc/t0005622.html
Resolution: Check that the Firewall on the server prevents a successful connection.
On Linux, the command "sudo iptables -L" is useful in determining if any firewall rules may be preventing communiction.
Resources used in troubleshooting:
Firewall may block connection between client and server
http://www.ibm.com/support/docview.wss?uid=swg21499220
On server set DB2 communications to tcpip
http://www.ibm.com/support/knowledgecenter/SSEPGG_10.1.0/com.ibm.db2.luw.qb.server.doc/doc/t0004714.html
On server set database manager configuration file to use tcp/ip communications
http://www.ibm.com/support/knowledgecenter/SSEPGG_10.1.0/com.ibm.db2.luw.qb.server.doc/doc/t0006065.html
On client catalog a TCP/IP node
http://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.1.0/com.ibm.db2.luw.qb.client.doc/doc/t0005621.html?view=embed
On client update hosts and services files for TCP/IP connections
http://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.1.0/com.ibm.db2.luw.qb.client.doc/doc/t0004712.html?view=embed
On client catalog database
http://www.ibm.com/support/knowledgecenter/SSEPGG_10.1.0/com.ibm.db2.luw.qb.client.doc/doc/t0005622.html
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSQTW3","label":"IBM On Demand Consulting for Hybrid Cloud"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
Modified date:
01 February 2019
UID
ibm10778955