Interested to Buy Any Domain ? << Click Here >> for more details...
For Read Stability locks are not applicable for phantoms,
What is Phantoms?
- 2 Answers
- 6349 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / santoshkumar jangamashetti
example for Phantoms:
• Transaction1 opens a cursor and reads account
information, keeping a running sum of the total balance for
the selected accounts.
• Transaction2 inserts a new account that falls
within the range of accounts being processed by
Transaction1, but the insert occurs after Transaction1 has
passed the new account.
• Transaction2 commits the insert.
• Transaction1 runs a query to sum the values to
check the accuracy of the running total. But the totals
will not match.
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / 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 |
What are catalog tables in db2?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
What is a Cartesian product?
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
difference between group clause and order clause
What is lock contention?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
why we create view.
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
Explain packages.
What is the SQL Communications Area and what are some of its key fields?
What is blu acceleration in db2?
COBOL 
