Displays buffer manager locks. Each multiserver data buffer holds a buffer manager lock.

Displays a buffer manager database lock. This lock is used to determine the validity of cache contents. When a server opens a database, the value in this lock is used to determine if the cached information for the database is valid; therefore, it does not actually lock any resources.

Displays a buffer manager table lock. This lock type is the same as the buffer manager database lock, but operates on tables rather than databases.

Displays checkpoint resource locks. Each database that has online backup running holds a checkpoint resource lock on it.

Displays checkpoint resource locks for an Ingres cluster installation.

Displays configuration locks. This lock type is used when accessing a database config file. The config file holds database configuration information.

Displays a table control lock. It is requested to perform modify, modify to relocate, create index, create table, and drop SQL commands. This lock is also held by sessions reading a table with readlock=nolock set.

Displays createtable locks. Any user creating a table holds a createtable lock on that table.

Displays database locks. Any user connected to database holds a database lock on that database.

Displays locks of the type used to manage temporary table IDs. The lock value is used to store the next table id to use for temporary tables and does not actually lock any resource.

Displays event locks. This lock type is used by processes that use the locking system as a means to signal events. It does not actually lock any resource.

Displays extend locks. This lock type is used while extending (adding a new page to) a file. It prevents two processes from trying to add pages to the same file at the same time.

Displays journal locks. This lock type is used when accessing database journal files. It is held only by RCP (recovery process) and ACP (archiver process).

Displays open database resource locks. Each open database in a server holds this type of lock.

Displays page locks. Any user accessing a page in a table holds a page lock on that page.

Displays server database locks. Each database opened by a server holds a server database lock on it.

Displays server page locks. Each page touched by a server on behalf of a session in that server holds a server page lock.

Displays server table resource locks. Each table touched by a session in a server holds this type of lock.

Displays locks of the type used in conjunction with user defined abstract data types.

Displays table locks. Any user in a table holds a table lock on that table.