Use DB2 Lock Conflict Group attributes to create situations that monitor DB2 database lock conflicts.
Authorization ID The primary authorization ID from connection or sign-on, 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.
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. Valid format is alphanumeric with a maximum of 8 characters; for example, TRAN5.
Connection ID Identifies the connection of an application to a DB2 system.
BATCH | Batch job |
CICS | CICS attach |
DB2CALL | DB2 call facility |
DIST | Distributed |
IMS | IMS thread |
TSO/E | TSO/E foreground and background |
UTILITY | DB2 utility |
Connection Type The type of DB2 connection.
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/E | TSO/E foreground and background |
UNKNOWN | Unrecognizable connection type |
UTILITY | DB2 utility |
Correlation ID 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.
DB2 ID The name of a DB2 subsystem.
Display Elapsed Time The total amount of elapsed time since thread creation or DB2 sign-on.
IDNAME An 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 The amount of time a waiter has been waiting for the resource.
Lock Level Identifies the lock resource usage.
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: If the status is OWN with a DB2 subsystem name, the lock is owned by another DB2 subsystem in the Data Sharing Group (DSG); for example, if lock status is OWN-DB2A, the lock is owned by DB2 subsystem DB2A.
Lock Type The type of DB2 lock.
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 data set |
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 | Page set/partition open |
PITR | Index manager tree page lock |
PPAG | Page page lock |
PPSC | Page set/partition castout page lock |
PPSP | Page set/partition page lock |
PRLF | RLF page lock |
PSET | Page set |
PSPI | Page set 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 |
UTOB | Utility object lock |
UTSE | Utility serialization |
WDRN | Write drain |
MVS System An ID for the MVS System Management Facility (SMF). Valid format is alphanumeric with a maximum of 4 characters; for example SP11.
Originating System ID The managed system name of the agent. Valid format is alphanumeric, with a maximum of 32 characters; for example, DB91:SYS1:DB2.
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.
Resource Name 1 (Unicode) The resource name of type defined by type code.
Resource Name 2 (Unicode) The resource name of type defined by type code.
Resource Name 3 The resource name of type defined by type code.
Resource Name 4 The resource name of type defined by type code.
Resource Type 1 This value indicates what is contained in Resource Name 1.
BP | Buffer Pool |
CO | Collection name |
DB Hash | Database |
HC | Class |
PL | Plan name |
UT | Utility ID |
Resource Type 2 This value indicates what is contained in Resource Name 2.
PK | Package |
PS | Page Set (Table space) |
Resource Type 3 This value indicates what is contained in Resource Name 3.
Resource Type 4 This value indicates what is contained in Resource Name 4.
PT | Partition |
SUBSYS The IRLM subsystem name.
Thread Status The current status of a thread.
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 because of Archive Log Mode (Quiesce) command |
WAIT_MSGSEND | Waiting because of 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. |
Time Stamp Represents the end of data collection or the end of an interval, and is the local time where the system is running.