DBLink to a SQL server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

samabdelmalek@gmail.com - 16 Aug 2006 18:46 GMT

Hi,

is there a way in DB2 to have a db link to a remote table in SQL Server
2000 and be able to insert data in that table?
I have 2 systems that need to access the same information almost real
time (one app uses SQL Server and the other uses DB2) so immediately
after a user enters information in DB2, I would like the data to be
pushed real time into the SQL Server 2000 tables. I thought the easiest
way is to have a DBLink to those SQL tables and insert the data inside
DB2 if it is possible!

Any help or suggestions on a solution would be greately appreciated.
Sam

Reply to this Message

Shashi Mannepalli - 16 Aug 2006 19:01 GMT

Yes in DB2 UDB you can use

INFORMATION INTEGRATOR/FEDERATED DATABASES to accomplish this

1. Create wrapper

I think for SQL Server u have to use something like this

CREATE WRAPPER odbc LIBRARY 'db2rcodbc.dll'

check the CREATE WRAPPER statement for further details.

2. Create Server

3. Create usermappings

4. Create Nicknames

cheers...
Shashi Mannepalli

> Hi,
>
[quoted text clipped - 9 lines]
> Any help or suggestions on a solution would be greately appreciated.
> Sam

Reply to this Message

Shashi Mannepalli - 16 Aug 2006 19:02 GMT

Once you set this setup.....u can use REPLICATION to accomplish the one
u are mentioning....

Shashi Mannepalli

> Yes in DB2 UDB you can use
>
[quoted text clipped - 30 lines]
> > Any help or suggestions on a solution would be greately appreciated.
> > Sam

Reply to this Message