• Subject: Re: Reusing deleted records
  • From: Larry Bolhuis <lbolhui@xxxxxxx>
  • Date: Thu, 17 Sep 1998 22:45:32 -0400
  • Organization: Arbor Solutions, Inc

Sorry if this is a repeat, as I haven't been following this thread
extremely close, but a customer presented me with a problem this morning
re: Reuse deleted records.  They have a fairly large (1+Mil records)
file with a fair number of LFs that gets a LOT of add/delete traffic. 
They have turned on Reused Deleted Records but it is not working.  They
showed me a page from the manual that indicates there are (unnamed)
curcumstances when the system will not honor the re-use of deleted
records, and their's is not.  The file has more deleted records than
un-deleted ones, and all new adds go to the end of the file.

Can anyone explain?

  Larry Bolhius
  Arbor Solutions, Inc
  lbolhui@ibm.net

Al Barsa, Jr. wrote:
> 
> At 02:31 PM 9/16/98 -0400, you wrote:
> >Does this affect journalling (rollbacks, ect.)
> 
> No.
> 
> The only major adverse effect of REUSEDLT(*YES) is if you have a program
> that reads the file sequentially (possibly for performance), and assumes
> that record n+1 was written chronologically after record n.
> 
> A more minor point is if you have applications that add, and then delete,
> records.  This is not a common application design.
> 
> Al.
> 
> +--------------------------------------------------+
> | 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-9400
> Fax:    914-251-9406
> 
> +---
> | 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
> +---
+---
| 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
+---


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.