KNOWLEDGE BASE

"An Error occurred while communicating with IBM DB2 Database" Error


Published: 18 Jun 2013
Last Modified Date: 18 Oct 2017

Issue

When trying to connect to an IBM DB2 database from Tableau Desktop, the connection times out with the following error message:
 
An error occured while communicating with IBM DB2 Database.
Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.
DB2 database error: 0x80004005: SQL3008IN A communication error has been detected.
Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "<ip-address>". Communication function detecting the error: "selectForConnectTimeout". Protocol specific error code(s): "0","*","*", SQLSTATE=8001

Environment

  • Tableau Desktop 
  • IBM DB2 on iSeries platform

Resolution

  •  Connect to DB2 using the generic ODBC connection (Other Databases (ODBC))While it may be possible to connect to DB2 using the generic ODBC data connection, success often varies and full compatibility with Tableau features cannot be guaranteed. For more information about the capabilities and limitations of connecting to unsupported data sources via generic ODBC connections, see the following articles: 
  • Mirror the data source onto a supported data source. When working with DB2 data sources on the iSeries platform, mirror the data source onto a supported data source like pSeries or xSeries platforms, and then connect to the database using the native DB2 data connection.

Cause

Connecting to IBM DB2 is not supported on iSeries platforms.
Did this article resolve the issue?