|
Oh, I see, it's an interactive job locking the file. I had thought two batch programs were conflicting. I think the real solution is to fix the interactive program that locks the file. You should not be chaining to the file with a lock until you are ready to update it. The first time the program chains to the file, chain with no lock to get an image. Use an externally described data structure with the Prefix keyword to rename the fields, an another one without the prefix keyword. Move the second data structure to the first one right after you chain with no lock. When ready to update, chain again with a lock, and compare the two data structures. If they differ, someone else has updated the record; in that case, unlock the record immediately and send an error message to the user. Otherwise, update the record immediately. This way, you only lock the record for a very short time (when the record is actually updated). Also use the (E) extender on the chain with a lock; if %ERROR is on, send an error message that the record is locked by another user. By reading the File information data structure, you can tell who is locking the record (if you are checking for both %ERROR and the correct %STATUS code). This way, the users can handle their own record lock problems. -----Original Message----- From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of murali dhar Sent: Monday, January 3, 2005 9:47 PM To: RPG programming on the AS400 / iSeries Subject: RE: some ideas needed Hi Francis, Thanks for responding, but my first priority is batches,batch has to run without lock problems caused by user. I want to cancel User job,currently what I do is finding out user-id and call him to cancel his job.I am thinking on a program which will find user id and send user message to all users on AS400 which says to cancel his session at that time, the program can be robot shceduled for automatic running in my system. Best Regards, Francis Lapeyre <flapeyre@xxxxxxxxxxx> wrote: Make sure whatever submits that program to batch submits it to the same job queue, and make that job queue single-threaded (only one job can be active at a time). Francis Lapeyre IS Dept. Programmer/Analyst Stewart Enterprises, Inc. E-mail: flapeyre (at) stei (dot) com -----Original Message----- From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of murali dhar Sent: Monday, January 3, 2005 5:27 PM To: rpg400-l@xxxxxxxxxxxx Subject: some ideas needed Hi all, 2 batches batch1 & batch2 constantly lock due to users running a program BUP009C. Inorder to let 2 batches run through, I usually find User-id who is running the job BUP009C and cancel his job. I want to place a program which would constantly check during time period 5pm-7pm which user is running BUP009C at that time(batch1 starts at 5pm , batch2 starts at 5.15pm,both end around 7pm) and send message to all users on AS400 lettinng them which user is running and asking him to cancel out his session. any ideas appreciated.. Happy&Prosperous new year 2005 to all.. regards, --------------------------------- Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. -- This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l. -- This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.
As an Amazon Associate we earn from qualifying purchases.
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.