• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 767
  • Last Modified:

DB2 replication

Hi,
we have a server with 2 db2 instances (2 databases on each instance).
i need to  replcate them to a diffrent host  ( in  2 instances).
one of the instance has  a very busy  db - lot of connections and querys...

db2 version is  7.1

what  will be the best strategy tu use?
0
Tol_cv
Asked:
Tol_cv
1 Solution
 
ocgstylesCommented:
Hi Tol_cv,

Using DB2's Replication Center sounds like the best option, but, from the looks of it, it is questionable on whether it is a part of the version you are using.  Here's a link to an IBM RedBook on it:

http://www.redbooks.ibm.com/redbooks/SG246828.html

Section/Chapter 1.1 summarizes which versions are covered:
    DB2 replication provides change-based replication for the IBM database family, including:
         DB2 Universal Database for z/OS and OS/390 Versions 6, 7, and 8
         DB2 DataPropagator for z/OS and OS/390 V8
         DB2 Universal Database for iSeries on OS/400 V5R2
         DataPropagator for iSeries V8
         DB2 Universal Database Version 8 for Windows, UNIX, and Linux.

So, this option depends on which platform you are using, hopefully z/OS or OS/390 as this article suggests...

Hope this helps...

- Keith
0
 
Tol_cvAuthor Commented:
more details about the situation:
 - i need a repliceation update anyware scenario - data can be added also in  the target db and replicated to the source db
-  on failover , the target db must be able  to take over all source   functions.

the rest of the aplication is disaster protected with heartbeart and drbd. the  open issue is for us the db failover scenario
0
 
sachinwadhwaCommented:
Always remeber replication is not immediate and is not ideal for Disaster recovery.

If your server1 fails server2 can take over but recent transaction which are server1 and not yet replicated to server2 will be lost...

secondly, you cannot replicate system tables. so, identity columns or sequences will generate duplicate values in server2.

for DR, look for high availibity solutions from DB2...again...replication is not for DR.

HTH..
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now