DB2 replication

hi,

any one know what is the replication technology available for DB2?
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?
 
Tomas Helgi JohannssonConnect With a Mentor Commented:
Hi!

The "multi-master" or active-active database solution that DB2 has is known as pureScale. :)
See further here
And Note that HADR feature can be used with pureScale setups as well. So you can have a complete standby pureScale cluster on separate site(s).  :)

Regards,
     Tomas Helgi
1
 
Pawan KumarDatabase ExpertCommented:
You can use -

IBM's InfoSphere Data Replication for DB2
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
any offical link describe what technology it use, sync, asyc , etc. ?
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
Pawan KumarDatabase ExpertCommented:
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
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
it seems it is for all type of replication, CDC and publisher, right?
0
 
Pawan KumarDatabase ExpertCommented:
Yes I think so.
0
 
Kent OlsenData Warehouse Architect / DBACommented:
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
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
hi,

"HADR "

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

tks.
0
 
Pawan KumarConnect With a Mentor Database ExpertCommented:
IBM also has high availability feature, this document will give you all the details - https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/DB2HADR/page/HADR%20Tutorial
I haven't got a chance to work with this. Good luck.
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
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 ?
0
 
Kent OlsenConnect With a Mentor Data Warehouse Architect / DBACommented:
The IBM model doesn't use a multi master approach like MySQL.  It does use a traditional primary/secondary that allows for multiple secondary.

The normal approach is to bring up the HADR server on each secondary database, then the HADR client on the primary.  Every time a change is made to the primary the change is pushed to each connected secondary.  Any offline secondary database will be caught up to the primary once its HADR server is started.  (The exact role of client and server in the HADR connection is a bit muddled.  The secondary side does not poll the primary as one might expect.  Instead, it sits idle waiting for activity from the primary on the connection.  That reverses the client and server roles, though which side is actually the client is unclear to me.)
1
 
Kent OlsenData Warehouse Architect / DBACommented:
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!!!  :)
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
tks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.