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

What is ibm db2 database?

547


What is innodb buffer pool?

574


How can deadlocks be resolved?

550


Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

6907


How can we retrieve the total number of records in RPG & CLLE?

209






Which components manage deadlocks in db2?

619


Define check constraint.

650


List down the data types in the db2 database.

644


Highlight all the advantages that are attached to a package.

637


What is a buffer in memory?

604


what is a corelated subquerry?

670


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2333


What is alias in db2?

585


What are the uses of db2 optimizer?

828


How can you do the explain of a dynamic sql statement?

641