Re: RGZPFM vs RSTOBJ

[John Jones <chianime@xxxxxxxxx>]

If you're on a recent OS release the reorg can be run in the background so
it more or less takes no time at all.  No downtime, anyway.  Check the LOCK
parm of RGZPFM. I think you have to be V5R3 and up.

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/cl/rgzpfm.htm

Also, don't forget to change the file to reuse deleted records so deleted
record growth is slow going forward.

On Wed, Aug 26, 2009 at 5:43 PM, Alan Campin <alan0307d@xxxxxxxxx> wrote:

> Only two ways to get out. Reorganize or copy out. It would seem to me that
> a
> copy would be slower but never did any timings.
>
> On Wed, Aug 26, 2009 at 2:13 PM, Tim Gornall <tgornall@xxxxxxxxxx> wrote:
>
> > We have file with 51 million current records, and 30 million deleted
> > records.  I need to get rid of the deleted records.  I restored a copy of
> > the file a few days ago it finished in about 15 - 20 minutes.  If I
> recall
> > it takes much longer than that to reorg that many records.  I'm trying to
> > get an idea of how long it will take.  The file is keyed, but has no
> > logicals.  Is restore faster?
> >
> > Tim
> >
> >
> >
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.