The DB2 isolation levels are Cursor Stability (CS), Red Stability (RS), Repeatable Read (RR), and Uncommitted Read (UR). UR is used to get access to read-only queries and read-only tables. CS can lock or unlock currently referred rows by the cursor. RS enables the result set stability and unlocks the rows that don’t coordinate with query predictions. RR, known for higher isolation level, ensures the data’s integrity for the complete duration of the entry.
Posted Date:- 2021-09-03 02:00:44