RE: BPCS 405 CD & Wasted Disk Space

When a file specifies REUSEDLT(*YES), it will try to reuse any deleted record 
space.  If it cannot find a space that will allow the insertion, the record is 
written to the end of file.

-----Original Message-----
From:   MacWheel99@aol.com [SMTP:MacWheel99@aol.com]
Sent:   Wednesday, February 17, 1999 6:37 AM
To:     BPCS-L@midrange.com
Subject:        Re: BPCS 405 CD & Wasted Disk Space

Thanks Shalom

In your judgement, if we do a backup of the library before reorganizing to
eliminate deleted records - what might be the downside of that plan of action?

>  While reusing deleted records does decrease the occupied disk space on the
>  AS/400, you must not do so if you use journaling on BPCS files.

>  Setting the "reusedlt" parameter to *yes may cause the journal to be
>  inacurate, reorganizing the physical files on a regular basis will
>  certainly render the journal useless.

I had also learned from another source that there is an I/O performance issue
related to whether AS/400 has to search for a space that can be re-used as
opposed to just adding records to the file.

Al Macintyre
 
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---

application/ms-tnef