Re: REUSEDLT(*YES)?

At 09:55 AM 10/28/99 -0500, you wrote:
>Folks:
> 
>At the last COMMON conference, I seem to remember hearing someone say that
>using REUSEDLT(*YES) had a performance hit.
> 
The system creates a deleted records map of each file specified with
REUSEDLT(*YES) at file open time, and attempts to fill these records first
before adding records to the end of the file.

A performance hit occurs when the job fills it's deleted records map and
has to transition to the end of the file.

In general, I find this "over time" penalty far more painless than the
effort of reorging the file and rebuilding access paths periodically.

Al - in Rochester




+--------------------------------------------------+
| Please do not send private mail to this address. |
| Private mail should go to barsa@ibm.net.         |
+--------------------------------------------------+

Al Barsa, Jr. - Account for Midrange-L
Barsa Consulting, LLC.  
400 > 390

Phone:  914-251-1234
Fax:    914-251-9406
http://www.barsaconsulting.com
http://www.taatool.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
+---