Re: Bad performance on Linked Server

[Justin Taylor <jtaylor.0ab@xxxxxxxxx>]

I guess that's what I get for following IBM's example...  :D

You're absolutely correct.  This query works almost as well as native Db2
access:
select column_list_here from linked_server_name.ibm_db_name.schema.table


Thank you


date: Wed, 24 Feb 2021 14:09:48 +0000
> from: Rob Berendt <rob@xxxxxxxxx>
> subject: RE: Bad performance on Linked Server
>
> I think openquery may be the answer.  I have a monthly reminder to beat me
> up side the head with a 2x2 to remind me of this:
>
>
> <snip>
> openquery is just MS SQL Server's technique for a "linked server".  Some
> sql engines always do it.  Some do it within setup or connection
> configuration.
>
> openquery:
> I assume you're trying to set up a linked server?
>
> https://www-01.ibm.com/support/docview.wss?uid=nas8N1014514
>
> Once you get connected, note the following:
>
> -- Pull all rows from the table(s) back to MS SQL server and do the where
> locally
> select * from LINKEDSVR.MYIBMI.MYLIB.MYTBL where locnbr = '00335';
>
> -- Sends the statement to linked server for processing
> select * from openquery(LINKEDSVR, 'select * from MYTBL where locnbr =
> ''00335''');
>
> --OPENQUERY() isn't just for SELECTS
> delete from openquery(LINKEDSVR, 'select * from MYTBL where locnbr =
> ''00335''');
> </snip>
>
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  7310 Innovation Blvd, Suite 104
>           Ft. Wayne, IN 46818
> Ship to:  7310 Innovation Blvd, Dock 9C
>           Ft. Wayne, IN 46818
> http://www.dekko.com