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

["Glenn Birnbaum" <gbirnba@xxxxxxx>]

Hi Mike,

We haven't run this against a lot of files yet, but with that said,
we've had no performance issues so far.  Also, if you did believe that
the REORG-WHILE-ACTIVE was creating performance impacts, then you can
always end the RGZPFM and schedule to run at a better time.  My guess is
that the answer to this question is it 'depends' on the environment
(what types of disk drives, controllers, and memory) and the
applications (how they're coded and the  load on the system).

Give it a try with one of your files using the 'allow cancel = Yes'
option and you have little to risk.

HTH,
Glenn

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Eovino
Sent: Tuesday, December 20, 2005 5:50 PM
To: Midrange Systems Technical Discussion
Subject: Re: Is there a REORG WHILE ACTIVE capability on OS/400?

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