For Read Stability locks are not applicable for phantoms,
What is Phantoms?

Answers were Sorted based on User's Feedback



For Read Stability locks are not applicable for phantoms, What is Phantoms?..

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

For Read Stability locks are not applicable for phantoms, What is Phantoms?..

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

Post New Answer

More DB2 Interview Questions

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,


What is the purpose of using commit?

0 Answers  


What is cursor stability?

1 Answers  


Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?

1 Answers  


How to find the maximum value in a column in the db2 database?

0 Answers  






What are the various data types available in db2?

0 Answers  


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

0 Answers  


What is meant by the attachment facility?

3 Answers  


Which transaction use a command thread ?

1 Answers  


Which catalog table stores referential constraints?

1 Answers  


What is the use of DELGEN in DB2? Can we Write the program with out using it?

6 Answers   Cap Gemini,


how to resolve -805 . how to see dbrm and package not found

2 Answers   IBM,


Categories