Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2007
    Posts
    15

    Unanswered: Seeking DB2/AIX64 9.1.5 desaster recovery solution

    Hello DB2 Experts,

    We have a Production system that is currently using disc sync to a remote location. But to get the data mounted and function it'll take minimum 2 minutes.

    We have DB2/AIX64 9.1.5, what would be the best way to have the Production and DR box sync with no downtime at all?

    Thanks!

  2. #2
    Join Date
    Apr 2008
    Posts
    51
    If failover time of 2 minutes does not meet your needs, I do not think there is anything else out there that will.
    db2topgun.com

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    HADR coupled with a cluster manager to switch virtual IP addresses will work faster than 2 mintues, usually within 10-20 seconds. I would recommend near-sync mode in HADR.

    The only issue is how long it takes for the cluster manager to detect a failure and issue the HADR takeover commands.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Alternatively, have a look at this :

    GRIDSCALE Database Virtualization | GRIDSCALE for DB2

    Seems to be endorsed (well, I am using the term loosely) by IBM.

    xkoto | Technical Support

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by sathyaram_s
    Alternatively, have a look at this :

    GRIDSCALE Database Virtualization | GRIDSCALE for DB2

    Seems to be endorsed (well, I am using the term loosely) by IBM.

    xkoto | Technical Support

    Cheers
    Sathyaram
    At one time about 2 years ago, IBM was strongly hinting that it was in the process of bying xkoto, but something happened and the deal fell through. We tried it at my company, and it scales well for read type queries, but does not work as well for heavy updates. And despite what they tell you, there is still a single point of failure on the load balancer (which has its own cluster/failover mechanism, but that failover is no better than HADR failover).
    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
  •