Re: Delete Records -File Re-org

The system does not need to be in a restricted state. That is a RCLSTG (Reclaim 
Storage), and perhaps that is where the confusion lies.  Also, neither of these 
processes take a few seconds, they both are dependent on numerous things.  A 
reorg will take some time on a large file, depending on the size of your 
AS/400s, number of Arms, #
deleted records, # active records, # of Access paths, etc.  I know we go into 
quite a lot of items to forecast how long it will take to reorg a file in our 
product.

    Pete Massiello

pike4@ix.netcom.com wrote:

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

--
Pete Massiello
OS Solutions International
Phone: (203)-744-7854  Ext 11.
http://www.os-solutions.com
mailto:pmassiello@os-solutions.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
+---