What is the difference between CS and RR isolation levels?



What is the difference between CS and RR isolation levels?..

Answer / 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

More DB2 Interview Questions

what is diffrence b/w file-aid tool and file-aid utility???

1 Answers  


What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

3 Answers   Cap Gemini,


Bind concepts in DB2 cobol

10 Answers   IBM, TCS, TRD, Virtusa,


What is commit in db2?

0 Answers  


What does runstats do in db2?

0 Answers  


What is -904 sql code? How to resolve it?

3 Answers  


What is null in db2?

0 Answers  


What do the initials DDL and DML stand for and what is their meaning?

2 Answers  


select 100 records from million records ?

2 Answers   Verizon,


What is package in db2 mainframe?

0 Answers  


wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,


What r the comman abends in db2, jcl and cobol???????

0 Answers   Mphasis,


Categories