For Read Stability locks are not applicable for phantoms,
What is Phantoms?
Answer Posted / 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 View All Answers
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is access path in db2?
What is the role of schema in the db2 database?
What is buffer pool and list some of them?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
How to execute stored procedures?
What is the difference between nvl and coalesce?
What is scrollable cursor in db2?
What is bind plan?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is the maximum length of sqlca?
What do you mean by cursor?
What is the usage of open cursor command?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is the difference between using bind () and rebind () methods of naming class?