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

["Harvell, Joel" <jbharvell@xxxxxxxxxxxx>]

It is true that you can do a reorg while active in V5R3, however the
file has to be journaled.  I don't know about you but most of our most
dynamic files because of the number of transactions that would be
recorded in the journal.  That's the main gotcha I know about.

Merry Christmas
 
Joel B. Harvell
Food Lion, LLC
(704) 633-8250 x2709

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dave Odom
Sent: Tuesday, December 20, 2005 1:24 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Is there a REORG WHILE ACTIVE capability on OS/400?

If so, what do you think about it?    I understand there is such a
capability but it may be only under V5R3.   In any event, it is supposed
to allow me to REORG libraries/files while applications are doing
SELECTs/Reads, INSERTS/Writes, UPDATES/Writes and DELETES?   Is that
true?   Any gotchas?   

I'm trying to get as close to 24/7 as possible to get rid of the weekly
6 hour window when we do our REORGs and the system is unavailable.

Thanks in advance,

Dave Odom
Arizona