BTSUSPSM Lock Suspension Summary Report

The BTSUSPSM provides a summary of lock suspensions. The report is grouped by SMF ID, Db2 subsystem ID, plan, database, page set, and lock type.
caidb219
The BTSUSPSM provides a summary of lock suspensions. The report is grouped by SMF ID, Db2 subsystem ID, plan, database, page set, and lock type.
Report characteristics:
  • Request type: Event Summary
  • Report format option: Column format
  • Records displayed: (045) LOCK-SUSPEND (performance trace class 6)
MM/DD/YY 14:48:13 PAGE 1 REQUEST: BTSUSPSM DB2 SYS: SSID FIRST RECORD MM/DD/YY 14:04:26 LAST RECORD YY/MM/DD 14:05:20 LOCK SUSPENSION SUMMARY SYSTEM NORMAL IRLM DEADLOCK TIMEOUT FIRST SUSPENSION SUBSYS PLAN OBJECT LOCKED LOCK TYPE COUNT TOTAL TIME COUNT COUNT COUNT COUNT LAST SUSPENSION ------ -------- --------------------------- --------- ------- ------------- -------- -------- -------- -------- ----------------- S018 SEAGOON1 JBG .PLANTS PAGESET 1 18.5248 0 0 1 0 MM/DD/YY 14:05:17 DB23 MM/DD/YY 14:05:17 SEAGOON2 JBG .PLANTS DATAPAGE 1 27.8184 1 0 0 0 MM/DD/YY 14:05:20 MM/DD/YY 14:05:20 SEAGOON3 JBG .PLANTS DATAPAGE 1 0.6872 1 0 0 0 MM/DD/YY 14:04:26 MM/DD/YY 14:04:26
The BTSUSPSM report contains the following fields:
  • SYSTEM
    SMF ID of the z/OS system.
  • SUBSYS
    Db2 subsystem name as defined in SYS1.PARMLIB(IEFSSNxx).
  • PLAN
    Displays the plan name suffering the suspension. Blank indicates DB2 activity that did not use a bound plan, such as a command thread or the data collector.
  • OBJECT LOCKED
    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.
  • LOCK TYPE
    Displays 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
  • COUNT
    Displays the number of suspensions.
  • TOTAL TIME
    Displays the amount of time the plan was suspended.
  • NORMAL COUNT
    Displays the number of times a locked resource became available before the time specified in the RESOURCE TIMEOUT system parameter.
  • IRLM COUNT
    Displays the number of times the plan was suspended to identify to the IRLM.
  • DEADLOCK COUNT
    Displays the number of times the plan was involved deadlock.
  • TIMEOUT COUNT
    Displays the number of times the plan was involved timeout.
  • FIRST SUSPENSION, LAST SUSPENSION
    Displays the date and time of the first and last suspensions encountered for this plan/resource/lock combination.