3 Replies Latest reply on Nov 11, 2015 6:25 AM by nheinze

    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).