Re: Delete Records -File Re-org

["Gallagher, Debbie (CA - Toronto)" <dgallagher@xxxxxxxxxxx>]

Phil:

As others on this list have said . . .there is absolutely, positively, no
question that you will save disk space by re-org'ing to get rid of deleted
records in files. You may have to find a way to break it gently to your
co-worker (or boss).

I will send you privately an article I wrote for TUG/400 magazine. It
outlines how to create a report that shows how much disk space is being used
by deleted records. At my previous employer, I ran this report every week to
see which files we should re-org at the next window in the data centre
schedule.

Due to application design (as Al Barsa mentioned), we were unable to change
all files to re-use deleted records. If my own experience with JDE support
is any indication, you will never get enough info from them to determine if
it is safe to change your files or not - so assume you can't. We also had
users in many time zones, so the window for doing re-org was usually small -
couldn't run them all or even a whole library every weekend.

As others mentioned, it will be difficult to know how long the re-org will
run the first time you do it - Pete outlined some of the factors. We used to
keep track in the data centre to help with planning. Once the re-org starts
to run, no one can use the file until the re-org is finished.

You will be able to prove to your co-worker (or boss) how much disk is
saved. Run the deleted records report before and after a re-org. The file
size and number of deleted records will be on the report.

Debbie Gallagher
dgallagher@deloitte.ca

------------------
Original message
------------------
From: pike4@ix.netcom.com 
Subject: Delete Records -File Re-org
>
>   <snip>   re-orgs on these files during the week end, and was told that
this doesn't 'really' save
space. <snip>
>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
+---