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 |
What is dclgen (declaration generator)?
what is REORG? what is the use?
what's the best lock size that you could use when you create a tablespace?
What is an asychronous write?
When will you chose to run RUNSTATS?
What is an access path?
Where can you declare a cursor in a cobol-db2 program?
What is a view? Why use it?
Where are plans stored?
where will u check for sqlcode ?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
What is syscat in db2?