Was this helpful?
Resource Type--Display Specific Resource
The following resource types can be specified on the -l flag on the ipm command. These options affect only the Resource List Display:
buffermgr
Displays buffer manager locks. Each multiserver data buffer holds a buffer manager lock.
bufmgrdb
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.
bufmgrtable
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.
checkpoint
Displays checkpoint resource locks. Each database that has online backup running holds a checkpoint resource lock on it.
ckpcluster
Displays checkpoint resource locks for an Ingres cluster installation.
config
Displays configuration locks. This lock type is used when accessing a database config file. The config file holds database configuration information.
control
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.
createtable
Displays createtable locks. Any user creating a table holds a createtable lock on that table.
database
Displays database locks. Any user connected to database holds a database lock on that database.
dbtblid
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.
event
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.
extend
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.
journal
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).
opendb
Displays open database resource locks. Each open database in a server holds this type of lock.
page
Displays page locks. Any user accessing a page in a table holds a page lock on that page.
svdatabase
Displays server database locks. Each database opened by a server holds a server database lock on it.
svpage
Displays server page locks. Each page touched by a server on behalf of a session in that server holds a server page lock.
svtable
Displays server table resource locks. Each table touched by a session in a server holds this type of lock.
syscontrol
Displays locks of the type used in conjunction with user defined abstract data types.
table
Displays table locks. Any user in a table holds a table lock on that table.
Last modified date: 01/30/2023