DB2 replication

hi,

any one know what is the replication technology available for DB2?
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
Become a Certified Penetration Testing Engineer

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

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 OlsenDBACommented:
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 KumarDatabase 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 OlsenDBACommented:
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
Tomas Helgi JohannssonCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Kent OlsenDBACommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB2

From novice to tech pro — start learning today.