SAP Program RSSQD001 - SAP DB: Exclusive Lockwaits

Description
Online program
This program displays the current lock statuses for database objects(tables). Only "exclusive" locks are considered.

Precondition
Call transaction ST04
Menu: Goto -> Exceptions -> Exclusive lockwaits

Output
Lock List Statistics
Average and maximum number of locks
Number of collisions and escalations
Total number of set row and table locks
The following table contains information about currently retainedlocks.

  • Table name:

  • Name of locked table
    • Lock type:

    • EXCL --> Table lock
      excl --> Row lock
      • Timeout:

      • Remaining time (in seconds) to lock timeout; displayed in 30-secondintervals.
        • User:

        • User/owner of table
          • TaskID:

          • Internal task number of database, to which a particular task type andapplication ID are assigned.