I've started a thread regarding a DB2 linked server in MS-SQL 2005 in the MS-SQL forum.

Since it is about equally likely that someone here in the DB2 camp might be able to contribute, I'd appreciate it if any interested parties here would join the discussion.

Thanks!
-PatP

Do you use MS or IBM ODBC driver for DB2?

I'm using DB2 Connect Enterprise Edition, Version 8 (c) 2004.

FWIW, some of the queries that actually failed at the client when run appear to have run on for 60-100 minutes on the host. They eventually invoked some of the WorkLoad Manager stored procedures (more than an hour after the query failed).

My, what fun!

-PatP

See if this helps:

http://www-01.ibm.com/support/docvie...=utf-8&lang=en

I thought that you might have found something wonderful, that somehow I might have missed applying FixPack 8 even though my notes showed that it had been applied. No such luck.

Either I have another problem, or they fixed the problem in FixPack 6 then reintroduced it later.

I'm still working on this one, but thanks for your effort!

-PatP

I've got the combination of FixPack 14 and the MS-SQL OpenQuery() syntax working, which is good enough to get me by from a syntactic standpoint (it means that I need to rewrite the queries, but that is livable). It will be a few days before I know if this is tolerable based on zOS performance and resource utilization.

I'd appreciate any additional comments that anyone can offer.

-PatP