Connecting to IBM DB2

Contents[Hide]

1. Overview

This article provides additional details on connecting to an IBM DB2 database.

Important
IBM DB2 does not support concurrent use of ODBC and .NET providers from the same application. To avoid issues, make sure that you consistently connect to a DB2 server using the same data provider in your data connectors.

Main article: Connect to data and view it on a dashboard

2. Install the driver

With Dundas BI version 9 or earlier installed on Windows, you need to download the IBM Data Server Package (DS Driver) and install it on that computer before you can connect to the DB2 database. (Application users do not need to install the driver.)

In certain cases, such as installing or upgrading the .NET framework after installing the DB2 database, you may have to manually register the DB2.NET provider. To do so, open command prompt as an administrator, navigate to the driver bin folder (for example C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin) and execute the following command:

db2lswtchcli.exe -client -promote

For more details on required drivers for connecting to DB2 in each environment, see Dundas BI - System Requirements for your version of Dundas BI.

3. Data connector settings

Create a new data connector and set Data Provider dropdown to IBM DB2 Database.

Provide credentials, and the Server and the Database name.

Create a new data connector for IBM DB2 Database
Create a new data connector for IBM DB2 Database

There are various other settings supported by DB2 that you can configure in each expandable section below. Hover over (or long-tap) a setting to see a tooltip description.

Tip
Click to expand Initialization to find the Isolation Level, which can be set to Read Uncommitted when appropriate for better performance in high concurrency scenarios.

4. Notes

  • The IBM DB2 data provider may not be able to connect to certain versions of DB2 such as AS/400. ODBC or JDBC drivers can be used instead.

5. See also

 

Dundas Data Visualization, Inc.
400-15 Gervais Drive
Toronto, ON, Canada
M3C 1Y8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri