I know the OP wanted to know how long a user session has been idle,
but real problem is the second person waiting for the lock to be

The best practice is to always have LOCKED clauses on your READU's,
and never to "block on a lock", i.e. a user input process should hit
the locked clause and report who has the desired record locked, and
giving the user an out if they cannot access the record at this time.
Batch and phantom processes should not block either, waiting 5-10
seconds and retrying up to specific number of times (say 10), then
skipping over the record and leaving it for subsequent processing.

U2-Users mailing list

Reply via email to