Interested to Buy Any Domain ? << Click Here >> for more details...
For Read Stability locks are not applicable for phantoms,
What is Phantoms?
- 2 Answers
- 6337 Views
- I also Faced
- E-Mail Answers
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
What is cloudant database?
What is table space in db2?
What is buffer pool in the db2 database?
Where do you specify them?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
How to access db2 tables in mainframe?
What is plan in cobol db2?
How to compare data between two tables in db2?
Define predicate?
How to take backup of table in db2?
What is a dbrm in db2?
Is it possible using max on a char column?
What is the result of open cursor statement?
Explain in detail about buffer manager and its functionalities?
How can record locking be achieved in those DB2 versions which do not support it?
