Re: Most efficient AS400 physical file building ?

["Jeffrey Silberberg" <jsilberberg@xxxxxxxxxxxxxx>]

Tim,

 

        If you have the $$s for a package, look at one of the High Availability packages like Mimix. They have been doing this type work since the early days of the Sys/38 and there products as well as the others on the market are perfect for this type of task. 

 

        If you can not spend $$ then look at turning on Journaling with the Journal Receiver on the remote system.  You can then roll your own code to receive the JE's on the parallel system and apply the changes to the duplicate physical files...

 

        Also, I am not sure it's status interm os $$s but IBM also has the Data propagator product..

 

 Jeffrey M. Silberberg
Independent Consultant
CompuDesigns, Inc.

 

AS SOON AS I KNOW THE ANSWERS
THEY CHANGE THE QUESTIONS

----- Original Message -----

From: Tim Truax

To: MIDRANGE-L@midrange.com

Sent: Wednesday, August 08, 2001 5:30 PM

Subject: Most efficient AS400 physical file building ?

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