Re: File Reorg - Cons

[fiona.fitzgerald@xxxxxxxxxxxxxxxxxx]

That's true, Henrik, there's no advantage in speed,
but if space is an issue, you can perform the cpyf to a library in another
ASP,
rather than boosting the system ASP with QTEMP.
Certainly I too wouldn't do either while the file is in use.

I think the point's been made though - a big file can take a very long time
to reorg.
But we reorg one every night and the application runs far faster as a
result.

Fiona Fitzgerald


wrote

What's the practical difference between CPYF twice and RGZPFM?

I can't se why CPYF should run faster or allocate the file for a shorter
time than RGZPFM.

Of cause, if the second CPYF is MBROPT(*ADD) it should have an *EXCL lock
for a shorter period, but is a file with only half the expected records
better than a locked file? I should rather think that it's worse

Henrik




__________________________________

Notice of Confidentiality 

This transmission contains information that may be confidential and that may 
also be privileged. Unless you are the intended recipient of the message (or 
authorised to receive it for the intended recipient) you may not copy, forward, 
or otherwise use it, or disclose it or its contents to anyone else. If you have 
received this transmission in error please notify us immediately and delete it 
from your system.

Email: internet.mail@xxxxxxxxxxxxxxxx