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


Please Help Members By Posting Answers For Below Questions

How connect db2 database to datastage?

967


is it compulsory commitment control in journal?

2197


Define declaration generator (dclgen).

868


What is db2 connect?

779


What is null in db2?

744


What is isolation level in db2?

747


What is clone table?

775


can we view the access paths created by dbrm ? how ? thx

6633


How does cobol compile db2 program?

802


What is the advantage in De-normalizing tables in DB2?

930


What does a deadlock mean in DB2?

836


Mention some fields that are a part of sqlca.

770


What does sqlcabc has?

781


Explain the contention situations caused by locks?

786


What is the use of predicate?

776