ACEINT can be connected to a local or a remote CONNX JDBC server.
|
Server Name or Parameter |
Description |
|
DD= |
The name of the DSN to be used 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. |
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.
Example:
ACEINT -nDD=<MYDSN>,GATEWAY=LOCALHOST,PORT=7500 -u<MYUSER>
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.
Example:
ACEINT -nDD=<MYDSN>,GATEWAY=<REMOTEHOST>,PORT=7500 -u<MYUSER>
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.
Syntax:
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.
Example:
ACEINT -nDD=<MYDSN>,GATEWAY=<HOST1:PORT1!HOST2:PORT2!HOST3:PORT3!DISTRIBUTE> -u<MYUSER>
Note:
If you are using multiple server support, the PORT= parameter is not required and should not be used.