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 DB2 using the same type of data connector.

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

2. Install the driver

In order to connect to the DB2 database when running Dundas BI on a Windows server, you need to download the IBM Data Server Package (DS Driver) and install it on the server.

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 a list of supported environments and required drivers for connecting to DB2, 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.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

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