What are the disadvantages of PAGE level lock?

Answers were Sorted based on User's Feedback



What are the disadvantages of PAGE level lock?..

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

What are the disadvantages of PAGE level lock?..

Answer / thomas john

high resource utilization when large updates are to be done

Is This Answer Correct ?    2 Yes 2 No

What are the disadvantages of PAGE level lock?..

Answer / rahul

nothing

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More DB2 Interview Questions

What is host variable?

0 Answers  


What is access path in db2?

0 Answers  


What is a DBRM, PLAN ?

3 Answers  


Explain db2.

0 Answers  


Which one allows duplicate values Union or Union All ?

3 Answers  






Which are the db2 tools to protect integrity of the database?

0 Answers   IBM,


wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,


Where could you look if you had a question about whether a column has been defined as an index?

2 Answers  


what is SMP/E? and what are the major steps of it? thanks...

1 Answers   IBM,


How do you stop a db2 database in linux?

0 Answers  


Explain various types of locks in db2?

0 Answers  


What keyword does an SQL SELECT statement use for a string search?

2 Answers  


Categories