How many types of page locks can be held in DB2?

by

Three types of page locks can be held in DB2:

  • Exclusive
  • Update
  • Share

In IBM DB2, there are two main types of page locks:

  1. Intent Page Locks (IPLs): These locks are acquired on a page to indicate the intent of a transaction to acquire locks on lower-level resources, such as row or table locks. Intent page locks are used to coordinate lock activities at different levels of granularity.
  2. Exclusive Page Locks: These locks are acquired when a transaction wants exclusive access to a page, preventing other transactions from obtaining any type of lock on the same page.

So, the correct answer to the question “How many types of page locks can be held in DB2?” is generally two: Intent Page Locks and Exclusive Page Locks.