What are the disadvantages of PAGE level lock?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between alias and synonym in db2?

645


What is rct?

753


What is null value in db2?

567


How is the value function used?

606


What do you mean by cursor?

586






How do I start db2 in windows?

567


What is the difference between drop table and delete table?

556


When do you specify the isolation level?

611


Is schema the same as database?

632


What is dbrm? What it contains? When it will be created?

595


Explain the contents that are a part of dclgen.

661


What is dbrm? When it will be created?

602


What are the 2 sqlcodes that are returned?

643


What is db2 purescale?

551


Is db2 a mainframe database?

569