Connecting to IBM DB2

This applies to: Managed Dashboards, Managed Reports

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

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

See the following sections:

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.

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.

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.

See Also