Re: Different Physical File Attributes.

[vhamberg@xxxxxxxxxxx]

I don't know enough about the SQL Server stuff to comment - did a quick google 
and it seems that indexes are described with those terms, so it might not be 
the same thing as index vs. no index - arrival means records are presented in 
the order they were put into the file - the order in which they arrived. They 
are not keyed or indexed. In the SQL Server world it is unusual to have tables 
without a primary key, in the older world of iSeries native database, this is 
very common, and any indexes were all in separate files (logical files).

Keyed means indexed. Access path, in general terms, means how the data is 
accessed. Or what path you take to get to the data. Arrival sequence is a kind 
of access path, in a way, where you just start at the physical start of the 
file and read through it. Keyed means you use an index or key, so that the 
records are read in a certain order.

HTH
Vern
-------------- Original message -------------- 
From: "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" 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 
> > wrote in message 
> > 
> news:041120061850.17483.443BFA66000BC3620000444B2206999735099D0A0D030E0890@comca
>  
> st.net... 
> > > 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" 
> > > 
> > > > 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. 
> > 
> > 
> 
> 
> 
> -- 
> 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. 
>