Performs a broadcast to search for servers.
Usage
TCP/IP (all platforms)
Values
ALL, NONE,
DIRECT (client side)
YES, NO
(server side)
Description
- Client usage – with DoBroadcast=ALL (formerly
DoBroadcast=YES) a broadcast is performed to search for a
server. The broadcast goes first to the local subnet. If HOST=
is specified, broadcast packets are also sent to each of the hosts. For TCP, all
broadcast packets are UDP packets.
- With DoBroadcast=DIRECT (formerly
DoBroadcast=NO), no broadcast is performed to the local
subnet to search for a database server. Broadcast packets are sent only to the
hosts listed in the HOST (IP) communication parameter. If you specify
DoBroadcast=DIRECT, the HOST (IP) communication parameter
is required.
- Specifying DoBroadcast=NONE causes no UDP broadcasts to be
used. A TCP/IP connection is made directly with the HOST/PORT specified, and the
server name is verified. With TCP/IP, you can choose not to verify the server
name by setting the VerifyServerName (VERIFY) communication parameter to
NO. The HOST (IP) communication parameter
is a required parameter, while the ServerPort (PORT) communication parameter is
optional.
- DIRECT and NONE, you must specify the server host with the HOST option.
- Server usage – setting DoBroadcast=NO prevents the database
server from broadcasting to find other servers with the same name. This is
useful in certain rare circumstances, but is not generally recommended.
Examples
The following command
starts a client without broadcasting to search for a database server.
Instead, the server is looked for only on the computer named silver.
dbisql -x tcpip(DOBROADCAST=DIRECT;HOST=silver) iqdemo
On UNIX, the options must be enclosed in quotation
marks:
dbisql -x "tcpip(DOBROADCAST=DIRECT;HOST=silver)" iqdemo