What is meant by repeatable read?
Answers were Sorted based on User's Feedback
Answer / guest
The qualifying rows under Repeatable read will ensure that
no rows will be changed or added for the duration of the
lock.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Answer / kumar
It is the highest level of isolation parameter. I will hold
the entire table till the completion of the transaction or
job. Others can not access that thable
Is This Answer Correct ? | 1 Yes | 2 No |
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
Mention some fields that are a part of sqlca.
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
What is the maximum number of columns in a db2 table?
What is multi row fetch in db2?
Explain how can you do the explain of a dynamic sql statement?
What does db2 blu stand for?
Can any one tell me about Restart logic in DB2.
Where is the output of EXPLAIN stored?
What is null in db2?
Can a Db2 table data be retrived through JCL?
What are some characteristics of columns that benefit from indexes?