Introduction

PRGZPFM reorganizes physical file members (by running the RGZPFM command) for selected files in one library. This is one of the commands in our ISeries utilities library (click this URL for full Prospero Software PSPUTIL contact and pricing details).

The IBM-supplied RGZPFM command allows you to reorganise only one physical file member at a time. PRGZPFM allows you to reorganize one or multiple physical file members at a time. PRGZPFM allows you to specify the minimum number/percent of deleted records the file member must have before it is selected for reorganization. For example you may have a physical file with 1,000,000 active records and/or a large number of based-on logical file members. You may decide that reorganising this physical file member may not be worthwhile until the number of deleted records exceeds 200,000 or 15% of total records.

Examples

PRGZPFM FILE(MYLIB/T*) MINRCDS(50000) MINRCDP(40)

Command above reorganizes all members in all physical files prefixed 'T' in library MYLIB where the number of deleted records is more than 50,000 or more than 40% of the total (active+deleted) number of records in the member.

PRGZPFM FILE(BASELIB/*ALL)

Command above reorganizes all members in all physical files in library BASELIB. PRGZPFM command defaults means this is done only where the number of deleted records is more than 10,000 or more than 10% of the total (active+deleted) number of records in the member.

Restrictions

1)	The command tries to obtain an exclusive lock (ALCOBJ *EXCL) on the file member before reorganising it. It waits 2 seconds for this lock. If this exclusive lock is unobtainable, PRGZPFM silently moves on to the next physical file member.
2)	Other jobs running on your system may be prevented from accessing physical file members that PRGZPFM has obtained an exclusive lock on. How those jobs respond in that case is not under our control. In general terms, you should schedule PRGZPFM to run at a time when you know that other processes - including backups - will not be attempting to access physical file members in the library.
3)	The RGZPFM command allows you to reorganize file members in IBM-supplied libraries like QSYS - provided you have sufficient access rights to those members. The PRGZPFM command will not allow you to reorganise file members in QSYS particularly - but will not stop the reorganise of members in other QSYS* libraries. In practice you should only run RGZPFM or PRGZPFM over file members in user libraries.

IBM rebranded the AS/400 - some users called it AS400 - to ISeries several years ago and then to System i. All 4 names - ISeries, AS/400, AS400, System i - refer to exactly the same system.