For Read Stability locks are not applicable for phantoms,
What is Phantoms?
Answer Posted / prachi
In read stability,
if t1 is performing read and t2 has done some changes in
the database which has same crieteria as T1, these new
updates or rows added by t2 is called phantom, which will
not be read during the read stability lock...
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do I delete a table in db2?
What does sqlcabc has?
Mention the location where the output received from explain statement is stored.
Is it possible using max on a char column?
Which isolation level provides highest data integrity?
Can there be more than one cursor open for any program?
How do I add a column in db2?
When reorg is used?
How can you find out the # of rows updated after an update statement?
Define db2 and its databases?
What is host variable in db2 cobol?
Where do you specify them?
What are the contents of a dclmgen?
Highlight all the advantages that are attached to a package.
What is an instance in db2?