Isolation Level
For ODBC and DB2 gateways only.
Isolation Level :
◾ Committed Read Locks are held while the data is read to avoid dirty reads. Data can be changed before the transaction ends with that connection.
◾ Dirty Read 0 Locking. Can read uncommitted or dirty data, change values in data during read process in a transaction. Least restrictive of all types.
◾ Repeatable Read Places locks on all data used in a query so that nobody can update the data. However new rows can be inserted by other users but will be available in later reads in the current transaction.
◾ Serialization Places a range lock on data set preventing other users to insert or update the rows in data set until the transaction is complete. Most restrictive of all.
Isolation Level :
◾ Committed Read Locks are held while the data is read to avoid dirty reads. Data can be changed before the transaction ends with that connection.
◾ Dirty Read 0 Locking. Can read uncommitted or dirty data, change values in data during read process in a transaction. Least restrictive of all types.
◾ Repeatable Read Places locks on all data used in a query so that nobody can update the data. However new rows can be inserted by other users but will be available in later reads in the current transaction.
◾ Serialization Places a range lock on data set preventing other users to insert or update the rows in data set until the transaction is complete. Most restrictive of all.
