Re: Reusing deleted records

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

At 03:59 PM 9/18/98 -0400, you wrote:
>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. 

>> 
>> 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.
>> 
You are right.  This is not descriptive.  However, I think that this caveat
has to do with the concept of the deleted record map which is created at
file open time, which I described.

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