|
A coworker is having a problem with file locks because the file is being indexed. Here's the scenario. FILEA has multiple members. It a logical built over MEMBER1. Access path maintenence is *IMMED. From time to time (3 times a day), they copy records from FILEB and add them to MEMBER1 in FILEA. They also have greenscreen apps that use FILEA MEMBER1. Now, from time to time either the GS apps or the jobs that copies records to this member errors out with a file lock. It's locked because the system is indexing (*IDX for job) the file. He did say the file is getting pretty big (maybe a million records). This is on V4R4. He wants to know if there is a solution, and/or why this file takes so long to be indexed. It just started happening all of a sudden and causes some problems. TIA! Brad +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
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.