DB2 -> SYBASE, database link or replication posibilities

[Arien Smit]

Hello,

Does anybody know if it is possible to replicate data from DB2 to
Sybase thru some kind of link or other setup. DB2 needs to be leading
but data needs to go to Sybase.

Any hints, tips or pointers are welcome.
Appreciate taking the time to help!

Thnx,

ar...@atex.nl

[Blair Kenneth Adamache]

You need IBM Datajoiner and IBM Datapropagator to do this.

[Chris Baker]

Try Sybase Replication Agent for DB2 and Sybase Replication Server.

Chris

Arien Smit wrote in message <36593373...@news.inter.nl.net>...

[Elliott Shirley]

I am working with DB2 to Sybase using Datajoiner, replication. It is also
possible using SAS. Sybase has a OmniConnect piece of software that is
similar to IBM Datajoiner. Also, I wonder about Adptive Server 11.5 with
"Component Services" I am not sure what I it does. It seems that it says
that it can do something like bridge DB2 to Sybase, not replication though.
I am not up on 11.5 yet.

Elliott Shirley
eshi...@uhc.com

[Albert Wu]

Arien,

There are many options, but the two most obvious ones would be:

1. Use the IBM Datajoiner and IBM Data Propagator products. (if you are the
IBM fan...)

2. Use Sybase's OmniConnect (Extended Enterprise Option if you are using
ASE) product. You may want to use this in conjunction with Sybase
Replication Server, depending on the frequency and volume of your
replication).

If DB2 is running in MVS or OS/390, there are corresponding mainframe
products you will need to obtain from either IBM or Sybase to make the whole
chain work. (For Sybase, you need Sybase MainframeConnect, I am not sure
about IBM...) Of course, don't leave out some sort of SNA services if you
are connecting via SNA...

ahh... the fun and joy of mainframe database connectivity...

albert wu
UCLA AIS
albe...@ucla.edu

[Kenneth Lahn]

Do NOT use Sybase's rep Server. It has consistently caused problems at two
shops where I've worked, and it took them 6 months to support DB2 V5.

Datajoiner/DPROPR is a better solution. BMC also has a propagation
solution, but I don't know if it supports Sybase.

Kenneth Lahn

[Lucky. W.]

Kenneth Lahn wrote:

Rep is a great product, it is quite stable. Just check how many EBF sybase
releases, you will know it is very stable.

[whar...@datamirror.com]

Arien, please take a look at DataMirror Transformation Server. You can get
more information at www.datamirror.com

In article <36593373...@news.inter.nl.net>,

ar...@sysdeco.nl (Arien Smit) wrote:
> Hello,
>
> Does anybody know if it is possible to replicate data from DB2 to
> Sybase thru some kind of link or other setup. DB2 needs to be leading
> but data needs to go to Sybase.
>
> Any hints, tips or pointers are welcome.
> Appreciate taking the time to help!
>
> Thnx,
>
> ar...@atex.nl
>

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

[Harold Hotelling III]

Take a look at DB2 DataJoiner - it ships with replication software
that'll replicate data between DB2 and many other vendors' databases
(including Sybase).

http://www.software.ibm.com/data/datajoiner

--
--------------------------------------------------------------\
| Harold Hotelling III (har...@umich.edu) |
|--------------------------------------------------------------
|int main(int x){int z=1;y:x?(z*=x--):z;if(x)goto y;return z;}|
\--------------------------------------------------------------