Give a brief description of DB2 Isolation Levels?

• It is good for accessing read-only tables and read-only queries.
• No record Locking is done.

CS- Cursor Stability:

• It is a default isolation level.
• It locks or unlocks each row at a time.
• It guarantees to return only data which was committed at the time of reading.

RS- Read Stability:

• It releases Locks on rows that do not satisfy the query predicates.
• It is used for result set stability or when the future actions on returned rows may be taken.

RR- Repeatable Read:

• It allows the application to retrieve and operate on rows as many times as needed.
• It locks the entire table.