Linking DB2 Database in SQL Server 2000 
Author Message
 Linking DB2 Database in SQL Server 2000
I am trying to link a DB2 (AS/400) database to my SQL Server 2000. Can
anyone recommend the best driver to use please? I will mostly be reading
from the linked server and performance is critical.

I would like to use the DB2OLEDB driver provided by Microsoft, however, I
think I can only get this through Host Integration Server. I do not want to
install HIS and also do not want to create a DSN as this would cause a
negative impact on performance.

If anyone has done this, please let me know.

Many thanks

Paul G



Tue, 20 Jul 2004 23:32:36 GMT
 Linking DB2 Database in SQL Server 2000

I've used Hit before for this but if you don't want to go
that route, Client Access has an OLE DB provider. You need
to make sure you are on the current version and that you
keep track of updates to the 400 and update your Client
Access install on the SQL Server box as needed to stay in
sync with the 400.

--Sue

On Fri, 1 Feb 2002 15:32:36 -0000, "Paul Gunaselvam"

Quote:

>I am trying to link a DB2 (AS/400) database to my SQL Server 2000. Can
>anyone recommend the best driver to use please? I will mostly be reading
>from the linked server and performance is critical.

>I would like to use the DB2OLEDB driver provided by Microsoft, however, I
>think I can only get this through Host Integration Server. I do not want to
>install HIS and also do not want to create a DSN as this would cause a
>negative impact on performance.

>If anyone has done this, please let me know.

>Many thanks

>Paul G



Tue, 20 Jul 2004 23:28:36 GMT
 Linking DB2 Database in SQL Server 2000
Sue

Many thanks for your reply. I know the Microsoft's provider is called
DB2OLEDB. What is the name of the provider installed by the Client Access
(the name to be used in sp_addlinkedserver)?

And does this have any performance issues?

Many thanks again

Paul G


Quote:
> I've used Hit before for this but if you don't want to go
> that route, Client Access has an OLE DB provider. You need
> to make sure you are on the current version and that you
> keep track of updates to the 400 and update your Client
> Access install on the SQL Server box as needed to stay in
> sync with the 400.

> --Sue

> On Fri, 1 Feb 2002 15:32:36 -0000, "Paul Gunaselvam"

> >I am trying to link a DB2 (AS/400) database to my SQL Server 2000. Can
> >anyone recommend the best driver to use please? I will mostly be reading
> >from the linked server and performance is critical.

> >I would like to use the DB2OLEDB driver provided by Microsoft, however, I
> >think I can only get this through Host Integration Server. I do not want
to
> >install HIS and also do not want to create a DSN as this would cause a
> >negative impact on performance.

> >If anyone has done this, please let me know.

> >Many thanks

> >Paul G



Tue, 20 Jul 2004 23:49:37 GMT
 Linking DB2 Database in SQL Server 2000
I think the driver is IBMDA400. They did have some examples
of connection settings in their help file.
We switched to Hit due to performance issues - especially
with accessing logical files more than 300K records. But it
was a couple of years ago and they were working on fixes and
improvements so I'm not sure what type of performance you'd
get now.

--Sue

On Fri, 1 Feb 2002 15:49:37 -0000, "Paul Gunaselvam"

Quote:

>Sue

>Many thanks for your reply. I know the Microsoft's provider is called
>DB2OLEDB. What is the name of the provider installed by the Client Access
>(the name to be used in sp_addlinkedserver)?

>And does this have any performance issues?

>Many thanks again

>Paul G



>> I've used Hit before for this but if you don't want to go
>> that route, Client Access has an OLE DB provider. You need
>> to make sure you are on the current version and that you
>> keep track of updates to the 400 and update your Client
>> Access install on the SQL Server box as needed to stay in
>> sync with the 400.

>> --Sue

>> On Fri, 1 Feb 2002 15:32:36 -0000, "Paul Gunaselvam"

>> >I am trying to link a DB2 (AS/400) database to my SQL Server 2000. Can
>> >anyone recommend the best driver to use please? I will mostly be reading
>> >from the linked server and performance is critical.

>> >I would like to use the DB2OLEDB driver provided by Microsoft, however, I
>> >think I can only get this through Host Integration Server. I do not want
>to
>> >install HIS and also do not want to create a DSN as this would cause a
>> >negative impact on performance.

