For Read Stability locks are not applicable for phantoms,
What is Phantoms?
- 2 Answers
- 5434 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 the difference between oracle and db2?
What is a trigger in the db2 database?
What are union and union all?
Explain package in db2 and its advantages?
What is db2 and what is the use of db2 optimizer?
What is an instance database?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
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 is check constraint in db2?
What is the latest version of ibm db2?
What is reorg?
What is dbrm in db2 database?
What is release/acquire in bind?
What is sqlca?
How to get the ddl of a table in db2?
