Re: Is there a REORG WHILE ACTIVE capability on OS/400?

[Mike Eovino <meovino@xxxxxxxxx>]

Glenn,

How is the performance for programs attempting to use the file that's
being reorg'ed?

Mike E.

On 12/20/05, Glenn Birnbaum <gbirnba@xxxxxxx> wrote:
> I'll point out (my experience has been) that if you use the RGZPFM with
> the Allow Cancel and Read or Shared Update for the lock (as shown
> below), the file will be reorganized so that all deleted records are in
> one contiguous area in the file, but they will still be part of the file
> and taking space.  We have had to run the RGZPFM with allow cancel NO at
> a time when the file is not in use to 'chop' off the deleted records
> piece.
>
> We'll reorg-while-active during the day and then have a night jobq that
> we run the final reorg (we find that this dedicated reorg runs very
> quickly if the reorg-while-active completed earlier that day, usually
> just a few minutes).
>
> HTH,
> Glenn
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Harvell, Joel
> Sent: Tuesday, December 20, 2005 1:55 PM
> To: Midrange Systems Technical Discussion
> Subject: RE: Is there a REORG WHILE ACTIVE capability on OS/400?
>
>
> RGZPFM FILE(AG017LIB/PTFDATA) ALWCANCEL(*YES) LOCK(*SHRUPD)
>
> When you specify LOCK(*SHRUPD) you have to also specify ALWCANCEL(*YES)
>
> When you specify ALWCANCEL(*YES) the file you are reorganizing has to
> have Journaling turned on.
>
>
> Merry Christmas
>
> Joel B. Harvell
> Food Lion, LLC
> (704) 633-8250 x2709
> jbharvell@xxxxxxxxxxxx
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike savino
> Sent: Tuesday, December 20, 2005 3:48 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Is there a REORG WHILE ACTIVE capability on OS/400?
>
> Dave,
>
> Since you asked about Mimx and LPAR I'm assuming that your files are
> already
> Journaled or will be shortly for your HA Solution.  So if Journaling is
> all
> you need to do a REORG while active, as Joel Harvell said, then you
> should
> have no worries, True ??  Although I don't see that as an option on the
> RGZPFM command.
>
> Joel, does it have to be specified somewhere on the command or does it
> just
> work auto-magically if the file is Journaled ??
>
> Mike
>
>
> --
> 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 electronic message may contain confidential or privileged
> information
> and is intended for the individual or entity named above.  If you are
> not the intended recipient, be aware that any disclosure, copying,
> distribution or use of the contents of this information is prohibited.
> If you have received this electronic transmission in error, please
> notify
> the sender immediately by using the e-mail address or by telephone
> (704-633-8250).
> ************************************************************************
> **
>
> --
> 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.
>
>