Adaptive Server version 15.7 allows you to monitor lock timeouts.
Adaptive Server version 15.7 adds this information for tracking locks:
- The monLockTimeout monitoring table provides information about
timeout lock requests, such as lock types, owners, locks status, and so on. See
the Reference Manual: Tables
- These 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 "Setting Configuration Parameters" in the System Administration Guide, Volume 1.