Interested to Buy Any Domain ? << Click Here >> for more details...
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
How do I create a view in db2?
Is schema the same as database?
What are packages in db2?
Why cursor is used in db2?
Is ibm db2 open source?
What is database alias db2?
What is universal database?
Highlight all the advantages that are attached to a package.
What are the prerogatives?
is it compulsory commitment control in journal?
How can the duplicate values be eliminated from db2 select?
What r the comman abends in db2, jcl and cobol???????
How to resolve deadlock issue
How does cobol compile db2 program?
Explain the function done by data manager?