>> >If anyone has done this, please let me know.

>> >Many thanks

>> >Paul G



Tue, 20 Jul 2004 23:57:20 GMT
 Linking DB2 Database in SQL Server 2000
Sue

Many thanks. I think I'll try and find out whether I can down load the
Microsoft's OLE DB Provider for DB2 from somewhere, without having to
install Host Integration Server.

Many thanks again for your help!

Paul G

Quote:
> I think the driver is IBMDA400. They did have some examples
> of connection settings in their help file.
> We switched to Hit due to performance issues - especially
> with accessing logical files more than 300K records. But it
> was a couple of years ago and they were working on fixes and
> improvements so I'm not sure what type of performance you'd
> get now.

> --Sue

> On Fri, 1 Feb 2002 15:49:37 -0000, "Paul Gunaselvam"

> >Sue

> >Many thanks for your reply. I know the Microsoft's provider is called
> >DB2OLEDB. What is the name of the provider installed by the Client Access
> >(the name to be used in sp_addlinkedserver)?

> >And does this have any performance issues?

> >Many thanks again

> >Paul G



> >> I've used Hit before for this but if you don't want to go
> >> that route, Client Access has an OLE DB provider. You need
> >> to make sure you are on the current version and that you
> >> keep track of updates to the 400 and update your Client
> >> Access install on the SQL Server box as needed to stay in
> >> sync with the 400.

> >> --Sue

> >> On Fri, 1 Feb 2002 15:32:36 -0000, "Paul Gunaselvam"

> >> >I am trying to link a DB2 (AS/400) database to my SQL Server 2000. Can
> >> >anyone recommend the best driver to use please? I will mostly be
reading
> >> >from the linked server and performance is critical.

> >> >I would like to use the DB2OLEDB driver provided by Microsoft,
however, I
> >> >think I can only get this through Host Integration Server. I do not
want
> >to
> >> >install HIS and also do not want to create a DSN as this would cause a
> >> >negative impact on performance.

> >> >If anyone has done this, please let me know.

> >> >Many thanks

> >> >Paul G



Wed, 21 Jul 2004 00:21:09 GMT
 Linking DB2 Database in SQL Server 2000
I'm pretty sure you can't download it. You need SNA 4 or
Host Integration Server. It's not part of the standard MDAC.

--Sue

On Fri, 1 Feb 2002 16:21:09 -0000, "Paul Gunaselvam"

Quote:

>Sue

>Many thanks. I think I'll try and find out whether I can down load the
>Microsoft's OLE DB Provider for DB2 from somewhere, without having to
>install Host Integration Server.

>Many thanks again for your help!

>Paul G


>> I think the driver is IBMDA400. They did have some examples
>> of connection settings in their help file.
>> We switched to Hit due to performance issues - especially
>> with accessing logical files more than 300K records. But it
>> was a couple of years ago and they were working on fixes and
>> improvements so I'm not sure what type of performance you'd
>> get now.

>> --Sue

>> On Fri, 1 Feb 2002 15:49:37 -0000, "Paul Gunaselvam"

>> >Sue

>> >Many thanks for your reply. I know the Microsoft's provider is called
>> >DB2OLEDB. What is the name of the provider installed by the Client Access
>> >(the name to be used in sp_addlinkedserver)?

>> >And does this have any performance issues?

>> >Many thanks again

>> >Paul G



>> >> I've used Hit before for this but if you don't want to go
>> >> that route, Client Access has an OLE DB provider. You need
>> >> to make sure you are on the current version and that you
>> >> keep track of updates to the 400 and update your Client
>> >> Access install on the SQL Server box as needed to stay in
>> >> sync with the 400.

>> >> --Sue

>> >> On Fri, 1 Feb 2002 15:32:36 -0000, "Paul Gunaselvam"

>> >> >I am trying to link a DB2 (AS/400) database to my SQL Server 2000. Can
>> >> >anyone recommend the best driver to use please? I will mostly be
>reading
>> >> >from the linked server and performance is critical.

>> >> >I would like to use the DB2OLEDB driver provided by Microsoft,
>however, I
>> >> >think I can only get this through Host Integration Server. I do not
>want
>> >to
>> >> >install HIS and also do not want to create a DSN as this would cause a
>> >> >negative impact on performance.

