asked on

DB2 replication

hi,

any one know what is the replication technology available for DB2?

Pawan Kumar

You can use -

IBM's InfoSphere Data Replication for DB2

marrowyung

ASKER

any offical link describe what technology it use, sync, asyc , etc. ?

Pawan Kumar

Please refer this directly from IBM, it has the entire methods and their roadmaps.

https://www.ibm.com/support/knowledgecenter/en/SSTRGZ_11.4.0/com.ibm.swg.im.iis.db.repl.intro.doc/topics/iiyrsinfroadmap.html

marrowyung

ASKER

it seems it is for all type of replication, CDC and publisher, right?

Pawan Kumar

Yes I think so.

Kent Olsen

Hi marrowyung,

If you're using a licensed version of DB2 you may/should have access to DB2's HADR tools and should be able to set up as many replicated servers as you want without depending on 3rd party software.

Kent

marrowyung

ASKER

hi,

"HADR "

what is the full feature of IBM HADR? only replication? DR also one of this, right?

tks.

SOLUTION

Pawan Kumar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

marrowyung

ASKER

ethis including bi direction replication between primary and secondary ?

In MySQL, it use replication to handle multi master model as well as active active, e.g. slave can be read only too as well as both primary and secondary can be read/write, can DB2 do this ?

SOLUTION

Kent Olsen

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Tomas Helgi Johannsson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Kent Olsen

Hi Tom,

Sometimes my world is so isolated from the real world that things like that get past me. I had no idea it existed.

Thanks!
Kent

Now if I just had an environment where I could play with it!!! :)

marrowyung

ASKER

tks.