Re: Most efficient AS400 physical file building ?

Did you create the DDM file using SNA (the default), or TCP/IP?  We've
discovered that TCP was much faster for DDM copy files.  But we also have 2
lan cards and the TCP is using the gigabit ethernet.

Perhaps this might also be better served by a Mimix like solution.  This
would keep the files in sync on a transactional basis.  Or,  is the file on
systemA filled with the data all at once also?

Rob Berendt

==================
A smart person learns from their mistakes,
but a wise person learns from OTHER peoples mistakes.


                                                                                
                                        
                    "Tim Truax"                                                 
                                        
                    <truax@telerama.com       To:     <MIDRANGE-L@midrange.com> 
                                        
                    >                         cc:                               
                                        
                    Sent by:                  Subject:     Most efficient AS400 
physical file building ?                
                    owner-midrange-l@mi                                         
                                        
                    drange.com                                                  
                                        
                                                                                
                                        
                                                                                
                                        
                    08/08/2001 04:30 PM                                         
                                        
                    Please respond to                                           
                                        
                    MIDRANGE-L                                                  
                                        
                                                                                
                                        
                                                                                
                                        




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