Answer Posted / sf
In RR isolation level, all the pages fetched in the cursor
are locked till end of transaction. This is the safest way
to ensure that no concurrent update happened when the
cursor was actiong on this data.
The confusion would be on CS . In CS only the page having
the relevant data would be locked. As the page size is 4k ,
we may lock more than one row of a table based on row size
and table space organization.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is null indicator in cobol db2?
Explain about rct.
How to run db2 command in windows?
What is null value in db2?
How to connect to db2 database from windows command line?
What is db2 command?
What are the prerogatives?
Differentiate between cs and rr isolation levels? Where do you specify them?
Comment whether the cursor is closed during commit or not.
What is consistency token in db2?
What is cursor in dbms?
What is bufferpool in db2?
How do I add a column in db2?
What is load replace in db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
