Re: Lag time on Index file add?

[Pete Massiello <pmassiello@xxxxxxxxxxxxxxxx>]

Remember, its the access paths that kill you, not necessarily the number
of logical files. Most people use the term to mean the same thing, but
as Logical files can share access paths, there should beless Access
paths than logicals, if the files were created correctly.  In either
case, with 154 logicals there would no doubt be a "truckload" of access
paths as well.

Eric wrote:
> 
> 154!  How many are actually being used????
> 
> Eric Kempter
> Director of MIS
> Commair Mechanical Services
> 
> -----Original Message-----
> From:   Mike Shaw [SMTP:mike@mikeshaw.com]
> Sent:   Wednesday, May 20, 1998 1:45 PM
> To:     Midrange Listserv
> Subject:        Re: Lag time on Index file add?
> Importance:     High
> 
> Tim,
> 
> How many other logicals do you have over the physical file???
> 
> I have a physical loan file here at NAMC that is 1.1 million records.  The 
>programmers have 154 logicals built over it!!!!!!!!
> 
> Mike Shaw
> 
> ----------
> > Hello All,
> > Here's a quick question.
> > 1. AS400 Physical File that holds multiple comments for an order#.  The key 
>to
> > this file is (order#) + (3/0 seq#).
> > 2. File has 1.7 million records in it.
> > 3. File has ACCESS PATH MAINTENANCE(*IMMED) when I do a DSPFD.
> > 4. Records are being added to this file and they do not actually end up at 
>the
> > end of the file until 5 - 8 minutes later.
> > Is this normal?
> > TIA
> > Tim Truax+---
98

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