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
Define db2.
What is runstats db2?
How to take backup of table in db2?
Why select is not preferred in embedded sql programs?
What is explain plan in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
How to find primary key of a table in db2?
How does a cursor work?
How does cobol compile db2 program?
Define check constraint.
What is db2 connect?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What does db2 stand for?
What is difference between alias and synonym in db2?
What is sqlca?