Schema Locks & Wait Queue

Displays outstanding schema locks.

08/26/25        Status: Schema Locks & Wait Queue by user number
23:39:36

  Usr:Ten    Name      Domain    Locked     Queued
    3        root           0                SHR
    1        jdoe          -4    SHR
    1        jdoe          -4    EXCL

 Total Locks Granted - SHR: 1  EXCL: 1

This display shows the following information:

  • Usr:Ten — The user number and tenant
  • Name — The user name
  • Domain — The domain of the user
  • Locked — The type of acquired schema lock
  • Queued — The type of queued schema lock