× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



If the logical file is defined with MAINT(*IMMED), then changes to key fields happen during maintenance.  If the physical record's key fields don't meet the logical file's select/omit during record update, then no change to the LF.  But if they do meet the criteria, then the LF index is updated.

MAINT(*DELAY) and MAINT(*REBLD) are for LFs that are not used very often, or whose underlying PF is not modified very often, or both.

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx> /

On 3/9/2021 9:58 PM, Gad Miron wrote:
Just a thought...

If the LF has a Select/Omit part then an index will always be built when
opening the LF
Won't it?

Gad

> On Tuesday, March 9, 2021, 3:10:18 PM EST, smith5646midrange@xxxxxxxxx
<smith5646midrange@xxxxxxxxx> wrote:

I?m resurrecting this old post because I have a problem.

We have rewritten our conversion to use CHGPF where we can.? Today someone
tried to DBU a logical file built over a huge physical (182M records) and
it took 15 minutes (this is a severely restricted machine) and it said
something about rebuilding the index.?

I thought CHGPF updated the indexes while it was running (excluding the
mismatched ones that we discussed earlier).? We can?t use the CHGPF if that
is going to delay the normal processing the first time that it tries to use
the index.

Is there something I missed in all of this?





As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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

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.