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: defaultIsolationLevel=1;
DB2 Isolation Level Options:
defaultIsolationLevel=1;
- TRANSACTION_READ_UNCOMMITTED (UR)
defaultIsolationLevel=2;
- TRANSACTION_READ_COMMITTED (CS)
defaultIsolationLevel=4;
- TRANSACTION_REPEATABLE_READ (RS)
defaultIsolationLevel=8;
- TRANSACTION_SERIALIZABLE (RR)
Related Information
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21666073