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

I found a utility in the old MC years ago that I modified to skip the file
(it does a MONMSG in a CL) if the file can't be allocated when trying a
RGZPFM. But we reorganize on Saturday night, when nothing else is happening.


While our business is generally a 9 to 5 operation, users can be on the
system to look up things at any time.

We only reorganize a file if it has more than 1% deleted records. You can do
this via CL or RPG (if you want a report). Maybe run it twice, because the
second time around, all it will do is try to reorganize the stuff it missed
the first time.


Francis Lapeyre
IS Dept. Programmer/Analyst
Stewart Enterprises, Inc.
E-mail: flapeyre@xxxxxxxx 


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dave Odom
Sent: Tuesday, December 20, 2005 12: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
--
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.