Re: reorg HUGE file

[D.BALE@xxxxxxxxxxxxx]

Mike,

Same problem as with my earlier request for CHKSAVTAP:  The V3R2 version of
QUSRTOOLS stripped out most of the useful tools from previous releases.  Can I
presume that TBPARCSI / RCLSPACE could be found in V3R1?  If so, and if you
have it, would you be so kind to send me the source (privately, in
consideration of others on the list)?

We do have the C compiler on our V3R2 box, and I presume that C programs
convert to 64-bit RISC like all others.

Dan Bale
IT - AS/400
Handleman Company
248-362-4400  Ext. 4952

-------------------------- Original Message --------------------------

>Lakeview sells a product that does a re-org while in use.  It requires
>journaling.

If  you have a C compiler, then you can use the version supplied by IBM in
library QUSRTOOL.

See member  TGPARCSI in file QATTINFO for details about the RCLSPACE
command.

Essentially, it swaps active records at the end of the file with deleted
ones at the beginning.
Optionally a TRUNCATE keyword can be specified (needs exclusive use of file
tho)  which
then chops the end (deleted records part) off the file.

Mike
+---
| 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
+---