var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: detect and terminate appl holding locks
Is there a way to detect and terminate an application that is holding locks for longer than some specified amount of time?
I want it to detect/terminate the one who is holding the locks, not the one who is waiting.
Appl A executes a query and doesn't commit
Appl B wants to do a reorg on the same table and is waiting for Appl A to release the lock (LOCKTIMEOUT = -1)
I want to detect/terminate Appl A.
Doesn't look trivial. I don't think the lock _holding_ time is being monitored. You could possibly arrive at it from the UOW start time: get the transaction ID holding the lock, then find the UOW start time or something.
What they're looking for is some feature built into the product that can be used to monitor lock_holding_time. Perhaps you're right and this is not being monitored. Thanks.