Interested to Buy Any Domain ? << Click Here >> for more details...
For Read Stability locks are not applicable for phantoms,
What is Phantoms?
- 2 Answers
- 6211 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
Which component is responsible for db2 startup and shutdown?
When reorg is used?
Which isolation level provides highest data integrity?
List out the buffer pools in db2
What is bind and rebind in db2?
Can we insert update delete in view?
Why do we use cursor?
What is dbrm? What it contains?
What is dbrm library?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
How can you quickly find out the # of rows updated after an update statement?
How do you find the maximum value in a column in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What do you mean by commit and rollback?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
