Adaptive Server includes this information for tracking locks:
The monLockTimeouts monitoring table provides information about lock requests that are denied because they are blocked for more than the value configured for lock wait period. See Chapter 3, “Monitoring Tables,” in the Reference Manual: Tables.
These configuration parameters configure Adaptive Server to collect lock wait timeout information and make it available for the monLockTimeout table:
lock timeout pipe active
lock timeout pipe max messages
See Chapter 5, “Setting Configuration Parameters,” in the System Administration Guide, Volume 1.
