× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Ideally you would modify the application that it would not lock the record 
when displayed on the screen.  IBM wrote a manual about 25 years ago 
outlining this. 

You read the file into temporary storage and unlock the record,
display it on the screen,
allow user to make changes
reread file into other temp storage.
Any values that you are changing have been updated?
If not update the record with your values
If so, reject update and reprompt user.

Very few applications are written to this spec.

WRKOBJLCK or DSPRCDLCK are quite effective.

If you want to get fancy you can have the CHAIN in the file have a WAITRCD 
on the OVRDBF.
http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/dbp/rbafomst02.htm#ToC_179
Then if the chain fails call various API's that do the WRKOBJLCK and 
perform automated operations then.  Like "Dude, User so-and-so at 
workstation so-and-so has that file locked.  Call the administrator at 
70566 and have them spank them."  There might even be enough data in the 
File Information Data structure (assuming RPG) to tell you all this 
information and you might be able to skip the API's.

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




<marsha.barton@xxxxxxxxxxxxxxxx> (Marsha Barton) 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
10/23/2003 03:21 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
<midrange-l@xxxxxxxxxxxx>
cc

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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.