RE: Re: Delete Records -File Re-org

["Lemen, George (Contractor)" <george.lemen@xxxxxxxxxxxxxxxx>]

I did some work here that may be of interest in this thread.
I wrote a program that uses DSPFD to an outfile and scans our physical files
(excluding source files) looking for cases where:
*       There are multiple disk increments are in use.
*       # deleted records is greater than # of records in an increment.
We then run RGPFM on the files/members identified. We made sure our
applications folks are "on board" so we know which path to use for optimum
performance.

The first time we ran this (the files had not been reorganized in a while),
we got about 2.5 to 3% of the disk back on a 48GB system. Saved us ordering
more disk.  As you can imagine, our management "took that to the bank". This
process is now part of our regularly scheduled inventory of "housekeeping".

George Lemen
Sr. Project Analyst
CIBER Inc
Weyerhaeuser CER Technical Support and Operations Manager
Weyerhaeuser phone: (253) 924-7975
Weyerhaeuser e-mail: george.lemen@weyerhaeuser.com
CIBER Phone (425) 451-2575 x142
CIBER E-mail: glemen@ciber.com

> ----------
> From:         pike4@ix.netcom.com[SMTP:pike4@ix.netcom.com]
> Reply To:     MIDRANGE-L@midrange.com
> Sent:         Thursday, February 17, 2000 12:41 PM
> To:   MIDRANGE-L@midrange.com
> 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.
> 
        <Rest of original Snipped>
+---
| 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
+---