Transaction Begin time is available in the transactions display in PROMON and in the _trans VST table.
Promon > R&D > 1. Status Displays > 4. Processes/Clients > 3. Active Transactions
Locks are however not timestamped.
- Since locks can be acquired outside of transactions, there is no way to know their age.
- An exclusive lock is allowed only in a transaction but a share lock could be acquired before the transaction begins and then be upgraded to an exclusive lock within the transaction and then be downgraded to share when the transaction ends.
- Lock requests that are queued because of a conflict are not timestamped either.
- The lock wait timeout -lkwtmo client parameter can be used to limit lock wait times.
There are two rules which can be used to monitor the locked records:
- Locks In Use High, Indication that the record locks in database have exceeded the threshold.
- Record Waits High, Monitor to gauge user's share and exclusive locks. Larger numbers indicate users are holding locks longer than required.
The above can be partially or closely achieved using PROMON and VST tables referred in the Articles below
