Interview Questions   Tutorials   Discussions   Programs   

DB2 - What techniques will be used to avoid deadlock?




351
views
asked mar August 21, 2014 10:58 AM  

What techniques will be used to avoid deadlock?


           

1 Answers



 
answered By Mswami   0  
Below are some of the ways to avoid deadlock:

  • Minimize the lock size as much as possible.
  • Maximize the sharing of the resource by using CS or UR Isolation levels when possible.
  • Minimize the number of rows in one page for frequently used tables if you want to avoid row locksize.
  • Use CURRENTDATA( NO) to avoid acquiring locks. 
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 -351
Number of Answers -1
Last updated
3 years and 3 months ago ago

  Similar questions


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