RE: Record Lockup Problem...

[RJoubert@xxxxxxxxxxxxxxxxxxxx]

I have found that, for the operations staff that get the CPF4128 (or any
message referring to Object / Record locks), the command to use is

WRKOBJLCK OBJ(LIBRARY/FILE) OBJTYPE(*FILE)
 
This will create the display
                           Work with Member Locks

                                                           System:   SPX400

File . . . . . :   FILE                 Type . . . . . :   PHY

 Library  . . :     LIBRARY             ASP device . . :   *SYSBAS

 

Type options, press Enter.

 4=End job   5=Work with job   8=Work with job locks

 

 

                                        Lock

Opt  Member      Job         User        Type    Lock     Status  Share

     FILE        JOBNAME     USERNAME    MBR     *SHRRD    HELD

                                         DATA    *SHRUPD   HELD       

and then, by looking that the LOCK type, the Ops staff can call the
offending user or just cancel the job if the user is away from his/her/their
desk.
 

 


-----Original Message-----
> 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?