RE: Re-Organize File

["Nicolay, Paul" <paul_nicolay@xxxxxxxxx>]

HI,

http://www.iterainc.com/products2/reorg_while_active.doc is one of them...
don't have experiences with it however.  I think I saw different ones in the
Midrange newsletter but can't find it immediatly (maybe it was even the
same).

Kind regards,
Paul

-----Original Message-----
From: JJW [mailto:rpgilejjw@charter.net]
Sent: 18 April, 2002 14:45
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.



------------------------------------------------------------------------------
Notice:  This e-mail message, together with any attachments, contains 
information of Merck & Co., Inc. (Whitehouse Station, New Jersey, USA) that may 
be confidential, proprietary copyrighted and/or legally privileged, and is 
intended solely for the use of the individual or entity named in this message.  
If you are not the intended recipient, and have received this message in error, 
please immediately return this by e-mail and then delete it.

==============================================================================