RE: RGZPFM

No problem with JDE.  We reorg our files on occasion w/out problems. 


John A. Jones, CISSP
Americas Information Security Officer
Jones Lang LaSalle, Inc.
V: +1-630-455-2787 F: +1-312-601-1782
john.jones@xxxxxxxxxx

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jan Megannon
Sent: Thursday, March 30, 2006 4:49 PM
To: Midrange Systems Technical Discussion
Subject: Re: RGZPFM

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
>>
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.



This email is for the use of the intended recipient(s) only.  If you have 
received this email in error, please notify the sender immediately and then 
delete it.  If you are not the intended recipient, you must not keep, use, 
disclose, copy or distribute this email without the author's prior permission.  
We have taken precautions to minimize the risk of transmitting software 
viruses, but we advise you to carry out your own virus checks on any attachment 
to this message.  We cannot accept liability for any loss or damage caused by 
software viruses.  The information contained in this communication may be 
confidential and may be subject to the attorney-client privilege. If you are 
the intended recipient and you do not wish to receive similar electronic 
messages from us in future then please respond to the sender to this effect.