IBM Support

How to set Isolation Level for DB2 JDBC database connections

Troubleshooting


Problem

By default JDBC database connections do not implement Isolation Level settings. http://pic.dhe.ibm.com/infocenter/cbi/v10r2m1/index.jsp?topic=%2Fcom.ib…

Environment

Cognos 10.2.1

DB2 JDBC

Resolving The Problem

Specify JDBC Connection parameters in the properties of the DB2 database connection.

Steps:

1. In Cognos Administration go to the the Configuration tab, Data Source Connections

2. Click the DB2 Data Source

3. Click the Properties button for the DB2 Connection, click the Connection tab

4. Click the Edit button for the Connection string and click the JDBC tab

5. Specify the JDBC Connection Parameters to include Isolation Level Setting

Example: defaultIso​lationLe​vel=1;

DB2 Isolation Level Options:


defaultIso​lationLe​vel=1;
- TRANSACTION_READ_UNCOMMITTED (UR)

defaultIso​lationLe​vel=2;
- TRANSACTION_READ_COMMITTED (CS)

defaultIso​lationLe​vel=4;
- TRANSACTION_REPEATABLE_READ (RS)

defaultIso​lationLe​vel=8;
- TRANSACTION_SERIALIZABLE (RR)

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Cognos Administration","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.1.1;10.2;10.2.1;10.2.1.1;10.2.2","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21666073

Page Feedback