While loading into db2 thru ds,Uncommitted data is readable?
Posted: Thu Oct 12, 2017 6:40 pm
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 off on connector, commit happens after RECORD COUNT number records are processed.
lets say we are making company ID 'A' to 'B' for 5000 records which are being processed in those 10 seconds.
Note : 10 seconds is a rough value considered to explain the scenario.
what happens in below scenarios :
1. Is uncommitted data is readable by a different user instantaneously which is hitting table, when they have setting in their application as TRANSACTION READ UNCOMMITTED ? or it will wait till 10 seconds are passed ?
If it is going to show instantaneously without waiting, company_id value will be A or B with in 10 seconds.
2. Is uncommitted data is readable by a different user instantaneously which is hitting table when they have setting in their application as TRANSACTION READ COMMITTED ? or it will wait till 10 seconds are passed?
If it is going to show instantaneously without waiting, company_id value will be A or B with in 10 seconds.
Though below link from IBM says the changes are not readable, i would like understand in detail. Need advise.
https://www.ibm.com/support/knowledgece ... rties.html
regards
Vijay
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 off on connector, commit happens after RECORD COUNT number records are processed.
lets say we are making company ID 'A' to 'B' for 5000 records which are being processed in those 10 seconds.
Note : 10 seconds is a rough value considered to explain the scenario.
what happens in below scenarios :
1. Is uncommitted data is readable by a different user instantaneously which is hitting table, when they have setting in their application as TRANSACTION READ UNCOMMITTED ? or it will wait till 10 seconds are passed ?
If it is going to show instantaneously without waiting, company_id value will be A or B with in 10 seconds.
2. Is uncommitted data is readable by a different user instantaneously which is hitting table when they have setting in their application as TRANSACTION READ COMMITTED ? or it will wait till 10 seconds are passed?
If it is going to show instantaneously without waiting, company_id value will be A or B with in 10 seconds.
Though below link from IBM says the changes are not readable, i would like understand in detail. Need advise.
https://www.ibm.com/support/knowledgece ... rties.html
regards
Vijay