2 Replies Latest reply on Nov 3, 2015 7:19 PM by ImbarajAnpalgan

    My source and target both are DB2 table. I have faced a deadlock issue, but resolved it by adding a 'with UR' clause.

    New Member

      I have a deadlock issue. I found that the default sql query generated in Source qualifier has caused a lock on DB2 table. Now i added a sql override with 'with UR' (Un committed read) clause. It has fixed the issue. My concern can this cause any other issue as I am performing a dirty read on DB2 table(Which is my source and target).