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

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