For Read Stability locks are not applicable for phantoms,
What is Phantoms?
Answer Posted / 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 |
Post New Answer View All Answers
Why cursor is used in db2?
What are the full forms of spufi and dclgen and why are they used?
What is db2 catalog database?
How would the varchar column remarks defined?
What is db2 plan table?
Explain about cursor stability?
What are types of indexes?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
How does coalesce work?
How to check table size in db2 sap?
What's The Percentage Free Space ?
What is cursor with hold option in db2?
what is a corelated subquerry?
What is buffer pool and list some of them?
Define check constraint.