Lock types

The table in this section describes the lock types that are displayed by OMEGAMON® XE for Db2 PE.

Table 1. Lock types
Lock type Description
ACSC The Accelerator Services commands (ACSC) lock.
ALBP The Alter buffer pool (ALBP) lock indicates a lock on a buffer pool during execution of an ALTER BUFFERPOOL command.
BIND The BIND lock indicates an autobind or remote bind lock.
BMBA The Buffer manager SCA MBA (BMBA) L-lock.

The Buffer Manager (BM) gets this lock when it needs to read, insert, or update a multiple buffer pool (MBA) record in a Shared Communications Area (SCA).

(BMC_MBAO or BMC_MBAR)
BPPS The Buffer Manager Pageset (BPPS) RR (repeatable read) P-lock:
  • BP = buffer pool ID
  • DB = database name
  • PS = pageset name
CCAT The CATMAINT convert catalog (CCAT) lock is acquired when catalog conversion is performed.
CDBL The Compress dictionary build (CDBL) lock.
CDIR The CATMAINT convert directory (CDIR) lock is acquired when directory conversion is performed.
CDRN The Cursor Stability drain (CDRN) lock is acquired to drain all CS read access to an object:
  • DB = database name
  • PS = pageset name
  • PT = partition
CMDS The Db2 Command Serialization (CMDS) lock.
CMIG The CATMAINT migration (CMIG) lock is acquired when catalog migration is performed.
COLL The Collection (COLL) lock
DBDL The DBD load (DBDL) lock is the database descriptor load lock.
DBEX The Database exception (DBEX) lock indicates a lock on a "Logical page list" (LPL) or "Group buffer pool recovery pending" (GRECP) database exception status.

This lock is only used in a data sharing environment.
DBXU The DB exception update lock is used for updating the database exception status.
DGTT The DGTT URID lock is acquired to protect segments that belong to a Declared Global Temporary Table (DGTT). These segments are deallocated during Commit 1 by logging them and serializing them using the Unit of Recovery ID (URID) lock.
DPAG The Db2 page (DPAG) lock in a tablespace. When programs read data or update data, they acquire a page lock containing the data.
  • DB = database name
  • PS = pageset name
  • PG = page
DSET The partitioned lock.

A partitioned tablespace contains one or more partitions (up to 64). It is created when you create a table space using the SQL CREATE TABLESPACE statement with the NUMPARTS parameter.

Only one table can be stored on a partitioned tablespace. Each partition contains one part of a table. The partitioned lock only locks the partition with the data that is referenced.

  • DB = database name
  • PS = pageset name
  • PT = partition number
DTBS The Database lock indicates a lock on the database.
  • DB = database name
  • PS = pageset name
  • PT = partition number
GRBP The Group buffer pool (GRBP) start/stop lock.

BP=buffer pool ID
HASH The Hash anchor (HASH) lock.
  • DB = database name
  • PS = pageset name
  • PG = page
HPSP The Header Page (HP) Bucket or Stored Procedure (SP) Command lock.
IEOF The Index end of file (IEOF) lock is acquired at the index end of file.
  • DB = database name
  • PS = pageset name
  • PT = partition
IPAG The Index page (IPAG) lock in an index space. When application programs read or update data, they acquire a lock on the page containing the index when indexing is used.
  • DB = database name
  • PS = pageset name
  • PG = page
IXKY The Index key (IXKY) lock.
LBLK The Large object (LOB) lock.
LPLR The Logical page list recovery (LPLR) lock.
MDEL The Mass delete (MDEL) lock is acquired when doing a mass delete from a table (for example, when you DELETE FROM a table) within a segmented tablespace.

It is used to prevent another user from reusing freed segments before a delete operation is committed.

  • DB = database name
  • PS = pageset name
PALK The Partition lock.
  • DB = database name
  • PS = pageset name
  • PT = partition
PBPC The Group BP level castout (PBPC) P-lock.

A physical lock acquired when a castout of a group buffer pool occurs. Castout is the process of writing pages in the group buffer pool out to DASD.

This lock is only used in a data sharing environment.
PCDB The DDF CDB P-lock.

A Distributed Data Facility communication database physical lock.

