Re: RE; Record lock wait times

Bill,

See also the related system values QINACTMSGQ  and QDSCJOBITV ...


Mark

On Thursday, December 19, 2019, 2:42:02 PM EST, Howie, Bill <bhowie@xxxxxxxxxxxxxxxx> wrote:

Hello all,

I'd like to dovetail another question onto this thread.....I made an assumption with the scenario in which this happened that a user closing out their interactive session by using the MS Windows "X" in the corner of the window could leave files open, and because of that leave records locked.  Maybe I'm wrong about this.  Is there some sort of timeframe after which this session would just go away?  Would it have anything to do with the system value that kicks users off (I think it's QINACTIV or something like that)?  Or can a session truly just be hung, completely open, record locks in place,  for a relatively infinite period of time by closing out of their interactive session in this way?  I'm also wondering if a network disruption would cause the same symptoms.  What I saw was the "session stopped by request from device" message in the job log from 6 pm the previous day, but the job still showed active, with open files, when using WRKUSRJOB at 7 pm the next day.

Any info is, as always, appreciated.

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/>

Disclaimer

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.