DB2 replication

Posted on 2006-05-30
Last Modified: 2011-04-14
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?
Question by:Tol_cv
    LVL 5

    Expert Comment

    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:

    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
    LVL 4

    Author Comment

    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
    LVL 7

    Accepted Solution

    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.


    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
    Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now