Can I use PWRDWNSYS RESTART(*YES *FULL) to automatically RGZPFM all physical files? I would like to perform the RGZFPM on all files. I?m a little concerned with the amount of time it will take to execute this command.
The PWRDWNSYS with the parameters you specified will not reorganize files; it will just restart all portions of the system, including hardware. There are a couple things you can do to minimize deleted records.
If your files have a fairly constant records count, such as in the case of a daily transaction file where the numbers or records added on a daily basis is pretty close the number of deleted records deleted daily, then you might want to consider changing your files to reuse deleted records (i.e. CHGPF FILE(MYLIB/MYFILE) REUSEDLT(*YES) )
The other thing you might want to consider is some sort of file reorganization program that you can run on a periodic basis. If you do a search on the Search400.com Web site, you should find several techniques for accomplishing this.
MORE INFORMATION ON THIS TOPIC
The Best Web Links: tips, tutorials and more.
Ask your programming questions--or help out your peers by answering them--in our live discussion forums.
Ask the Experts yourself: Our application development gurus are waiting to answer your programming questions.