This lock is only used in a data sharing environment.
PDBD The DBD P-lock is a database descriptor physical lock.

This lock is only used in a data sharing environment.
PDSO The Pageset or partitioned pageset open lock.

If the data set supporting the tablespace that is referenced by the application is not opened, the program will acquire a lock to open the data set. The data set will stay open if CLOSE=NO is defined in the SQL statement creating the tablespace.

  • DB = database name
  • PS = pageset name
PITR The Index manager tree (PITR) is a physical lock (P-lock).

This lock is only used in a data sharing environment.

  • DB = database name
  • PS = pageset name
  • PT = partition
PPAG The Page P-lock is a physical lock on a page.

This lock is only used in a data sharing environment.
PPSC The Pageset/partition level castout physical lock (P-lock).

This lock is only used in a data sharing environment.
PPSP The Pageset/partition physical lock (P-lock).

This lock is only used in a data sharing environment.
PRLF The Resource Limit Facility (RLF) physical lock (P-lock).

This lock is only used in a data sharing environment.
PSET The Pageset (PSET) lock can be a tablespace or indexspace.

A pageset containing Db2 tables is a tablespace. A pageset containing Db2 index structure is an indexspace.

A pageset can be simple or partitioned. This lock type is for the simple pageset only.

  • DB = database name
  • PS = pageset name
PSPI The Pageset piece (PSPI) lock.

A pageset is a collection of pageset pieces. Each pageset piece is a separate VSAM data set.

A simple pageset contains from 1 to 32 pieces. Each piece of a simple pageset is limited to 2 GB. Whenever a simple pageset piece reaches this size, another piece is allocated and the pageset grows.

This is a lock on the expanded pageset piece.
RDBD The Repair DBD (RDBD) lock is acquired when REPAIR DBD REBUILD is running (test/ diagnose).
RDRN The Repeatable Read drain (RDRN) lock is acquired to drain all RR access to an object.
  • DB = database name
  • PS = pageset name
  • PT = partition
RGDA The Retry Getpage During Abort (RGDA) lock.
ROW The Row lock indicates a lock on a row.
RSTR The Shared Communications Area (SCA) restart (RSTR) lock indicates a lock on SCA access for restart/redo information.

(BMC-RSTP)
SDBA The Start/stop lock on DBA (SDBA) table indicates a lock on the table, tablespace, or database when a CREATE/DROP is processed against these objects.
  • DB = database name
  • PS = pageset name
SENV The System environment (SYSENV) serialization lock.
SKCT The Skeleton cursor table (SKCT) lock indicates a lock on the application plan.

PLAN=plan name
SKPT The Skeleton package table (SKPT) lock indicates a lock on the application package.

TOKEN= the consistency token (CONTOKEN) column from SYSIBM.SYSPACKAGE.
SPRC The System level point in time (PIT) recovery lock.

SYS_PITR
SREC The Log range lock.

Db2 writes a record in the log range tablespace (SYSLGRNG) every time a tablespace is opened and updated, and updates SYSLGRNG whenever that tablespace is closed.

The record contains the opening and/or closing log RBA (relative byte address) for the tablespace. When Db2 writes to SYSLGRNG, the program acquires a lock on the tablespace with updates.

  • DB = database name
  • TS = tablespace name
TABL The Table (TABL) lock on the table which resides in a segmented tablespace.
  • DBID = DBid
  • TABL = Tableid
UIDA The Util I/O Damage Assessment lock.
UNDT The Undetermined (UNDT) lock indicates that this lock cannot be determined because it is not part of the other listed lock types.

Resource ID (in hexadecimal).
UNKN The Unknown (UNKN) lock indicates the resource does not exist.
UTEX The Utility exclusive execution (UTEX) lock.

UTEXEC
UTID The Utility identifier (UTID) lock.

UID=utility id
UTOB The Utility object (UTOB) lock.
  • DB = database name
  • PS = pageset name
  • PT = partition
UTSE The Utility serialization (UTSE) lock is required when running utility jobs.

UTSERIAL
WDRN The Write drain (WDRN) lock is acquired to drain all write access to an object.
  • DB = database name
  • PS = pageset name
  • PT = partition
XMLK The XML lock.