Re: RGZPFM

A RGZPGM is NOT the PC equivalent of disk defrag.
Yes it will remove deleted records.
No, it will not put the members into contiguous sectors of disk.
Unlike your standard PC you have:
1 - Multiple disk drives
2 - Files can span drives
3 - More than one user accessing the system at a time, therefore those 
heads are moving all over the place so the odds of the heads remaining 
stationary for your next read request are slim to none.
Therefore contiguity really buys you nothing.

There is an option on RGZPFM called KEYFILE.  This can be a real 
performance boost.  For example, if you find that you traditional read a 
file by it's primary key, like item number of an item master, then using 
KEYFILE will sort the file by the key of whatever file you specify.  Could 
be the physical, if it's keyed, or a logical file based off of the 
physical, if you like the key of that better.  For example, if a bulk of 
your performance concerns involves getting your employee list by last 
name, firstname then use a KEYFILE of a logical file that sorts like that. 
 You may find that you may create a different logical file.  For example, 
many people will put a select/omit on a name keyed logical to select only 
"active records".  I think a file used for KEYFILE cannot have select/omit 
criteria.

Rob Berendt