For Read Stability locks are not applicable for phantoms,
What is Phantoms?
- 2 Answers
- 5627 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 |
What are the contents of a dclmgen?
What does reorg do in db2?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
What is the role of schema in the db2 database?
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
What do you need to do before you do EXPLAIN ?
What is the significance of DB2 free space and what parameters control it?
What does DSNDB07 database do?
what are the bind parameters?
What is query_cache_limit?
How would one remove old reorg information from the DB2 catalog?
What is the maximum number of columns in a db2 table?
COBOL 
