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 check constraint. Explain with example.
What is clone table?
What do you mean by rollback?
What is the clustering index in the db2 database?
What are the various data types available in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is lock escalation in db2?
What is a storage group (stogroup)?
What is the max length of sqlca?
How to find the number of rows in a db2 table?
What are the two types of logging in the db2 database? Explain them.
What is a buffer in memory?
What is buffer pool in the db2 database?
What is database manager in db2?
i want to maintain uniqueness on pdf without make lf??????????