Interview Questions   Tutorials   Discussions   Programs   

DB2 - What are the disadvantages of PAGE level lock?




355
views
asked mar September 2, 2014 12:47 PM  

What are the disadvantages of PAGE level lock?


           

1 Answers



 
answered By Mswami   0  
High resource utilization if large updates are to be done.

It will hold the resources locked in the page. Others will not able to update the data in the row.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview

 Write A Tutorials
Online-Classroom Classes
www.writeabc.com


  1 person following this question

  1 person following this tag

  Question tags

Asked 2 years and 3 months ago ago
Number of Views -355
Number of Answers -1
Last updated
3 years and 3 months ago ago

Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert