Re: Lag time on Index file add?

At 03:50 PM 5/20/98 -0400, Tim Truax wrote:
>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?  

Tim,

Probably. When you define a file as input or output, the system will 
automatically block the I/O. It will not actually get written to disk until 
either a block of data has been filled or the access path is closed. If you 
need the data to be available sooner, you can use FEOD to flush the buffer 
after a group of writes, although this is usually only a problem when you are 
reading a different access path than you are writing.

Pete


Pete Hall
peteh@inwave.com 
http://www.inwave.com/~peteh/

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