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
How do you find the maximum value in a column in db2?
What is a cursor in programming?
What is a trigger in the db2 database?
can we view the access paths created by dbrm ? how ? thx
What is runstats and reorg in db2?
How is a typical db2 batch pgm executed?
Which command is used to remove all rows from a table?
What is with ur in db2?
Discuss about db2 bind?
How many databases can be created inside an instance in db2 ?
What is bufferpool in db2?
What is runstats db2?
What is cascading rollback?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
Explain in brief how does db2 determine what lock-size to use?