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
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 reorg?
What is runstats utility in db2?
What is bind package and plan in db2?
what is a corelated subquerry?
What is dpf in db2?
What is with ur in db2?
What is the use of predicate?
How can you classify the locks in db2?
What is rct?
Define check constraint.
What is db2? Explain.
Is db2 a mainframe database?
How and when does the db2 enforces the unique key?
Who uses db2?