Host parameter (IP)

TCP/IP (all platforms) Server and client sides

Server and client sides

HOST specifies additional machines outside the immediate network to be searched by the client library. On the server, the search is carried out to avoid starting a server with a duplicate name.

For TCP/IP, the hostname or a dot-separated IP address may be used.

The server prints this addressing information during startup if the -z switch is used. In addition, the application writes this information to its logfile if LogFile is specified (Debug is set to TRUE).

You can use a semicolon-separated list of addresses to search for more than one machine. Also, you can append a port number to an IP address using a colon as separator. Alternatively, you can specify the host and server ports explicitly, as in Host=nnn.nn.nnn.nnn;ServerPort=pppp.

IP and HOST are synonyms when using TCP/IP.

String

No additional machines.

• The following connection string fragment instructs the client to look on the machines “kangaroo” and 197.75.209.222 (port 2369) to find a database server called iqdemo:

  ...ENG=iqdemo CommLinks=tcpip(IP=kangaroo;IP=197.75.209.222:2369)
  

• For UNIX, quotation marks are required around the TCP/IP options:

  dbisql -x "tcpip(HOST=kangaroo;HOST=197.75.209.222)" iqdemo
  

• The following connection string fragment instructs the client to look on the machines my_server and kangaroo to find a database server. A connection is attempted to the first host that responds.

  dbisql -c "UID=DBA;PWD=sql;LINKS=tcpip(HOST=my_server,kangaroo;PORT=2639)"