What is the difference between CS and RR isolation levels?
Answer / 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 |
How do you pull up a query which was previously saved in qmf?
What is the specific need of Plan and..where are the tables in DB2 are physically saved
what's the best lock size that you could use when you create a tablespace?
what is the use of bind parameter, Replace?
What happens to the PLAN if index used by it is dropped?
How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?
How is deadlock resolved?
What DB2 Catalog column tell you when an index needs table reorganized ?
What is plan in cobol db2?
I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..
select distinct(empid),distinct(dept),name from EMP will the above query work?
What is nvl in db2?