Interested to Buy Any Domain ? << Click Here >> for more details...
For Read Stability locks are not applicable for phantoms,
What is Phantoms?
- 2 Answers
- 6327 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
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is null indicator in db2?
What is dclgen (declaration generator)?
What is the usage of open cursor command?
What is ibm db2 connect?
Why cursor is used in db2?
How to connect to db2 database from windows command line?
What is db2 connect?
How to take backup of table in db2?
What is the syntax for creating a table in the db2 database?
What are the contents of dclgen?
What does db2 mean?
What is the purpose of using commit?
What is a system catalog table in db2?
Explain db2.
