Thread Locks Owned Attributes

Use Thread Locks Owned attributes to view detailed information about all the locks and claims owned by an individual thread.

AGNT ASID The address space ID (ASID) of the agent.

Authorization ID The authorization ID.

Authorization ID (Unicode) The primary authorization ID from connection or sign-on that identifies the execution privileges an application has to a DB2 object or service. It is an alphanumeric text string with a maximum of 128 characters.

Claim Class The type of claim class. Possible claim classes are:

CS: Cursor stability
RR: Repeatable read
Write: Write access

Claim Type The type of object that is claimed. Possible claim types are:

TS: Tablespace
TS LPRT: Tablespace logical partition
TS PART: Tablespace partition
IX: Index space
IX LPRT: Index space logical partition
IX PART: Index partition

Collection ID (Unicode) The collection ID. This field is blank for DBRM. It is an alphanumeric text string, with a maximum of 128 characters.

Thread Locks Owned Attributes Connection ID. Identifies the connection of an application to a DB2 system.

It is an alphanumeric text string, with a maximum length of eight characters.

Thread Locks Owned Attributes The type of connection associated with the thread.

Valid values are:

Value	Description
BATCH	Batch job
CICS	CICS attach
DLIBATCH	DL/I batch
Distributed	Distributed Database Access thread
IMS_BMP	IMS attach BMP
IMS_CTL	IMS control region
IMS_MPP	IMS attach MPP
IMS_TBMP	IMS transaction BMP
DistAllied	Distributed Allied thread
RRSAF	Db2 Resource Recovery Services attachment facility
SYSTEM	System directed access
TSO	TSO foreground and background
UNKNOWN	Unrecognizable connection type
UTILITY	Db2 Utility

Correlation ID The DB2 Correlation ID.

DB2 ID The name of a DB2 subsystem.

Elapsed time Shows the elapsed time in milliseconds.

End User ID The user ID of the workstation end user. This user ID can be different from the authorization ID used to connect to DB2. This field contains blanks if the client does not supply this information (DB2 field name: QWHCEUID).

Job Name The job name that is associated with a thread.

Lock Claim Resource The name of the object which is locked or claimed. The resource name can include the database name, pageset name, partition number, page number, record id (RID), collection ID, package name, or plan name:

DB=database name can be represented as DBID=identifier.
PS=pageset name can be represented as PSID=identifier.
DBID represents the decimal identifier of the database.
PSID represents the decimal identifier of the table space or index space.

Lock Level The level or mode of the lock request. This information describes the level of resource access demanded by the lock request. Possible lock levels are:

Value	Description
IS	Intent share
IX	Intent exclusive
NSU	Non-shared Update
S	Share
SIX	Share intent exclusive
U	Update
UNS	Unprotected shared
X	Exclusive

Lock Type The lock type of the lock request. Possible lock types are:

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.

LUWID The logical unit of work ID (LUWID) for a thread.

This value consists of two parts: the logical unit of work ID (luw-id) and a token. The token can be used in place of the luw-id in any Db2 command that accepts luw-id as input. Format:


luw-id=token

The luw-id consists of the network name, the originating VTAM® LUNAME, and a unique identifier (separated by periods). Thus, the Luwid field displays data such as the following:


USCACO01.O2D22A.A1FE8E04B9D4=8

MVSID The MVS system identifier.

Originating System ID The managed system name of the agent. It is an alphanumeric text string, with a maximum of 32 characters; for example, DB91:SYS1:DB2.

Package DBRM (Unicode) The package DBRM name.

Plan The plan name.

Resource Type The type of resource can be Lock or Claim.

Time Stamp Represents the end of data collection or the end of an interval, and is the local time where the system is running.

Total Locks The number of locks of the same lock type owned by the thread.

Uniqueness Value The instance number: When concatenated with the fully qualified network name, it uniquely identifies a distributed thread (DB2 field name: QWHSLUUV).

Uniqueness Value 2 The DB2 thread uniqueness value. For internal use.