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