What Are The Informix Isolation Levels And Can You Explain Each One ?

1.	What Are The Informix Isolation Levels And Can You Explain Each One ?
Answer» DIRTY READ: Reads the DATA without checking if it’s COMMITTED or not. No LOCKS are held during the read COMMITTED READ: Reads only the committed data. No locks held REPEATABLE READ: Reads only the committed data. A shared lock is held on the rows. Other sessions can obtain shared locks on those rows, but no ONE can get an exclusive lock. CURSOR STABILITY

Answer»

DIRTY READ: Reads the DATA without checking if it’s COMMITTED or not. No LOCKS are held during the read
COMMITTED READ: Reads only the committed data. No locks held
REPEATABLE READ: Reads only the committed data. A shared lock is held on the rows. Other sessions can obtain shared locks on those rows, but no ONE can get an exclusive lock.
CURSOR STABILITY

Discussion