RE: Intelligent Reorg #2

["MCPARTLAND, Stan" <stanley.mcpartland@xxxxxxxxxx>]

Go to http://www-1.ibm.com/support/ and search for rclspace.  RCLSPACE is a
non-supported command in the SAP R/3 tools that will reorg an in use file on
a high availability system.  I have never used this command, but have looked
at the code.  It moves records from the end of the file to deleted location
earlier in the file and then truncates the file when it is done.  I think
the truncate operation requires exclusive use of the file.  You will lose
your arrival sequence of records and shouldn't it if you have LIFO or FIFO
specified on your files.

Regards,
Stan

<snip>

We've been really pressed here for
reorgs on a couple of huge files but we don't have the disk space necessary
to
do them without getting well into the "90% threshold".  So, we're looking to
develop a home-grown solution (read: "free") for something that happens very
infrequently.

<snip>
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---