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

That I do not know.


On Thu, Aug 10, 2017 at 1:04 PM, Steinmetz, Paul <PSteinmetz@xxxxxxxxxx>
wrote:

Are both SSD drives?
Paul

Sent from my iPhone

On Aug 10, 2017, at 9:43 AM, a4g atl <a4ginatl2@xxxxxxxxx> wrote:

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