Search found 2 matches

by vjlegendrocks
Sun Oct 15, 2017 8:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: While loading into db2 thru ds,Uncommitted data is readable?
Replies: 3
Views: 2269

Hi, So, it means that other users cannot see uncommitted changes till transaction is committed by Datastage job with "Cursor Stability" option, irrespective of reading mode( Read uncommitted/ Read committed) they use in their program/query. However the data which is being updated by Datast...
by vjlegendrocks
Thu Oct 12, 2017 6:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: While loading into db2 thru ds,Uncommitted data is readable?
Replies: 3
Views: 2269

While loading into db2 thru ds,Uncommitted data is readable?

database :db2 datastage loading setting through Db2 connector: Cursor stability Q: while updating table, data which is not committed ( uncommitted ), lets say 30000 records are still not committed to table, this transaction has taken 10 seconds to commit by Datastage as we know when auto commit is o...