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
What is db2 bind?
How is the value function used?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is buffer pool?
What is db2 and what is the use of db2 optimizer?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How to run db2 command in windows?
Is db2 a database?
What is bufferpool in db2?
Explain the function of data manager.
What is the role of schema in the db2 database?
What is a db2 collection?
What is role in db2?
Explain about mirror activator disk mirroring?
What is check constraint. Explain with example.
