IBM Support

DB2 LUW VIP with TSA and HADR with more than one database

Question & Answer


Question

Can you use a single Virtual IP address for multiple databases in a TSA managed HADR configuration?

Answer

It is recommended that you use a separate Virtual IP address (VIP) for each database configured in a HADR TSA cluster.

When fail over occurs in a TSA managed HADR environment then the VIP will be moved with the database the VIP was configured for.

This will mean that if there are multiple databases configured to use HADR then some database could be still running on the original server but the VIP address will no longer exist on that server. If users then try to access the database that has not failed using the VIP address then they will be connecting the Standby server for this database and will receive an error.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"High Availability - HADR","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"9.7;9.5;10.1;10.5","Edition":"Advanced Enterprise Server;Advanced Workgroup Server;Enterprise Server;Express;Personal;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21675595

Page Feedback