>> >> >If anyone has done this, please let me know.

>> >> >Many thanks

>> >> >Paul G



Wed, 21 Jul 2004 00:39:42 GMT
 Linking DB2 Database in SQL Server 2000
Good discussion! Paul, let me know if you want me to further research the
topic.

Hope this helps,
Robert Ware
=================================================
*  This posting is provided "AS IS" with no warranties, and confers no
rights.
*  Please do not send email directly to this alias.Respond to newsgroup

Are you secure?  For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit,
please visit http://www.microsoft.com/security.

--------------------

Quote:

>Subject: Linking DB2 Database in SQL Server 2000
>Date: Fri, 1 Feb 2002 15:32:36 -0000
>Newsgroups: microsoft.public.sqlserver.server

>I am trying to link a DB2 (AS/400) database to my SQL Server 2000. Can
>anyone recommend the best driver to use please? I will mostly be reading
>from the linked server and performance is critical.

>I would like to use the DB2OLEDB driver provided by Microsoft, however, I
>think I can only get this through Host Integration Server. I do not want to
>install HIS and also do not want to create a DSN as this would cause a
>negative impact on performance.

>If anyone has done this, please let me know.

>Many thanks

>Paul G



Sat, 24 Jul 2004 01:59:30 GMT
 Linking DB2 Database in SQL Server 2000
Robert

Many thanks for your response. I wonder whether you could aid with the
following from Microsoft's point of view:

We need to link an DB2 Database on an AS/400 to our SQL Server 2000 DB. 99%
of the time, data will be read from the linked server. However, the volume
of data read will be quite high. COM+ components will be using ADO to
retrieve data. We understand that the DB2OLEDB provider is the best to use,
however, the only way to install DB2OLEDB is by actually installing Host
Integration Server 2000. Performance is a critical factor. Based on
scenario:

1) Is there any other way we can use DB2OLEDB other than installing HIS?
(The only reason we do not want to install HIS is that the client will go
"mad" if they hear they need to spend more money on Licences!)
2) If there is no other way, what is the next best thing with optimum
performance and functionality? and how can this provider be installed?
3) What are the drawbacks of using the above provider?

Many thanks in advance. Your help will be greatly appreciated.

Paul



Quote:
> Good discussion! Paul, let me know if you want me to further research the
> topic.

> Hope this helps,
> Robert Ware
> =================================================
> *  This posting is provided "AS IS" with no warranties, and confers no
> rights.
> *  Please do not send email directly to this alias.Respond to newsgroup

> Are you secure?  For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit,
> please visit http://www.microsoft.com/security.

> --------------------

> >Subject: Linking DB2 Database in SQL Server 2000
> >Date: Fri, 1 Feb 2002 15:32:36 -0000
> >Newsgroups: microsoft.public.sqlserver.server

> >I am trying to link a DB2 (AS/400) database to my SQL Server 2000. Can
> >anyone recommend the best driver to use please? I will mostly be reading
> >from the linked server and performance is critical.

> >I would like to use the DB2OLEDB driver provided by Microsoft, however, I
> >think I can only get this through Host Integration Server. I do not want
to
> >install HIS and also do not want to create a DSN as this would cause a
> >negative impact on performance.

> >If anyone has done this, please let me know.

> >Many thanks

> >Paul G



Sat, 24 Jul 2004 19:05:36 GMT
 
 [ 8 post ] 

 Relevant Pages 

1. Linking DB2 Database in SQL Server 2000

2. Linking DB2 database in SQL Server 2000

3. Linked Server SQL 2000 to OS/390 DB2

4. Linking AS400 DB2 to SQL Server 2000

5. Configuring DB2 / AS400 as a Linked server in SQL 2000

6. linking db2 server to sql 2000

7. LINKED SERVERS : How to link MySQL server on SQL Sever 2000

8. linked servers with windows 2000 professional/sql server 2000

9. Linked Server Configuration - SQL Server 2000/Windows 2000

10. How to set a DB2/MVS database as publisher with SQL Server 2000

11. Error accessing IBM DB2 database using SQL Server 2000

12. link SQL SERVER 7.0 and SQL SERVER 2000?


 
Powered by phpBB® Forum Software