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 [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
