Since I just demonstrated my method below for copying works, I don't understand why you would not use it?
<< This can be easily done if the command is issued on the test system.
<<First create an SQL index or logical file on the source system that has the desired selection criteria.
<<Then create a DDM file on the test system that points to the logical on the source system.
<<Then run the CPYF command on the test system that uses the DDM file as the input.
<<We have a physical file on a source system that has 68 million records.
<<It has an SQL index whose selection criteria results in just 1626 entries.
<<The CPYF using the DDMF is almost instant and the test system ends up with just the desired 1626 entries.
Peter
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of D*B
Sent: Saturday, 12 August 2017 4:42 AM
To: Midrange Systems Technical Discussion
Subject: [IE] Re: How can I speed up the copying of data using DDM and field selection.
<Rob>
Then why, in our Cognos environment, were we getting abysmal performance connecting from those servers to Db2 until we changed the statements to openquery type things?
</Rob>
... the database monitor could give you the answer, or paying two days to teach by example how to use it, I could give you the answer.
D*B
--
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 correspondence is for the named person's use only. It may contain confidential or legally privileged information, or both. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this correspondence in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or rely on any part of this correspondence if you are not the intended recipient. Any views expressed in this message are those of the individual sender, except where the sender expressly, and with authority, states them to be the views of Equifax. If you need assistance, please contact Equifax :- Australia www.equifax.com.au/contact New Zealand www.equifax.co.nz/contact ##############################################################
midrange.com
