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 the sqlcode -501
How do I add a column to a table in db2?
What is the purpose of rollback and commit?
What is the difference between db2 and oracle?
What is the max length of sqlca?
What is runstats and reorg in db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What does db2 blu stand for?
Define db2 and its databases?
What is the role of the data page in the db2 database?
What is the function of logging in the db2 database?
What is dbrm? What it contains? When it will be created?
Give the name of some fields form sqlca.
What is blu acceleration in db2?
Explain about dbrm.