ITIC - DB2 Isolation Level UR

Technote (FAQ)


Current ITIC connections to DB2 databases do not use Isolation Level UR. This can cause DB2 Locks which of course cause issues with other applications and clients using the same database.

In our particular case, we have ITIC connecting to a replica database, and ITIC caused locks prevent successful replication from the primary database.

I'm requesting an ITIC hotfix to always call "SET CURRENT ISOLATION UR" immediately after a connection is made to a DB2 database and prior to any select statements.


This is an enhancement Request.

Rate this page:

(0 users)Average rating

Add comments

Document information

More support for:

Tivoli Integration Composer

Software version:


Operating system(s):


Software edition:

Edition Independent

Reference #:


Modified date:


Translate my page

Machine Translation

Content navigation