GeekInterview.com
Series: Subject: Topic:
Question: 163 of 207

What is deadlock?

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?
Asked by: Interview Candidate | Asked on: Oct 13th, 2004
Showing Answers 1 - 2 of 2 Answers
burelamanohar

Answered On : 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.

  
Login to rate this answer.
chpastor3

Answered On : Jun 12th, 2008

View all answers by chpastor3

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

Christine Pastor 

Yes  1 User has rated as useful.
  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.