For Read Stability locks are not applicable for phantoms,
What is Phantoms?
- 2 Answers
- 5629 Views
- I also Faced
- E-Mail Answers
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
What r the comman abends in db2, jcl and cobol???????
Explain the function of data manager.
What is cursor in dbms?
How do I delete a column in db2?
What is a storage group (stogroup)?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
Which component is responsible for db2 startup and shutdown?
What is buffer pool and list some of them?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is an instance database?
How would you find out the total number of rows in a db2 table?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
How to compare data between two tables in db2?
How to find the number of rows in a db2 table?
What is dclgen (declaration generator)?
