DB2 Connector - Cursor Stability vs Read Uncommitted

[Raftsman]

We have had a few issues regarding the isolation level for DB2. We currently contain our source and targets in different schemas. We never read and write to the same table in the same schema.

Currently, all of our jobs are defaulted to Cursor Stability. For some reason, we have been getting contention and locks during our reads.

Since we have warehouse structured with different schemas, should we change the default from CS to Read Uncommitted to avoid this issue?

Has anyone ever had this issue?

Secondly, we are moving towards CDC, is CS preferable in this situation?

Thanks