Re: Re: Delete Records -File Re-org

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

At 03:49 PM 02/17/2000 -0500, you wrote:
>Al,
>That is an excellent idea, but this being a JD Edwards shop, I'm sure 
>there will be all sorts of flags raised.
>MIDRANGE-L@midrange.com wrote:
> > At 11:45 AM 02/17/2000 -0500, you wrote:


Without going into too much detail, when a file is open with 
REUSEDLTRCD(*YES) specified, a "deleted record map" is created for that 
job.  When the job needs to add a record, it checks the available first 
slot from the map, if it's still available, it fills it.  When another job 
(that presumably opened the file at the same time goes to use that already 
filled slot, it goes on to the next, and so on and so on.  If another job 
opens the file at a later time, it gets a fresh (revised) map.

Here's the rub, if you have programs that read the records in arrival 
sequence where the logic of the program counts on the fact that record "n" 
is older (written prior to) that record "n+1", it will likely break your 
application.

On the other hand, is you code for this, you may never have to do another 
re-org!

Second rub, the deleted space stay's allocated until the data is refilled, 
or until the file is really re-orged using RGZPFM.

Al




> >I was looking for ways to save space on the system, and found a large
> >number of deleted records in files. I suggested to run re-orgs on these
> >files during the week end, and was told that this doesn't 'really' save
> >space. I always thought that it did. Does Re-orging a file give space back
> >to the system? Or was the space available anyway.
>
>If the design of your application permits (call me for these details)
>specifying REUSEDLTRCD(*YES) will mostly eliminate the need for re-orgs.
>
>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-1234
>Fax:            914-251-9406
>http://www.barsaconsulting.com
>http://www.taatool.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
>+---
>
>+---
>| 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
>+---



+--------------------------------------------------+
| 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-1234
Fax:            914-251-9406
http://www.barsaconsulting.com
http://www.taatool.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
+---