Re: RGZPFM with ALWCANCEL(*YES)

I have found that if you have a very large file, with many index's, it's actually faster to Delete all the indexes before you perform the reorg.
Perform the reorg, then re-create the index's and let the system Database jobs rebuild the access paths.

Gavin.

On 10/17/2025 6:26 PM, Dan Bale via MIDRANGE-L wrote:

If RGZPFM with ALWCANCEL(*YES) is used on a file for which there are a lot of logical access paths/indexes, are the access paths/indexes updated on the fly, or are they ignored until the physical file reorg is completed? The reason for asking is that if we need to cancel the reorg submitted with ALWCANCEL(*YES), will the job still need to spend time updating the access paths/indexes? So, if we're given until 9:000am when the file must absolutely be available, can we cancel the job at 8:59am with the expectation that the file and its indexes will be ready and available to use?

- Dan Bale
*** CONFIDENTIALITY NOTICE: The information contained in this communication may be confidential, and is intended only for the use of the recipients named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please return it to the sender immediately and delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. ***