Is it possible to set the database connection to use uncommitted reads so it doesn’t cause read locks?
Please, try one of the following query strings in the JDBC Reader step
The first query:
SET TRANSACTION ISOLATION LEVEL
select column_name from table_name
The second query:
select column_name from table_name with (READUNCOMMITTED)
We assume that you may need to setup the uncommitted read availability on the database side, as well.