Very Computer

by **Justin Abbot** » Sat, 15 Mar 2003 20:04:30

Hi folks,

I would like to set up a read-only subscription to an
OS390 DB2 database.

a) Can I do this without purchasing 3rd tools?
I tried right click on 'Replication' in enterprise manager
and choosing 'Configure Publishing, Subscribers etc' but I
can only use sql servers as publishers of the data.

b) If not, what is a recommended 3rd party tool for doing
this.

If I cannot set this up the alternative will be to run a
dts job using a linked server to the mainframe every 5
minutes. Not ideal compared to replication if replication
is possible.

Thanks in advance

regards
Justin Abbott

by **Denn** » Sun, 16 Mar 2003 05:51:45

Yes you can do this. Install the DB2 drivers on the SQL Servers. Setup a
publication. When you are asked what kind of subscribers you will have,
select the last option "Heterogeneous". This will allow you to create a
push subscription to your DB2 server.

--
Denny Cherry
Database Administrator
GameSpy Industries

Quote:> Hi folks,

> I would like to set up a read-only subscription to an
> OS390 DB2 database.

> a) Can I do this without purchasing 3rd tools?
> I tried right click on 'Replication' in enterprise manager
> and choosing 'Configure Publishing, Subscribers etc' but I
> can only use sql servers as publishers of the data.

> b) If not, what is a recommended 3rd party tool for doing
> this.

> If I cannot set this up the alternative will be to run a
> dts job using a linked server to the mainframe every 5
> minutes. Not ideal compared to replication if replication
> is possible.

> Thanks in advance

> regards
> Justin Abbott

by **Paul Wina** » Thu, 20 Mar 2003 08:15:38

Are you trying to replicate MS SQL data or DB2 data? In other words,
what system is the publisher?

> Yes you can do this. Install the DB2 drivers on the SQL Servers. Setup a
> publication. When you are asked what kind of subscribers you will have,
> select the last option "Heterogeneous". This will allow you to create a
> push subscription to your DB2 server.

> --
> Denny Cherry
> Database Administrator
> GameSpy Industries

> > Hi folks,

> > I would like to set up a read-only subscription to an
> > OS390 DB2 database.

> > a) Can I do this without purchasing 3rd tools?
> > I tried right click on 'Replication' in enterprise manager
> > and choosing 'Configure Publishing, Subscribers etc' but I
> > can only use sql servers as publishers of the data.

> > b) If not, what is a recommended 3rd party tool for doing
> > this.

> > If I cannot set this up the alternative will be to run a
> > dts job using a linked server to the mainframe every 5
> > minutes. Not ideal compared to replication if replication
> > is possible.

> > Thanks in advance

> > regards
> > Justin Abbott

Very Computer

subscribing to os390 DB2

subscribing to os390 DB2

subscribing to os390 DB2

subscribing to os390 DB2