RE: Record Lockup Problem...

["Rubino, Jim" <Jim.Rubino@xxxxxxxx>]

If you look at the user 2 joblog you will see a message saying that the
record nnnnnn in file xxxxx is in use by number/job/user.       

If the program that the user 1 is using is strictly an inquiry only and
there is not an update to the file in question, then the program needs to be
changed to no do a lock on any records they are viewing.

Jim Rubino
Senior Business Systems Analyst
FIKE CORPORATION
704 South 10th Street
Blue Springs, Mo.  64015
(816) 229-6216  Ext. 213
 

-----Original Message-----
From: marsha.barton@xxxxxxxxxxxxxxxx [mailto:marsha.barton@xxxxxxxxxxxxxxxx]

Sent: Thursday, October 23, 2003 3:22 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Record Lockup Problem...

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? 

Marsha Barton / Computer System Tech
Brevard County Public Safety / Criminal Justice Services
1040 S. Florida Ave.
Rockledge, FL 32955
(321) 633-2006 Ext. 52330
marsha.barton@xxxxxxxxxxxxxxxx


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.