Server Connection
ACEINT can be connected to a local or a remote CONNX JDBC server.
Server Name or Parameter | Description |
DD= | The name of the DSN that you want to use for the connection. This parameter MUST be supplied. If the DSN is the first or only value in the server_name parameter, the prefix 'DD=' can be ignored. |
GATEWAY= | The name of the computer on which the CONNX JDBC Server is running. If not supplied, the default value of LOCALHOST will be used. |
PORT= | The port number of the CONNX JDBC Server. If not supplied, the default value of 7500 will be used. |
Local Server Connection
With a local server connection, ACEINT and the CONNX JDBC Server are located on the same computer.
In this case, the GATEWAY connection parameter must be set to LOCALHOST or the actual name of the computer on which ACEINT is being executed. Here is an example:
ACEINT -nDD=<MYDSN>,GATEWAY=LOCALHOST,PORT=7500 -u<MYUSER>
Remote Server Connection
With a remote server connection, ACEINT and the CONNX JDBC Server are located on different computers.
In this case, the GATEWAY connection parameter must be set to the name of the computer on which the CONNX JDBC Server is running. Here is an example:
ACEINT -nDD=<MYDSN>,GATEWAY=<REMOTEHOST>,PORT=7500 -u<MYUSER>
Multiple Server Support
ACEINT can support multiple CONNX JDBC Servers. By providing a list of CONNX JDBC Servers in the GATEWAY connection parameter, ACEINT will attempt to connect to the first active JDBC Server until the list is exhausted. The syntax is as follows:
HOST:PORT<!HOST:PORT<!HOST:PORT>[!DISTRIBUTE]
HOST - The name of the computer on which the CONNX JDBC Server is running.
PORT - The port number of the CONNX JDBC Server running on 'HOST'.
Each JDBC Server in the list should be separated by an exclamation mark character (!).
Example:
ACEINT -nDD=<MYDSN>,GATEWAY=<HOST1:PORT1!HOST2:PORT2!HOST3:PORT3> -u<MYUSER>
The DISTRIBUTE option can be added to the list of JDBC Servers. By using this option, ACEINT will randomly choose a JDBC Server from the list to which to connect. This is used for load balancing purposes. Here is an example:
ACEINT -nDD=<MYDSN>,GATEWAY=<HOST1:PORT1!HOST2:PORT2!HOST3:PORT3!DISTRIBUTE> -u<MYUSER>
If you are using multiple server support, the PORT= parameter is not required and should not be used.