Page lock levels

The table in this section describes the page lock levels that are displayed by OMEGAMONĀ® for Db2 PE.

Table 1. Page lock levels
Lock type Description Explanation
S Shared The lock owner and any concurrent programs might read, but not change the locked data.
U Update The lock owner can read the data, and intends to change it. Concurrent programs can acquire S locks and read the data; no other program can acquire a U lock.
X Exclusive The lock owner can read or change the locked data. No other program can acquire any lock on the data, or access the locked data at all.