RE: File reorganization

[watern@xxxxxxxxxxxxxx]

Yuriy,

An alternative to removing logicals and adding them back is to do a CHGLF
MAINT(*REBLD) before the re-org and then restore the old setting (eg CHGLF
MAINT(*IMMED)) afterwards.  If the physical is keyed you can do the same for
that as well with CHGPF.  However, this will not work for Unique-keyed access
paths, so you would need to remove/addback the logical in that case.

If you are interested in monitoring the progress of the access paths being
rebuilt afterwards, the EDTRBDAP is quite a neat command. The estimated timings
used to be way out, though its a while since I used it, so this may have
changed.

The KEYFILE parameter on the rgzpfm command also has implications for the
performance of the re-org, and the performance of pgms that process the file.

hth
Nigel




<snip>..
I've got to reorg some files on the system. What is faster:

A. Reorganize files as:
     - remove logical's
     - reorg files
     - add logicals
or

B. Copy data out to temp file, followed by copying data back

Files are from 5,000,000 to 43,000,000 records and have logical files based
on them.

Answers would be greatly appreciated.
<endsnip>






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