Hello all,

Question for the group....we had an issue on our production machine yesterday and here are the details....a batch job, in this case one of our MRP runs, started at around 12:15am. A user who had logged on the day before closed out of their session by clicking the "X" on the window and not signing off in an orderly fashion. This left their files open. The batch job went to LCKW status and sat there until around 7 pm last night, when I saw what was happening and ended the user's hanging job. The batch job then continued and finished normally.

In researching the parameters for lock waits on files, I saw that the file in question had a *NOMAX lock record wait parameter. In reading about that I saw that that actually translates to 32,767 seconds, which is about 9 hours. From when the job started to when I saw the problem was about 19 hours. Is there another factor in lock waits that literally could cause a true infinite wait time? Any info is truly appreciated. Thanks!

Bill Howie | Senior ERP Programmer/Analyst Consultant
The HC Companies | 2450 Edison Blvd, Suite 3, Twinsburg OH 44087
Direct: 330.487.3739 | Cell: 330.495.5627 | Toll Free: 800.225.7712

The HC Companies, Inc.<http://www.hc-companies.com/> - North America's Leading Provider of Containers for Horticulture
Dillen | ITML | ProCal | Kord | Amerikan | Planters' Pride
From Grower to Gardener, Improving Our World
[Related image]<https://www.linkedin.com/company/the-hc-companies> [Related image] <https://www.facebook.com/HCCompanies/>


The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

This email has been scanned for viruses and malware, and may have been automatically archived by Mimecast Ltd, an innovator in Software as a Service (SaaS) for business. Providing a safer and more useful place for your human generated data. Specializing in; Security, archiving and compliance. To find out more visit the Mimecast website.

As an Amazon Associate we earn from qualifying purchases.

This thread ...


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

This mailing list archive is Copyright 1997-2022 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.