ITIC - DB2 Isolation Level UR

Technote (FAQ)


Question

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.

Answer

This is an enhancement Request.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Integration Composer

Software version:

7.2

Operating system(s):

Windows

Software edition:

Edition Independent

Reference #:

1642782

Modified date:

2013-07-02

Translate my page

Machine Translation

Content navigation