BTLKCONT Deadlock Occurred at Fields

The deadlock occurred at fields describe the date and time of the event (in MM/DD/YY HH:MM:SS format).
caidb2
The deadlock occurred at fields describe the date and time of the event (in
MM/DD/YY HH:MM:SS
format).
  • Number of Resources
    Displays the number of resources contended for by the agents involved in the deadlock.
  • Victim
    Identifies the task that was rolled back in the deadlock:
    • Auth
      Displays the DB2 Authorization ID.
    • Corr
      Displays the thread's correlation ID (first 8 bytes).
    • Plan
      Displays the plan name. If blank, a DB2 command thread.
    • Conn
      Displays the name of the connection (TSO, BATCH, IMS MPR, DB2CALL).
  • Lock Request
    Identifies the object for which two or more threads are contending and includes the resource, type, mode, and dur field values.
    • Resource
      Identifies a resource involved in a lock suspension. Database and page set names are translated using the OBID table. If the table is out of sync with the data, DBIDs and OBIDs are displayed.
    • Type
      Displays the lock type. Valid values are as follows:
    • DATAPAGE
      A page lock in a tablespace.
    • DATABASE
      A lock on a database descriptor.
    • PAGESET
      A lock on a non-partitioned tablespace or indexspace.
    • DATA SET
      A lock on one of the partitions of a partitioned tablespace or indexspace.
    • SKCT
      A lock on an application plan's skeleton cursor table.
    • INDXPAGE
      A page lock in an indexspace.
    • DS OPEN
      A lock used to serialize data set opens and closes.
    • UTIL DMG
      A lock used for utility I/O damage assessment.
    • PSET PC
      A simple page set consists of 1 to 32 VSAM data sets called page set pieces. When a page set piece exceeds the page set piece size limit, another piece is allocated. A page set piece lock is issued on the pieces while the expansion occurs.
    • DBA TABL
      A lock on a table, tablespace or database which is being processed by a CREATE, DROP or ALTER statement.
    • RETRY
      A retry during an abort.
    • 32K DESP
      32 KB desperation pool lock. These occur as an overflow out of the other buffer pools and imply that the buffers are undersized.
    • SYSLGRNG
      A lock obtained while writing to the SYSLGRNG tablespace.
    • UTILITY
      A lock used by utility jobs for serialization.
    • MASS DEL
      A mass delete lock occurs when a delete is used without a WHERE clause. All rows in the table are deleted.
    • TABLE
      A lock on a table in a segmented tablespace.
    • HSH ANCH
      A hash anchor lock is used when accessing DB2 catalog or directory tables.
    • SKPT
      A lock on an application package's skeleton package table.
    • COLLECT
      A lock on an application package collection.
    • AUTOBIND
      A lock used to serialize local autobinds of packages and remote binds and rebinds of packages.
    • CS DRAIN
      Cursor stability drain locks are used by DB2 commands and utilities to serialize CS drains.
    • RR DRAIN
      Repeatable read drain locks are used by DB2 commands and utilities to serialize RR drains.
    • WR DRAIN
      Write drain locks are used by DB2 commands and utilities to serialize write drains.
    • AL BPOOL
      Alter buffer pool locks are used to serialize ALTER BUFFERPOOL commands.
    • ROW
      Row lock.
    • INDEX EOF
      Index End-of-File lock.
    • SS GPOOL
      Group Buffer pool Start/Stop lock.
    • DB EX LG
      Database Exception LPL/GRECP lock.
    • UTILEXC
      Utility exclusive execution lock.
    • SCA REDO
      SCA access for restart/redo information lock.
    • GPDB EXU
      Database Exception Update lock.
    • UTIL ID
      Utility UID lock.
    • REPR DBD
      REPAIR DBD TEST/DIAGNOSE lock.
    • CATM MIG
      CATMAINT Concert Catalog lock.
    • CATM CVC
      CATMAINT Concert Catalog lock.
    • CATMCVD
      CATMAINT Directory lock.
    • P/P PLCK
      Page set or Partition P-lock.
    • P/P CAST
      Page set or Partition castout P-lock.
    • GBP PLCK
      Group Buffer pool level castout P-lock.
    • INDX PLK
      Index Manager Tree P-lock.
    • RLF PLCK
      Resource Limit Facility P-lock.
    • DBD PLCK
      Database Descriptor P-lock.
    • DDF PLCK
      Distributed Data Facility CDB P-lock.
    • PAGE PLK
      Page P-lock.
    • Mode
      Shows the type of access allowed for concurrent applications processing the same resource.
    • Dur
      Indicates when a lock is released.
  • Task waiting
    Identifies a task that waited for a lock to be released:
    • Auth
      The DB2 Authorization ID.
    • Conn
      The name of the connection (TSO, BATCH, IMS MPR, DB2CALL).
    • Corr
      The thread's correlation ID (first 8 bytes).
    • Plan
      The plan name. If blank, a DB2 command thread.
  • Task holding
    Identifies a task that held a lock on a resource that was contended for.
    • Auth
      The DB2 Authorization ID.
    • Conn
      The name of the connection (TSO, BATCH, IMS MPR, DB2CALL).
    • Corr
      The thread's correlation ID (first 8 bytes).
    • Member
      The DB2 group member for which the thread is associated.
    • Status
      Indicates whether the participant in the lock enqueue actually holds the lock (HOLDER) or is another waiter of the lock (WAITER).
    • Plan
      The plan name. If blank, a DB2 command thread.