Interested to Buy Any Domain ? << Click Here >> for more details...
For Read Stability locks are not applicable for phantoms,
What is Phantoms?
- 2 Answers
- 6299 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / prachi
In read stability,
if t1 is performing read and t2 has done some changes in
the database which has same crieteria as T1, these new
updates or rows added by t2 is called phantom, which will
not be read during the read stability lock...
| Is This Answer Correct ? | 1 Yes | 0 No |
how to fetch first 100 rows in db2
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
How would one remove old reorg information from the DB2 catalog?
can any one expalin check point with an example?
What is view db2?
How do you retrieve the data from a nullable column?
What is meant by a unit of recovery?
What is the database descriptor?
What are the rules for db2 programming?
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
When do you specify the isolation level?
COBOL 
