How to configure a linked DB2 server on 64-bit SQL Server 2005?

Question

I need to create a linked server in a DB2 database on a mainframe. Has anyone done this successfully in 64-bit version of SQL Server 2005? If so, which provider and settings were used?

It is important that the linked server works regardless of whether we use an authenticated Windows account to log in to SQL Server or to log in to SQL Server. It is also important that both 4-part functions and OPENQUERY query methods are functional. We have one setup on a SQL Server 2000 machine that works well, but it uses a provider that is not available for 64-bit SS 2005.

Answer 1

We had the same problem with the production system at the end of last year (sept 2007), and the official word from our Microsoft contact was that they had a 64-bit oledb driver for connecting to ASI / DB2 , but it was in BETA while.

Not sure when it will be out of beta, but that was news from last year.

We decided to transfer the production server to a 32-bit machine, since it was inconvenient for us to use beta drivers in production systems.

I know this does not answer your question, but hopefully gives you some insight.

Answer 2

Which supplier do you use for Sql 2000? I am sure that MS has an x64 OLEDB driver for DB2 (part of Host Integration Server, but available as a separate download). IBM has x64 for .NET and ODBC, as well as OLEDB (although this is PITA).

Once you get the setup of the linked server, I'm sure that all your other requirements will be automatically ...

Answer 3

From Sql 2005 February 2007 Feature Pack :

The Microsoft OLE DB Provider for DB2 is a COM component for integrating vital data stored in IBM DB2 databases with new solutions based on Microsoft SQL Server 2005 Enterprise Edition and Developer Edition. SQL Server developers and administrators can use Integration Services, Analysis Services, Replication, Reporting Services, and Distributed Query Processor. Run the self-extracting download package to create the installation folder. One installer will install the provider and tools on x86, x64, and IA64 computers.