Connectivity Enhancements
Support for Multiple Data Access Servers
Changes to Ingres configuration tools and to port syntax provide greater flexibility in configuring environments.
This enhancement makes it possible to configure multiple Data Access Servers (DAS) in Configuration-By-Forms (CBF) and Configuration Manager (VCBF). It also lets you specify multiple ports in the JDBC connection URL or the Ingres .NET Data Provider connection string.
In CBF or VCBF, for the Data Access Server component, you can specify a startup count from 1 to 15. On the port parameter, the listen address for the network port can be a numeric port identifier or an Ingres symbolic port identifier such as II7.
If you specify a startup count greater than 1, CBF adds a + designator to the specified port identifier. If a listen is attempted on a port identifier with a + designator, the address is incremented (rolled up) and a listen attempt is made on the next address.
If the specified startup count is greater than 1 and any TCP numeric ports are found, CBF prompts the user as to whether numeric ports should roll up. If the user selects NO, CBF resets the startup count to 1 and removes all rollup designators for TCP existing ports, whether specified as numeric or not.
Although numeric ports can be rolled up (for example, 28750+ will roll up to 28751, 28752, and so on), rollup may not be wanted because numeric ports are often specified for security reasons.
Assuming most installations will want to run the Net and DAS servers in the existing port configuration, the Net Server default configuration remains as a two-character port code, representing the installation code, and the DAS server default configuration remains as XX7, where XX is the installation code.
Example Configuration and Connection Data--The following configuration, specified in CBF or VCBF, will start four Data Access Servers listening on symbolic ports II7, II8, II9, and II10:
DAS startup count: 4
tcp_ip status: ON
tcp_ip port: II7+
A JDBC client can then use the following URL to connect:
jdbc:ingres://host:II7,II8,II9,II10/dbname;UID=user;PWD=password
For more information, see the Connectivity Guide chapters "Configuring the Data Access Server," "Understanding JDBC Connectivity," and "Understanding .NET Data Provider Connectivity."