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 ?

Yes you can. Yes it would. The databases will need to be in different instances for increased reliability.

yes we have db active in both nodes with the same instance..
do not forget .. if activating both nodes : 2 licenses are required