(v24) Connecting to IBM DB2

Connecting to IBM DB2

Connecting in Managed Dashboards and Managed Reports

This applies to: Managed Dashboards, Managed Reports

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

Note: 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.

Data Connector Settings

Create a new data connector and set Data Provider drop-down to IBM DB2 Database.

Provide credentials, and the Server and the Database name.

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.

Note: 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.

Note: 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.

For more information, see:

• Connect to Data and View it on a Dashboard