Mention and explain the contention situations caused by locks?

devquora
devquora

Posted On: Feb 22, 2018

 

Locks play a vital role in maintaining the concurrency in the DB2 environment. Below are the contention situation caused by Locks which can degrade the DB2 performance.
  • Suspension: This situation is encountered by an application when it requests the lock that is already held by another application and cannot be shared. This suspended process temporarily stops running and resumes when all the processes that hold the conflicting lock release them.
  • Timeout: This situation is encountered by an application process when it terminates because of a suspension that exceeds the preset level. DB2 then terminates the process, issues message and returns the error codes.
  • Deadlock: This situation occurs when two or more application processes each hold locks on resources that others need and without which they cannot proceed.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    DB2 Interview Questions

    What is DB2 and what is the use of DB2 Optimizer?

    DB2 is a huge relational database management system for the MVS (Multiple Virtual storages) operating systems, where th..

    DB2 Interview Questions

    Mention data types used in DB2 ?

    The data types used in DB2 are: SMALLINT DECIMAL CHAR FLOAT INTEGER VARCHAR DATE TIME ..

    DB2 Interview Questions

    What is Buffer pool and list some of them?

    It is a reserved main storage which is to satisfy the buffer needs for one or more tablespaces or indexes. It is made u..