Re: REORG Question

["Bonnie Williams" <WilliamB@xxxxxxxxxxxxxxxx>]

Check out this link in Search400 
http://search400.techtarget.com/ateQuestionNResponse/0,289625,sid3_cid380467_tax285222,00.html

It mentions some suggestions for reorganizing large files.





I have a 720 with 34.36G sys ASP and I have a 860mb file with 4.3 million
records and 2 million deleted records.  I'm currently using 72% of the
current disk which would theoretically give me about 9 gig of free space.  I
want to re-org this file to clean up all that wasted space but I'm concerned
that it may push me out into the high nineties in disk usage when I do this.
It may be my imagination but it seems that the re-org process ends up using
a lot more disk space than just twice the size of the file when a re-org is
done.  A couple of weeks ago I got a 90% warning during the reorg of a much
smaller file with only about 10,000 deleted records.  At that time I was
running at 80% usage.

Are there any guidelines for determining how much temporary space would be
needed to re-org this file?  Does the re-org process use more temporary
space than if I were to just copy the file to a different library, delete
the original, and copy it back?

Should I just play it safe and wait until I get the additional disk space
that we are going to purchase in the next 2 months?

Jim Sneddon
AS/400 Development Manager
Allstate Ticketing
1421 Sunset #4
Las Vegas, NV 89119
702-617-5540
www.showtickets.com