idea HA Database connections in Data Management Ideas

HA Database connections

VaibhavS — Wed, 21 Jun 2023 13:51:31 GMT

Allow the ability to connect to a HA database in the Add database connection box.

HostName=<host1, host2>;Port=<port number>;Database=<database name>;

For example (IBM DB2)

If your Db2 database is on server cube1 and cube 2, communicating through DBMS port 50000, and the database name is spatialdata, the connection string would be as follows:

Hostname=cube1, cube2;Port=50000;Database=spatialdata;

By specifying two IP addresses within the database connection string, ArcGIS Pro will attempt to connect to the first IP address. If it is unavailable, it will automatically failover to the second IP address. This should provide HA capabilities by ensuring a connection is established even if one of the database servers becomes inaccessible.

Re: HA Database connections

MarceloMarques — Fri, 21 Jul 2023 19:03:00 GMT

@VaibhavS - I am not a DB2 expert, I am an Oracle guy, but each RDBMS has High Availability Features that can be configured to achieve what you are describing, please see the DB2 High Availability feature "Automatic Client Re-route" Automatic client reroute roadmap - IBM Documentation.

This kind of functionality is best handled by the RDBMS software through the RDMBS High Availability Features and not through the client application. e.g., ArcGIS Pro.

You might want to discuss this with your DB2 Database Administrator.

Re: HA Database connections - Status changed to: Closed

SSWoodward — Fri, 21 Jul 2023 18:55:06 GMT

Thanks for the Idea @VaibhavS

@MarceloMarques is correct. This type of functionality should be managed at the RDBMS level and not through the connection file.

The DB2 specific documentation linked should provide you with a roadmap for configuring this for your organization.