Re: RGZPFM

[Jan Megannon <jan@xxxxxxxxxxxx>]

I seem to recall that one of the ERP solutions did not work too well
with the iSeries / i5 RGZPFM. The reason for this was that the
application worked very much on RRN and the reorg tended to whack this,
thus creating havoc with the app. The application had its own way of
doing a reorg. Cannot recall if this was with JDE.

Just a thought.

Jan.


>>
>>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
>>