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 db2 catalog database?
if i made sme changes in sub pgm wht r the things to be done for this ?
Can we insert update delete in view?
What is runstats and reorg in db2?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
what is the name of the default db2 catalog database?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What are concurrency issues?
wht displays the number of times a query modified ?
What is index cardinality?
What is a plan and package in db2?