ALLBASE/SQL Reference Manual (36216-90216)

Chapter 5 199
Concurrency Control through Locks and Isolation Levels
Monitoring Locking with SQLMON
Monitoring Locking with SQLMON
SQLMON is an online diagnostic tool that monitors the activity of your DBEnvironment. In
addition to providing information on file capacity, I/O, logging, tables, and indexes, SQLMON
displays information on the locks currently held in your DBEnvironment. SQLMON is fully
documented in the ALLBASE/SQL Performance and Monitoring Guidelines.
MONITOR Authority
Users with DBA authority or who are granted MONITOR authority can run SQLMON. Use the
GRANT MONITOR command to allow users to run SQLMON. Use the REVOKE MONITOR
command to revoke the authority. SYSTEM.SPECAUTH and CATALOG.SPECAUTH identify
users with MONITOR authority.
Monitoring Tasks
Table 5-5 summarizes the monitoring tasks related to locking you can perform with
SQLMON:
Table 5-5. SQLMON Monitoring Tasks
Task Screens Fields
Determining Size of Runtime
Control Block
Overview RUNTIME CB %
Used Pages
Max Pages
Monitoring DBEnvironment Lock
Activity
Load LOCK REQTS
LOCK WAITS
LOCK WAIT %
Comparing Number of Locks by
Table
LockTabSummary OWNER.TABLE
G
TOTAL LOCKS
Comparing Number of Locks by
Session
Lock Memory TABLE
PAGE
ROW
TOTAL
MAXTOTAL
Identifying Locks on a Table or
Referential Constraint (PCR)
Lock OWNER.TABLE[/CONSTRAINT]
G
PAGE/ROW ID
LOCK QUEUE
Determining Number of Sessions
that are Accessing a Particular
Lock
Lock LOCK QUEUE