KNOWLEDGE BASE

Unable to Connect to IBM DB2, "Error Code: 06DA155A [IBM][CLI Driver] SQL30081N A communication error has been detected."


Published: 22 Dec 2023
Last Modified Date: 25 Dec 2023

Issue

When connecting to IBM DB2, the following error message appears.

Error message:
Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.
Error Code: 06DA155A
[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: "000.000.000.000". Communication function detecting the error: "xxx". Protocol specific error code(s): "10054", "*", "*".

Environment

  • Tableau Desktop
  • IBM DB2

Resolution

Option 1

Work with your IT department to check the timeout settings of DB2 CLI and the firewall following the steps described in this IBM website.

Option 2

If multiple drivers (including IBM Data Server Driver Package, such as IBM Data Server Runtime Client) are installed for connection to IBM DB2, remove them and only install the driver listed on Tableau driver download site.

 

Cause

Cause 1
According to the IBM website, the timeout settings of firewall and Db2 CLI may have caused this issue.

Cause 2
If multiple drivers are installed, they may conflict with each other and the connection may fail.
Did this article resolve the issue?