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

[a4g atl <a4ginatl2@xxxxxxxxx>]

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