For Read Stability locks are not applicable for phantoms,
What is Phantoms?
- 2 Answers
- 5628 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
Explain various types of locks in db2?
What is null indicator in db2?
Mention the various locks that are available in db2.
What does db2 mean?
Mention some fields that are a part of sqlca.
How to find schema of a table in db2?
Who uses db2?
How will you return the number of records in table?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
How do I create a view in db2?
How to test SQL -911 error while developing COB-DB2 program
Explain about rct in db2?
Can we insert update delete in view?
What is the maximum number of columns in a db2 table?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
