RE: Lag time on Index file add?

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+---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@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
> +---
>


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@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
+---

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