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

Dieter is correct. I also plan to use the JDBC as the medium and the
selection is always done on the remote system.

For all contributing here, many are missing the point that I cannot do
anything on the remote system other than run READ commands. So creating
extract files etc. is not possible.

Cognos' problem is probably that it is developed in MS SQL and MS SQL uses
the basic Select on the call to the remote system. I had this problem
several years ago and changed the selects to use FROMQUERY a MS SQL command
which passes the string command to Db2 which selects the records on the
remote system and only returns the selected data.

Darryl

On Fri, Aug 11, 2017 at 4:58 PM, Peter Connell <Peter.Connell@xxxxxxxxxxx>
wrote:

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