Re: REORG Question

[Vernon Hamberg <vhamberg@xxxxxxxxx>]

Looks like you SHOULD have enough room. But???

Make sure you have a backup before doing any of the following.

1. RGZPFM is sort of like 2 CPYF steps. (I know, probably more than that.)
You could CPYF to a new temp file, create(*YES). Then CPYF that one back to
original with replace(*YES).

2. QMQRY can replace the contents of a file, in place. SCARY!!! BACKUP
BACKUP BACKUP

Put a 'select * from yourlib/yourfile' into a source member (rcd length =
91). Then CRTQMQRY. Then STRQMRY output(*OUTFILE)
outfile(yourlib/yourfile). You get no warning.

Remember BACKUP BACKUP BACKUP!

At 07:39 AM 4/18/02 -0700, you wrote:
>This message is in MIME format. Since your mail reader does not understand
>this format, some or all of this message may not be legible.
>--
>[ Picked text/plain from multipart/alternative ]
>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
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.