Preparing a DB2 Connection


Setting up a working ODBC connection into a DB2 database is, in Intuitive’s experience, far more complicated than it should be. DB2 is a Unix product that seems poorly suited to Windows clients, servers and networks.

Intuitive have not been able to identify a working standalone package of ODBC drivers for DB2. They are, however, installed as part of the Express-C package which can be found here. Choose the http-based download to avoid having to install various Java components on your PC or dashboard server. The Express-C package installs the ODBC drivers alongside various client applications and a DB2 instance which can be disabled later.

Configure the DB2 client environment

This step is conducted on the local PC or dashboard server and should be carried out by someone familiar with DB2 – ideally a DBA.
The DB2 instance name to be referenced is setup using a command-line utility accessed by typing DB2 –t at the command prompt. The screenshot shows the sequence of actions required to setup the instance name, which are as follows:

1   The ‘catalog database’ command to create the service name of the remote database – in this case ‘reportsp’.

2   A mapping for the user ‘int_odbc’ is created.

3   The user ‘int_odbc’ is used to log into the remote server engine.

The end result of this process will be a service name that can be used to configure an ODBC connection.

Create the ODBC datasource

1   Create a new ODBC System DSN using any of the DB2 drivers appearing within the ODBC administrator.

2   Add the settings for the datasource created. Add the UserID and Password in use.

3   It should not be necessary to alter the advanced settings.

4   You should be able to access your ODBC datasource from the dashboard and create a connection.

Have more questions? Submit a request


Powered by Zendesk