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 the error code -803 ?
What is a db2 tablespace?
how to unload different table data into different gdg files/ vsam files.
What is runstats and reorg in db2?
How can you quickly find out the number of rows updated after an update statement?
how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example
Q3. How will you fetch duplicate values from a DB2 table?
Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
What are the isolation levels possible ?
What is role in db2?
What is filter factor?
What are the two types of logging in the db2 database? Explain them.