DoBroadcast Communication Parameter [DBROAD]

Performs a broadcast to search for servers.

Usage

TCP/IP (all platforms)

Values

ALL, NONE, DIRECT (Client side)

YES, NO (Server side)

Default

ALL

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.

For 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 it is not generally recommended.

Example

  • 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

Related reference
Certificate Communication Parameter
ClientPort Communication Parameter [CPort]
Host Communication Parameter [IP]
ServerPort Communication Parameter [PORT]