AS400 Mid Range/Record locks CPF4128

Advertisement


Question
Other than sending a msg to the user to sign off, then back on, is there a way to stop the record locks, this is dsx data transfer and is extremely important there are no ramifications

Answer
No, not without rethinking how, when or why the record gets updated. You can consider it a law of physics for all computers that two processes cannot lock the same record for update at the same time, because the computer would not know which version of the two differently-updated records to keep as the final and correct version.

You could use the WRKOBJLCK command to check if any user has a lock on the file before you start the data transfer, or you could copy the file to another library and then do your data transfer from the copied file - no user would have a lock on the copy.

- Laird

AS400 Mid Range

All Answers


Answers by Expert:


Ask Experts

Volunteer


Concise Systems/Laird Scranton

Expertise

General AS/400, RPG/400, SDA and CL programming questions. AS/400 performance tuning.

Experience


Past/Present clients
CB Sportswear
Coca-Cola of New York
Encore Paper Company
Golub Corporation
HBO Home Video
Imperial Pools
Kaiser Permanente of NE New York
Mallinckrodt Medical
Marigold Foods
Manpower & Associates
National Datacomputers
New York State Easter Seals Society
New York State Food Merchants Association
Pepsi-Cola Allied Bottlers
Petricca Construction
Taconic Telephone Corporation
TOMRA Recycling
Unistress Corporation

©2012 About.com, a part of The New York Times Company. All rights reserved.