Re: Re: Delete Records -File Re-org

[Rob Berendt <rob@xxxxxxxxx>]

<SNIP>
Do a DSPOBJD before and 
after reorging them.  See if the size changes significantly.
<ENDSNIP>




pike4@ix.netcom.com on 02/17/2000 05:28:25 PM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     MIDRANGE-L@midrange.com@Internet
cc:      
Fax to: 
Subject:        Re: Re: Delete Records -File Re-org

I was asking, if it saves space or not, technically speaking. Someone to whom I 
suggested that we do this, said it doesn't really save space. The time to run a 
simple RGZPFM is  a few seconds. Of course, if it';s in Production, it has to 
be scheduled for when the system is in a restricted type state.

MIDRANGE-L@midrange.com wrote:
> I too, was under the impression that it saves space.  However, it really 
has to be something to justify doing it, unless you develop a tool.  For 
example, let's do some analysis to get the biggest bang for the buck.  Do 
a DSPFD to an outfile, selecting *MBR not *MBRLIST.  Query the file 
selecting lib, file, mbr, MaxRecSize*NbrDelRecs; sorting by the last, 
descending.  These are the files to reorg first.  Do a DSPOBJD before and 
after reorging them.  See if the size changes significantly.

Does it pay?  Figure out the cost of reorging.  Pick 10 files and reorg 
them.  Add the time to do this to the time to do the first paragraph.  
Figure out your billing rate.  If your an employee figure out overhead 
also.  Multiply rate by time.  Divide this amount by the cost of AS/400 
disk space, which is $0.60/meg.  Did you save this much space?  If not, 
don't reorg again - just buy more disk and save money.

ReorgTime(hours)     Rate$     1 meg
                  *  -----  *  -----  = Amount of meg you have to recover to 
pay for your time
                     Hour      $0.60

Is it efficient?  Perhaps you ought to look at the KEYFILE parameter on 
the RGZPFM command.  And sort your physical file by the logical that 
needs the best access.  Or maybe your physical file is keyed and you need 
that order fastest.  Then sort it by that.  RGZPFM is an easy sort command, 
providing you use the KEYFILE parameter.






pike4@ix.netcom.com on 02/17/2000 12:38:01 PM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     MIDRANGE-L@midrange.com@Internet
cc:      
Fax to: 
Subject:        Delete Records -File Re-org


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.
Thanks,
Phil Kestenbaum

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

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