Deadlock occurs when transactions executing at the same time lock each other out of data that they need to complete their logical units of work. What are the four lockable units for DB2?

chpastor3

 Profile Answers by chpastor3 Questions by chpastor3

• Jun 12th, 2008

The 4 lock units are Row, Page, Table (if segmented), and Table space. Christine Pastor 

burelamanohar

• Feb 6th, 2007

Two transactions A & B enter into dthe DEADLOCK state whan a transaction A which has locked an object X , waits on an object Y locked by transaction B which itself is waiting for X.

Answer Question  Select Best Answer