Re: Most efficient AS400 physical file building ?

[Pat Barber <mboceanside@xxxxxxxxxxxxxxxx>]

There are two possible problems, A: The speed of the line between the 
two boxes. B: The application that is "moving" the data.
 
You didn't state if the systems were in the same room 
or different locations. This makes a big difference when
communications gets in the picture. What method is used to
connect the two systems ??


The other possible problem is the method used to move the data.

Is this a giant cpyf application or is this a RPG program reading
and writing the data ??? DDM does not perform well in moving large
volumes of data, but it is excellent for random reads on a remote
file. DDM requires a fair amount of tuning to get every element 
working in the right way. You almost design your application
around DDM and what it can and can't do. 

It can degrade system performance in a big way if done incorrectly.






> Tim Truax wrote:
> 
> Hi All,
> There's a process that I am analyzing that involves large volumes of
> data records arriving in one (system A) AS400 physical file. Then
> another (system B) AS400 that is attached to this physical file on
> (system A) via a DDM file which resides on (system B).  This process
> that runs on (system B) then uses this DDM file and simply transfers
> the data that arrived in the physical file on (system A).
> Lately this process that transfers data between the two systems is
> lagging behind to the tune of millions of records.  These lags are
> happening at heavy system use times.
> 
> I am wondering if there is an (overlooked by me) CRTPF option that I
> could add to the (system B) receiving physical file when it's built
> weekly that would minimize this lag on receiving data records?
> ..possibly ALLOCATING THE STORAGE or something?
> 
> I have been directed to simply break the process in two (duplicate it)
> in order that the 2 duplicated jobs could run concurrently on (system
> B), and then the (system A) physical file would require 2 file members
> in order to attach two different DDM files to.
> 
> FYI) These AS400's I am talking about are not farty little boxes they
> are big AS400's.
> 
> Any suggestions or comments appreciated.
> Tim Truax  :-)
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---