What are the disadvantages of PAGE level lock?
Answers were Sorted based on User's Feedback
Answer / s
Less concurrency. Lock contention occurs when an
application program is trying to acquire a lock that is
already held by another program.
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / thomas john
high resource utilization when large updates are to be done
Is This Answer Correct ? | 2 Yes | 2 No |
What is host variable?
What is access path in db2?
What is a DBRM, PLAN ?
Explain db2.
Which one allows duplicate values Union or Union All ?
Which are the db2 tools to protect integrity of the database?
wht steps we need will coding cobol and db2 pgm ?
Where could you look if you had a question about whether a column has been defined as an index?
what is SMP/E? and what are the major steps of it? thanks...
How do you stop a db2 database in linux?
Explain various types of locks in db2?
What keyword does an SQL SELECT statement use for a string search?