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

how to fetch multiple records without using cursor

14 Answers   HCL,


why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2

3 Answers  


What is a storage group (stogroup)?

0 Answers  


wt is view ? wht r the restrictions for view ?

3 Answers   Verizon,


can any one expalin check point with an example?

1 Answers  






How to connect to db2 database from windows command line?

0 Answers  


What is the function of the Data Manager?

2 Answers  


Can you tell me how can you find out the # of rows updated after an update statement?

0 Answers  


wht is d/f between union and joins ?

2 Answers  


Define predicate?

0 Answers  


How to update more then one record using update?

5 Answers   IBM,


What is db2 plan table?

0 Answers  


Categories