KNOWLEDGE BASE

Refresh Extracts Failing Against IBM DB2 Data Sources


Published: 24 Feb 2020
Last Modified Date: 25 Feb 2020

Issue

Extract refresh of IBM DB2 data source connection failing with error:

com.tableausoftware.nativeapi.exceptions.DataSourceException: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.50000"? Unable to connect to the IBM DB2 server "DB2-HOSTNAME". Check that the server is running and that you have access privileges to the requested database

Environment

  • Tableau Server
  • Linux RHEL
  • DB2

Resolution

Re-install the downloaded DB2 OBC driver from https://www.tableau.com/support/drivers as per instructions.

For example:

sudo tar -C /opt/db2 -xzvf ~/Downloads/v11.1.3fp3a_linuxx64_odbc_cli.tar.gz

Cause

IBM DB2 ODBC driver was not installed properly. It was extracted to a temporary location before being copied to the installed location e.g. /opt/db2 resulting in mismatch of ownership and permissions of the installed directory structure compared to what is expected in the tar file e.g. v11.1.3fp3a_linuxx64_odbc_cli.tar.gz. This resulted in permission denied on the lib directory e.g. /opt/db2/odbc_cli/clidriver/lib.
Did this article resolve the issue?