Re: Lag time on Index file add- followup

["Al Barsa Jr." <barsa2@xxxxxxx>]

At 04:54 PM 5/20/98 -0400, you wrote:
>If my physical file is classified as ACCESS PATH MAINTENANCE(*IMMED) and I 
>have a user that goes into a job for a period of 25 minutes and the file 
>being update is considered OPEN the whole time, then the ACCESS PATH 
>MAINTENANCE(*IMMED) action associated with the file will not occur until 
>the user signs off the job...thereby closing the file?  And if another user 
>gets in and out of the same job wholly within the first users 25 minute 
>period, then their updates and adds to the file will be done first.

Tim, with all due respect, I do not agree.

When a file has been opened, you get immediate maintenance.  The ACCPTH
parameter determines what happens to the file after you close it, and
before it's opened again.

If you say *IMMED, it's always maintained in real time.

If you say *REBLD, the access path is thrown away after use, and it's
rebuilt on the next open.   If a second user opens the same file after the
first user has it opened (with access path rebuilt), the second user gets
immediate access to the access path.

A third option, *DLY, exists, which maintains the access path immediately
up to a certain percentage of records in the view.  I do not remember exactly.

Al


Al Barsa, Jr.
Barsa Consulting, LLC.

(914) 251-9400
(914) 251-9406 (fax)

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