Re: Lag time on Index file add?

[Bob Larkin <blarkin@xxxxxx>]

If commitment control is used, records would not be visible until a COMMIT 
boundary is reached.
Also, sequential output causes blocking to occur (Check your compile messages)
Bob Larkin

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


begin:          vcard
fn:             Bob Larkin
n:              Larkin;Bob
org:            <A HREF="HTTP://web.wt.net/~blarkin/">Larkin Computer Consulting</A>
adr:            <A HREF="http://web.wt.net/~blarkin/">Bob and Diana's Page</A>;;;Houston;TX;<A HREF="http://web.wt.net/~blarkin/">;United States
email;internet: blarkin@wt.net
title:          Systems Consultant
x-mozilla-cpt:  ;4104
x-mozilla-html: FALSE
version:        2.1
end:            vcard