Re: Reusing deleted records

[Larry Bolhuis <lbolhui@xxxxxxx>]

Al,

  Here is an excerpt from the OS/400 DB2 for OS/400 Database Programming
V3R2 (SC41-3701-01)
---------------------------------
2.1.2.3 Reusing Deleted Records
<snip>
     One hundred percent reuse of deleted record space is not
guaranteed. A file full condition may be reached or the file may be
extended even though deleted record space still exists in the file. 
<snip>
   ) Copyright IBM Corp. 1996 - 
--------------------------------
As you can see it's not very descriptive but it leaves IBM an out.

The process with the problem deletes the records at month-end and they
get added all month long.  The adds just always appear at the end.

Larry Bolhuis
Arbor Solutions, Inc
lbolhui@ibm.net



Al Barsa, Jr. wrote:
> 
> At 10:45 PM 9/17/98 -0400, you wrote:
> >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.
> >
> I have used this function a bit (less than a lot, but more than just
> playing) and I have never seen it not work.
> 
> Note than when the file is opened, the system develops a "deleted record
> map".  This is an internal table of available deleted records to be re-used
> by RR number.  If another application subsequently deleted a record, the
> first application is not aware of the newly deleted record.
> 
> Please send me information as to look on where it will not work.
> 
> 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
+---