Re: How can I speed up the copying of data using DDM and field selection.

[a4g atl <a4ginatl2@xxxxxxxxx>]

I forgot to add earlier. This is a i2i copy.

Darryl

On Thu, Aug 10, 2017 at 12:24 PM, a4g atl <a4ginatl2@xxxxxxxxx> wrote:

> For SOX reasons, I have no access other than READ rights.
>
> Darryl
>
> On Thu, Aug 10, 2017 at 9:53 AM, Paul Therrien <
> paultherrien@xxxxxxxxxxxxxxxxxx> wrote:
>
> > Can you copy the data on the other system to a temporary file on that
> > system, selecting the records you want, and then copy the temp file to the
> > target system?
> >
> >
> > Paul
> >
> > -----Original Message-----
> > From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
> > a4g
> > atl
> > Sent: Thursday, August 10, 2017 9:44 AM
> > To: midrange-l@xxxxxxxxxxxx
> > Subject: How can I speed up the copying of data using DDM and field
> > selection.
> >
> > We do not have a relational database entry for our production system so I
> > cannot use SQL to copy data from the production system.
> >
> > I am using DDM and CPYF with field testing. The problem is I am trying to
> > copy 100k records from a file that has over 800 million records. CPYF does
> > not do the selection on the source system and instead appears to copy all
> > 800 million records to the test system where it checks the values and
> > either
> > writes the records or discards them. This takes forever to copy.
> >
> > I have read rights to the file on the source system.
> >
> > Is there another way to speed up the copy?
> >
> > TIA
> >
> > Darryl Freinkel
> > --
> > 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.
> >
> > Please contact support@xxxxxxxxxxxx for any subscription related
> > questions.
> >
> > Help support midrange.com by shopping at amazon.com with our affiliate
> > link:
> > http://amzn.to/2dEadiD
> >
> > --
> > 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.
> >
> > Please contact support@xxxxxxxxxxxx for any subscription related
> > questions.
> >
> > Help support midrange.com by shopping at amazon.com with our affiliate
> > link: http://amzn.to/2dEadiD