Interested to Buy Any Domain ? << Click Here >> for more details...
For Read Stability locks are not applicable for phantoms,
What is Phantoms?
- 2 Answers
- 6249 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 is a SELECT statement?
What is meant by dclgen?
How to resolve -917 sql code in DB2?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
How to test SQL -911 error while developing COB-DB2 program
What is the difference between Where and Having Clause
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
What happens to a cursor after a commit?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
How would you print the output of an SQL statement from SPUFI?
What is the difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
COBOL 
