Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2011
    Posts
    4

    Unanswered: DB2 UDB on Linux (x86 hardware) / TSA MP Cluster

    We have an Active / Passive Cluster built using DB2 UDB ESE V9.7 /TSA-MP on Linux 5.5 ( x86 hardware). The clustering software used is TSA-MP.

    Node 1 - hosts ACTIVE -DB2 Database-1

    Node 2 - hosts PASSIVE DB2 Database-1 (remains down as its passive - becomes Active if and when there are os/hardware failures on Node 1)


    My Question is: Can we have a Active Instance on the Passive Node2 ?? Would TSA MP support that configuraiton?


    For Example:
    Node 1 - hosts ACTIVE -DB2 Database-1 and PASSIVE-DB2 Database-2 (remains down as its passive - becomes Active if and when there are os/hardware failures on Node 2)


    Node 2 - hosts ACTIVE-DB2 Database-2 and PASSIVE-DB2 Database-1 (remains down as its passive - becomes Active if and when there are os/hardware failures on Node 1)


    Has anyone attempted the above configuration ?

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Yes you can. Yes it would. The databases will need to be in different instances for increased reliability.

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    yes we have db active in both nodes with the same instance..
    do not forget .. if activating both nodes : 2 licenses are required
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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