What are Isolation level in Connection Pool Setting ??
They are applicable for ODBC and DB2 gateways only.
The Level options:
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.
No comments:
Post a Comment