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">