In DB2, what is the difference between shared locks and exclusive locks?

Exclusive locks allow multiple transactions to modify data concurrently, but they prevent any transaction from reading the data
Exclusive locks allow only one transaction to read or modify data at a time
Shared locks allow multiple transactions to read and modify data concurrently
Shared locks allow multiple transactions to read data concurrently, but they prevent any transaction from modifying the data

Shared locks in DB2 allow multiple transactions to read data concurrently, while exclusive locks prevent other transactions from modifying data. Exclusive locks are exclusive to the transaction holding them, while shared locks can be held concurrently by multiple transactions.

Add your answer