Results 1 to 5 of 5

Thread: Standby in DB2

  1. #1
    Join Date
    Feb 2007
    Posts
    6

    Unanswered: Standby in DB2

    Dear All,

    I am new to DB2. I want to maintain a standby database for my DB2 database. I don't know what is the exact word for this. Please help me to get the good material with example.


    Thanks in advance
    Mahi

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Mahi,
    "Standby database" is the correct term. What differs in the methodology in actually getting what you want. One method is called "Split mirror". One uses a method called "log shipping". Some sites use DB2's Replication. Others use an active/standy cluster approach. Alot of how you do setup a standby database depends on your particular needs, your resources, and of course money.

    Andy

  3. #3
    Join Date
    Feb 2007
    Posts
    6
    Hi,

    I want to replicate my DB2 Database in another system what is the best approach, i am new to Db2, so please help me to get the material with example.

    Thanks and regards
    Mahi

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Like I said, there are several ways to do this.

    Info on "Split Mirror":
    http://www-128.ibm.com/developerwork.../dm-0508quazi/

    Info on "Log Shipping":
    http://www-128.ibm.com/developerwork...04mcinnis.html

    There is lots of stuff on "replication", use the search at:

    http://www-128.ibm.com/developerworks/db2/


    You can use the site above to find stuff on Clustering also.

    Andy

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I would look at HADR, which available for free with Enterprise Edition, and extra charge for Workgroup and Express Editions.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •