For Read Stability locks are not applicable for phantoms,
What is Phantoms?
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 ibm db2 database?
How many clustering indexes can be defined for a table?
What is the difference between plan and package in db2?
What will the DB2 optimizer do?
How to define the a field which accepts value till 99999.99 in db2
Outputs of explain are with matchcols = 0. What does this signify?
What are iseries servers?
When reorg is used?
The only place of VSAM KSDS in DB2 is?
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
How can you find out the # of rows updated after an update statement?
How can we define a table? How can we apply SEARCH ALL on it ?