OnlineInterviewQuestions

Explain various types of Locks in DB2?

devquora

devquora

Posted On: Feb 22, 2018

The lock modes in DB2 are used to determine whether one lock is compatible to another lock.

S Lock (Share): This mode allows the Lock owner and any concurrent process to read but not change the locked page or row.
U Lock (Update): This mode allows the Lock owner to read but not change the locked page. This lock mode reduces the chance of deadlocks.
X Lock (Exclusive): This mode allows the Lock owner to read or change the Locked page or row.

Related Questions

Please Login or Register to leave a response.

Never Miss an Articles from us.

Related 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..

Mention data types used in DB2 ?

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

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