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
What is ibm db2 database?
What is innodb buffer pool?
How can deadlocks be resolved?
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?
How can we retrieve the total number of records in RPG & CLLE?
Which components manage deadlocks in db2?
Define check constraint.
List down the data types in the db2 database.
Highlight all the advantages that are attached to a package.
What is a buffer in memory?
what is a corelated subquerry?
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.
What is alias in db2?
What are the uses of db2 optimizer?
How can you do the explain of a dynamic sql statement?