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

I hate it when my proofreading skills are tested :-|

I meant to say that our most dynamic files that need reorg the most are
not journaled because those files have too many transactions run against
them. The Journals that would be created would be huge and impact
performance too much.

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 Harvell, Joel
Sent: Tuesday, December 20, 2005 1:34 PM
To: Midrange Systems Technical Discussion
Subject: RE: Is there a REORG WHILE ACTIVE capability on OS/400?

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