Re: Converting large amount of data

[Peter Dow <petercdow@xxxxxxxxx>]

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?