Re: Lag time on Index file add?

[Carl Galgano <cgalgano@xxxxxxxxxxxxxxxxx>]

Check the parameter of the FRCRATIO on the physical file, it determies then
number of logical writes in a program actually physically write the data to
disk.
HTH.
Carl

At 03:50 PM 5/20/98 -0400, you wrote:
>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
>+---
>
Carl J. Galgano
http://cgalgano.home.mindspring.com
mailto:cgalgano@ediconsulting.com
EDI Consulting Services, Inc.   
540 Powder Springs Street
Suite C19
Marietta, GA 30064
770-422-2995
+---
| 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
+---