Re: Indexing File lock problem on V4R4

Are you sure that you are not running Queries from Hell on this file.  When you
do a WRKACTJOB, do you see any jobs with an IDX-filename being displayed?

You may want to convert your indexes from the MAX4GB to MAX1TB, because of the
way the locking/seizing  is done on records.  Its is much more efficient.

    Pete Massiello

"Stone, Brad V (TC)" wrote:

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

--
Pete Massiello
OS Solutions International
Phone: (203)-744-7854  Ext 11.
http://www.os-solutions.com
mailto:pmassiello@os-solutions.com


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