RE: Record Lockup Problem...

["Sean Porterfield" <sporter@xxxxxxxxxxxx>]

> Problem:  Two users at different workstations have the same
> record open in a database.
>
> User 1 is just viewing the record on their screen.
>
> User 2 needs to update or change the open record.
>
> User 1 has walks away from their desk and left the record open
> and displayed on their workstation.
>
> User 2's workstation "locks up" waiting for User 1 to close the
> record so it can be updated.
>
> User 2 calls the System Administrator to complain about the
> workstation being "locked up".
>
> It would not be feasible for the System Administrator to go
> around to each workstation in an attempt to find User 1 and close
> the record.
>
> Is there a way to show the System Administrator the user IDs,
> workstations, or device names in the situation described above?


WRKUSRJOB USER2 *ACTIVE   (or WRKJOB if USER2 knows the job name/number)
5 to work with, 12 for locks, F10 for record locks.  You'll see the offender
on the list.

If USER1 is "just viewing" why lock the record?  Or is USER1 really
maintaining, but not planning to change anything?

Also USER2's program could be changed to check for the lock and ask for
retry y/n.