× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: Re: Re: Delete Records -File Re-org
  • From: pike4@xxxxxxxxxxxxx
  • Date: Thu, 17 Feb 2000 15:41:19 -0500

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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.