Interview Questions   Tutorials   Discussions   Programs   

DB2 - What techniques will be used to avoid deadlock?

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. 
   add comment

Your answer

Join with account you already have



 Write A Tutorials
Online-Classroom Classes

  1 person following this question

  1 person following this tag

  Question tags

Asked 1 year and 1 month ago ago
Number of Views -242
Number of Answers -1
Last updated
2 years and 2 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!