BTCONTSM Summary of Lock Timeouts and Deadlocks Report

The BTCONTSM summarizes timeouts and deadlocks. This report is grouped by task waiting, resource, and task holding.
caidb219
The BTCONTSM summarizes timeouts and deadlocks. This report is grouped by task waiting, resource, and task holding.
Report characteristics:
  • Request type: Event Summary
  • Report format option: Column format
  • Records displayed: (172) DEADLOCK and (196) LOCK-TO-DETAIL (statistics trace class 3)
MM/DD/YY 05:17:01 PAGE 1 REQUEST: BTCONTSM DB2 SYS: SSID FIRST RECORD MM/DD/YY 12:48:05 LAST RECORD MM/DD/YY 05:12:16 Summary of Lock Timeouts and Deadlocks --------------------------- RESOURCE --------------------- TASK WAITING ---- -------- TASK HOLDING -------- -- ACTIVITY -- LOCK TYPE PLAN CORR ID PLAN CORR ID LOCKTYPE OBJECT LOCKED CONN ID AUTH ID MEM/AUTH CONNECTION HOLDWAIT REASON COUNT --------------------------------------------------------------- ------------ -------- ------------ -------- -------- ----- DATABASE RBPAR160 REGEXPDD M#D003I7 DB2CALL QARCM RBPAI17 RCM#DROP RS TIMEOUT 4 D10A DB2CALL HOLDER PDBAR01 ROW RBPAR160 REGEXPDD DSNDB06 .SYSTSTSP .PAGE X'0000B3FD'.ROW X'00A' DB2CALL QARCM RBPAI17 RCM#DROP CBS TIMEOUT 2 D10A DB2CALL HOLDER PDBAR01 DATASET DISTSERV db2jcc_appli DSN06816.TEST .PARTITION'00001' SERVER TRODE05 DSNESPCS TRODE05 CBS TIMEOUT 1 SSID TSO HOLDER TRODE05
Task Waiting Fields
The task waiting fields identify tasks that waited to obtain a lock in a time-out or deadlock situation.
  • PLAN
    Shows the plan name. Blank indicates DB2 activity that did not use a bound plan, such as a command thread or the data collector.
  • CORR-ID
    Shows the correlation ID.
  • AUTH-ID
    Shows the authorization ID. The waiting task auth ID is not available for deadlocks.
  • CONNECTION
    Shows the connection name.
Resource Fields
The resource fields identify the resource for which tasks contended.
  • LOCK TYPE
    Shows one of the following lock types:
    • DATAPAGE
      A page lock in a tablespace
    • DATABASE
      A lock on a database descriptor
    • PAGESET
      A lock on a nonpartitioned 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 skeleton cursor table
    • INDXPAGE
      A page lock in an indexspace
    • DS OPEN
      A lock that is used to serialize data set opens and closes
    • UTIL DMG
      A lock that is used for utility I/O damage assessment
    • PSET PC
      A simple page set consists of 1 to 32 VSAM data sets named 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. Occurs as an overflow out of the other buffer pools and implies that the buffers are undersized.
    • SYSLGRNG
      A lock that is obtained while writing to the SYSLGRNG tablespace
    • UTILITY
      A lock that is 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 skeleton package table
    • COLLECT
      A lock on an application package collection
    • AUTOBIND
      A lock that is 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
  • OBJECT LOCKED
    Shows a resource that is involved in a lock suspension. Database and page set names are translated using the OBID table. If the DBIDs and OBIDs are not in the table, DBIDs and OBIDs are displayed.
Task Holding Fields
The task holding fields identify tasks that held a lock that the waiting task required.
  • PLAN
    Shows the plan name. Blank indicates DB2 activity that did not use a bound plan, such as a command thread or the data collector.
  • CORR-ID
    Shows the correlation ID.
  • LOCKTYPE
    Identifies
    one
    of the following lock types:
    • PLOCK
    • MODIFY
    • PRIVATE
    • RS
    • CBS
  • MEMBER
    Shows the DB2 group member for which the thread is associated.
  • CONNECTION
    Shows the connection name.
  • HOLDWAIT
    Indicates whether the participant in the lock enqueue holds the lock (HOLDER) or the participant is a waiter (WAITER).
Activity Fields
The activity fields show the number of times the conflicts resulted in a deadlock or time-out.
  • REASON
    Indicates whether the contention resulted in a deadlock or a time-out.
  • COUNT
    Shows the number of times the waiting task, resource, and holding task were involved together in a deadlock or time-out.