| alingsjtu@gmail.com 2006-10-24, 6:30 pm |
| Thanks, Erland.
I can't use a single query, because linked DB2 server has large scale
data (million level). I had practised to join linked DB2 server tables
with local table, the result was very frustrating, the performance very
low, because local SQL Server fetched all data from linked DB2 server,
then executed the distributed query.
I used the IBM DB2 OLE DB Provider instead of Microsoft OLE DB Provider
For DB2.
Don't know whether this provider support "OLE DB Services = -2;"
property. I should wait to next Monday to test.
Do you think whether things will be better if I use Microsoft OLE DB
Provider For DB2?
And where to get the Microsoft OLE DB Provider For DB2? Could you give
me a link?
Many Thanks.
Tibor Karaszi wrote:[color=darkred
]
> The error comes from DB2, not SQL Server. I Googled below:
> SQLSTATE 57030
>
> And found for instance http://webservertalk.com/t521957.html.
>
> Perhaps each OPENQUERY opens a new connection (or what it is called in DB2 language)? One thing you
> can check is the different settings for remote servers available with sp_configure. But you will
> also want a DB" technician available to troubleshoot this.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
>
>
> <alingsjtu@gmail.com> wrote in message news:1158839897.242268.248990@i42g2000cwa.googlegroups.com...
|