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
What is the use of value function?
When reorg is used?
What is the use of dclgen in db2?
What is a db2 table?
What is clone table?
Which isolation level provides maximum concurrency?
What is db2 purescale?
Name the various locking levels available?
What is the physical storage length of timestamp data type?
What is a db2 package?
How do I optimize a query in db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is the default page size of buffer pools?
Define check constraint.
What is database alias db2?