DB2 Lock Conflict Attributes

Use DB2 Lock Conflict Group attributes to create situations that monitor DB2 database lock conflicts.

Authorization Identifier The primary authorization ID from connection or signon, that identifies the execution privileges an application has to a DB2 object or service. Valid format is alphanumeric with a maximum of 8 characters; for example, TRAN5.

Connection IdentifierIdentifies the connection of an application to a DB2 system. Valid values are:

BATCH	Batch job
CICS	CICS attach
DB2CALL	DB2 call facility
DIST	Distributed
IMS	IMS thread
TSO	TSO foreground and background
UTILITY	DB2 utility

Connection Type The type of DB2 connection. Valid values are:

APPLCTN	Application directed access
BATCH	Batch job
CICS	CICS attach
DB2CAF	DB2 call attach
DLIBATCH	DL/I batch
IMS	IMS thread
IMS BMP	IMS attach BMP
IMS TBMP	IMS transaction BMP
IMS CTL	IMS control region
IMS MPP	IMS attach MPP
SYSTEM	System directed access
TSO	TSO foreground and background
UNKNOWN	Unrecognizable connection type
UTILITY	DB2 utility

Correlation Identifier The correlation between an application and the connection to a DB2 system. Valid format is alphanumeric, with a maximum of 12 characters; for example, DLKEX212.

DB2ID The name of a DB2 subsystem.

Display Elapsed Time For an owner, the amount of time an owner has held a lock on a resource; for a waiter, the amount of time a waiter has been waiting for a resource. Valid format is DD-HH:MM:SS, where:

DD	Day
HH	Hour
MM	Minute
SS	Second

For example, 00-20:16:18 indicates that the display elapsed time is 20 hours, 16 minutes, and 18 seconds.

IDNAMEAn internal attribute used for navigation, it contains either the Data Sharing Group Name or the DB2ID. Valid format is alphanumeric with a maximum of 8 characters; for example TDDB242G.

Lock Elapsed Time For an owner, the amount of time an owner has held a lock on a resource; for a waiter, the amount of time a waiter has been waiting for a resource. Valid value is an integer in the range 0 - 99999999.

Lock Level Identifies the lock resource usage. Valid values are:

IS	Intent share
IX	Intent exclusive
S	Share
SIX	Share intent exclusive
U	Update
X	Exclusive

Lock Resource The resource a lock owner currently has locked or the resource that caused DB2 to suspend a lock request. Valid format is alphanumeric, with a maximum of 50 characters; for example, DB=TBLBLK2 PS=PAGELK2.

Lock Status The status of a job holding or waiting on a lock. Valid values are:

Owner	Job is holding a lock
Waiter	Job is waiting on a lock

Lock Type The type of DB2 lock. Valid values are:

ALBP	Alter buffer pool
BIND	Autobind/rebind
CCAT	Catalog maintenance convert catalog
CDIR	Catalog maintenance convert directory
CDRN	CS-read drain
CMIG	Catalog maintenance migration
COLL	Collection
DBEX	DB exception LPL/GRECP
DBXU	DB exception update lock
DSET	Partition dataset
DTBS	Database
GRBP	Group buffer pool start/stop
HASH	Hash anchor
IEOF	Index EOF
IPAG	Index page
MDEL	Mass delete lock
PBPC	Group buffer pool castout page lock
PCDB	DDF CDF P-lock
PDBD	DBD P-lock
PDSO	Pageset/partition open
PITR	Index manager tree pagelock
PPAG	Page pagelock
PPSC	Pageset/partition castout pagelock
PPSP	Pageset/partition pagelock
PRLF	RLF pagelock
PSET	Pageset
PSPI	Pageset piece
RDBD	Repair DBD test/diagnose
RDRN	RR-read drain
ROW	Row
RSTR	SCA restart/redo access
SDBA	Start/stop DBA table
SKCT	Skeleton cursor table
SKPT	Skeleton package table
SREC	SYSLGRNG recording
TABL	Table
UNDT	Undetermined
UTEX	Utility exclusive execution
UTID	Utility UID lock
UTSE	Utility serialization
WDRN	Write drain

MVS System An identifier for the MVS System Management Facility (SMF). Valid format is alphanumeric with a maximum of 4 characters; for example SP11.

Originating System Identifier Identifies the originating Candle Management Server (CMS). Valid format is alphanumeric, with a maximum of 32 characters; for example, DB2.USCACO01.D412.

Plan Name The name of an application plan that DB2 produces during the bind process and uses for processing SQL statements during execution. Valid format is alphanumeric with a maximum of 8 characters. For example PLANLCK2 is the name of an application plan. *SYSTEM* indicates DB2 subsystem-generated threads that own or are waiting on a lock.

Thread Status The current status of a thread. Valid values are:

IN_BIND_DYN	In dynamic bind processing
IN_COMMAND	Executing within DB2 command processor
IN_DB2	Executing in DB2
IN_SQL_CALL	Processing an SQL call
IN_STOR_PROC	Executing a stored procedure
IN_SQL_SORT	Doing sort processing while executing an SQL call
IN_TERM_THRD	Terminating
INDOUBT	In doubt
NOT_AVAIL	Not available
NOT_IN_DB2	Not executing in DB2
SWAPPED_OUT	Originating address space swapped out
WAIT_ARCHIVE	Waiting for an archive log tape mount
WAIT_ARCREAD	Waiting for read of archive log from tape
WAIT_ASYNCRD	Waiting for completion of read I/O done under another thread
WAIT_ASYNCWR	Waiting for completion of write I/O done under another thread
WAIT_CLAIMER	Waiting for release of claimers
WAIT_CONVLIM	Distributed thread in synchronous wait; conversion limit reached
WAIT_CTHREAD	Queued in create thread processing
WAIT_DRNLOCK	Waiting to acquire drain lock
WAIT_GLBLOCK	Waiting for lock or lock contention within data sharing group
WAIT_LOCK	Waiting for a lock
WAIT_LOGQSCE	Suspended due to Archive Log Mode (Quiesce) command
WAIT_MSGSEND	Waiting due to intersystem message sending
WAIT_PGLATCH	Waiting for page latch
WAIT_REMREQ	Database access thread in synchronous wait
WAIT_REMSQL	Distributed allied thread in synchronous wait
WAIT_REUSE	Waiting for reuse
WAIT_SERVICE	Waiting for completion of DB2 service
WAIT_SP_SCHD	Waiting to schedule a stored procedure
WAIT_SP_STOP	Waiting because stored procedure stopped
WAIT_SYNC_IO	Waiting for completion of synchronous read or write I/O
WAIT_TERM_TH	Queued and waiting for termination

Thread Type The type of thread.

A-LIST	Allied-distributed thread starts at one server location; processes at another
ALLIED	Thread starts and processes at one server location
DBACCESS	Database access thread, requested by an allied-distributed thread
UNKNOWN	Unknown

Timestamp Represents the end of data collection or the end of an interval, and is the local time where the system is running. Valid format is
MM-DD-YY HH:MM:SS, where:

MM	Month
DD	Day
YY	Year
HH	Hour
MM	Minute
SS	Second

For example, 07-16-00 14:58:29 indicates that data collection ended on July 16th, 2000, at 14:58:29 PM.