Re: Different Physical File Attributes.

["Ryan Hunt" <ryan.hunt@xxxxxxxxxxxxx>]

Ok, I found some information on "Keyed" and "Arrival" sequences.  Coming
from the MS SQL world, it sounds alot like Arrival is synonymous with
"heaps" and keyed is synonymous with "clustered". Please note I use the
synonyms lightly...

This sound about right?

"Ryan Hunt" <ryan.hunt@xxxxxxxxxxxxx> wrote in
message news:e1h2es$dc$1@xxxxxxxxxxxxxxxx
> I think you are on to something.  F0907 with the Access Path tab has DSPFD
> Access Path = "Keyed".  F0911 with DSPFD Access Path = "Arrival" does not
> have the tab.
>
> What is this "Keyed" and "Arrival" access path attribute?
> Thanks.
> RH
> <vhamberg@xxxxxxxxxxx> wrote in message
>
news:041120061850.17483.443BFA66000BC3620000444B2206999735099D0A0D030E0890@xxxxxxxxxxxxxx
> > I'll guess that the second is in arrival sequence. DSPFD lists that as
its
> access path, although one could say arrival sequence is not an access
path.
> >
> > The other is about fixing the access path when it gets damaged somehow,
> IIRC.
> >
> > There is a question mark in the title bar - click it and then click on
> whatever you want to know about - a tool tip window appears.
> >
> > HTH
> > Vern
> >
> > -------------- Original message -------------- 
> > From: "Ryan Hunt" <ryan.hunt@xxxxxxxxxxxxx>
> >
> > > We're a JDE OneWorld customer so my question pertains to tables that
we
> part
> > > of an install I know nothing about. I have two different tables that
> have
> > > different attributes when viewed in iSeries Navigator.
> > >
> > > The first file/table (F0907) has an additional tab when I view the
> > > description of the object. The tab is called "Access Path". The
> > > maintenance is set to "Do Not Wait" - which I assume means to maintain
> > > indexes as the physical file is changed. There is also a "Recovery"
> > > attribute with a value of "During IPL" - I'm not sure what this means.
> > >
> > > The second file/table is F0911 and it does not have the "Access Path"
> tab.
> > >
> > > Does anyone know what causes the difference?
> > >
> > >
> > >
> > > -- 
> > > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> > > To post a message email:
> MIDRANGE-L@xxxxxxxxxxxx
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > > Before posting, please take a moment to review the archives
> > > at http://archive.midrange.com/midrange-l.
> > >
> > -- 
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> > To post a message email:
> MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> >
> >
>
>
>
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email:
MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>