ALLBASE/SQL Reference Manual (36216-90216)

200 Chapter5
Concurrency Control through Locks and Isolation Levels
Monitoring Locking with SQLMON
Determining Number of
Transactions that are Waiting for
Locks
Overview Load IMPEDE XACT
Identifying Locks for which
Sessions are Waiting
Lock all fields
Identifying Sessions that have
Obtained a Particular Lock
Lock Object GWC
MOD
PIN
Identifying Sessions that are
Waiting to Obtain (or to Convert) a
Particular Lock
Lock Object GWC
MOD
NEW
PIN
Identifying Lock Activity for a
Particular Session
Lock Session all fields
Identifying Locks Obtained by a
Particular Session that are
Causing Other Sessions to Wait
Lock Impede all fields
Detecting Deadlocks Load
Load Session
Load Program
DEADLOCKS
Resolving Deadlocks Lock
Lock Object
Lock Impede
all fields
Table 5-5. SQLMON Monitoring Tasks
Task Screens Fields