What is the difference between CS and RR isolation levels?
Answer Posted / s
CS - page or row locks are released as soon as the cursor
is moved to another row or page.
RR - page or row locks are held for all accessed rows,
qualifying or not atleast until the next commit point.
Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
How connect db2 database to datastage?
is it compulsory commitment control in journal?
Define declaration generator (dclgen).
What is db2 connect?
What is null in db2?
What is isolation level in db2?
What is clone table?
can we view the access paths created by dbrm ? how ? thx
How does cobol compile db2 program?
What is the advantage in De-normalizing tables in DB2?
What does a deadlock mean in DB2?
Mention some fields that are a part of sqlca.
What does sqlcabc has?
Explain the contention situations caused by locks?
What is the use of predicate?