• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 757
  • 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

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

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