IBM Support

Multiple HADR databases but only one VIP

Question & Answer


Multiple DB2 instances and multiple databases but only want to use one virtual IP address. Is this possible ?


For the out-of-the-box HADR automation policy, you cannot share a virtual IP address for multiple databases. If virtual IP addresses are to be used, each HADR database must have its own unique virtual IP. This is a restriction (or limitation) imposed by DB2's db2haicu utility.

From a TSAMP perspective, you could assign a virtual IP address to one of the HADR database and add "collocation" relationships between each of the HADR databases. This will force all HADR databases to be online on the same node at any given time. It means you could never have one HADR database primary/online on one node and a different HADR database primary/online on another node. I must point out that this is not a formally tested scenario.

If you choose to deviate from the standard HADR automation policy, you should thoroughly test all aspects of the solution from startup/shutdown, to automated failovers. For information on making relationships and "collocation" relationships, refer to the TSAMP Administrator's and User's Guide :

[{"Product":{"code":"SSRM2X","label":"Tivoli System Automation for Multiplatforms"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"3.2;3.2.1;3.2.2;4.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
24 June 2019