Re: RGZPFM

Ryan,

1) RGZPFM reorganizes only 1 member at a time. The default is *FIRST.

2) Usually, in the AS/400, you don't define a file as having contiguous
sectors on your disk. In fact, as your system has several disks, it
balances them automatically so you get better performance that way.

Regards,

Luis Rodriguez


> 
> 
> ------------------------------
> 
> message: 8
> date: Thu, 30 Mar 2006 15:21:01 -0500
> from: "Ryan Hunt" <ryan.hunt@xxxxxxxxxxxxx>
> subject: RGZPFM
> 
> We've had our AS400 for 6 years now and we've never performed an RGZPFM
> on
> our production database. Our AS400 serves as our Enterprise Server for a
> JDE
> OneWorld ERP so there is LOTS of activity on this thing.
> 
> I'm under the impression that the running RGZPFM again my production DB
> library with no other parameters will remove deleted records from all
> members and place the members/files into contiguous sectors of my disks
> (thus making sequential I/O more likely).  Is this correct?
> 
> Thanks in advance.
> 
> Ryan Hunt
> 
> 
> 
----------------------------
Luis Rodriguez
IBM Certified Systems Expert
eServer i5 iSeries Technical Solutions
Caracas, Venezuela