Mention and explain the contention situations caused by locks?

Question Posted / prakasha m

Mention and explain the contention situations caused by locks?..

Lock Contention can lead to:
1. Suspension
2. Timeout
3. Deadlock

Is This Answer Correct ?

0 Yes

0 No

More DB2 Interview Questions

Where is the access path logic created by the DB2 Optimizer stored?

How to restart a DB2 program?

What else is there in the PLAN apart from the access path?

What is the usage of open cursor command?

How does cobol compile db2 program?

Why db2 is called db2?

What is a synonym ?

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

Can you search give an array in the WHERE clause of a db2 query?

What is the logical entity between plan and Package?

How do you pull up a query which was previously saved in qmf?

How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.

For more DB2 Interview Questions Click Here