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
released.

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.

rex
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to