RE: Re-Organize File

[Scott Mildenberger <Smildenber@xxxxxxxxxxxx>]

We have Turnover PDQ from SoftLanding Systems www.softlanding.com that
allows files to be re-orged with only a couple of minutes down time.  We
have done it with files containing up to 10 million records.

Scott Mildenberger

> -----Original Message-----
> From: JJW [mailto:rpgilejjw@charter.net]
> Sent: Thursday, April 18, 2002 6:45 AM
> To: rpg400-l@midrange.com
> Subject: Re: Re-Organize File
>
>
> Not what I wanted to hear, but what I had expected to
> hear.  Thanks for the quick responses.
>
> Anybody know of any products that can re-org files faster
> than RGZPFM or CPYF?
>
> TIA!!!
>
> On Thu, 18 Apr 2002 08:24:30 -0400
>   "Fisher, Don" <Dfisher@roomstoreeast.com> wrote:
> >We had a file similar to that on our model 720 with two
> >processors and it
> >took DAYS to execute an RGZPFM command.
> >
> >On the other hand, copying the file, as Paul suggested,
> >only took about
> >eight hours.  Granted, the file only had about four
> >access paths to rebuild.
> >
> >Hope that helps.
> >
> >Donald R. Fisher, III
> >Project Manager
> >The Roomstore Furniture Company
> >(804) 784-7600 extension 2124
> >DFisher@roomstoreeast.com
> >
> ><clip>
> >Given the following: I have a file that has Total records
> >= 75 million and Total deleted records = 50 million and
> >there are 25 logicals attached and total record length is
> >442.
> >
> >How long would RGZPFM take to run over this file?
> ><clip>
> >_______________________________________________
> >This is the RPG programming on the AS400 / iSeries
> >(RPG400-L) mailing list
> >To post a message email: RPG400-L@midrange.com
> >To subscribe, unsubscribe, or change list options,
> >visit:
> >http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> >or email: RPG400-L-request@midrange.com
> >Before posting, please take a moment to review the
> >archives
> >at http://archive.midrange.com/rpg400-l.
> >
>
> <TEXTAREA NAME="Signature" ROWS="4" COLS="60"><TEXTAREA
> NAME="Signature" ROWS="4" COLS="60">
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L)
> mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>