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 are the contents of dclgen?
How to check table size in db2 sap?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is clone table?
List some fields from sqlca?
What is the role of union all and union
How can you count the number of rows from a table tab?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
How to find primary key of a table in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
What is release/acquire in bind?
Where can you declare a cursor in a cobol-db2 program?
Give the name of some fields form sqlca.
What is with ur in db2?
What's The Error Code For Unique Index Voilation?