By default, the database server starts one or more UDP listeners so that it can receive UDP broadcasts from client applications
and respond to these broadcasts appropriately.
For embedded SQL connections the dblocate utility and db_locate_servers function cause broadcast packets to be sent out on
local networks in an attempt to find all database servers. The UDP listener within the database server then responds back
to the sender with information about how to connect to the database server.
The UDP listener can also be involved in client connection requests.
The -sb option controls the behavior of the UDP listeners within the database server.
Using -sb 0 stops the database server from starting any UDP broadcast listeners. This behavior forces clients to use a Host
connection parameter or HOST protocol option when connecting to the database server. In addition if the server is using a
port other than the default port (2638), then the client must also specify the server's port. When -sb 0 is specified, the
database server cannot respond to broadcast requests from dblocate, and therefore the database server is not included in the
dblocate output.
Using -sb 1 stops the database server from responding to broadcasts from dblocate, so it is not found or listed. The UDP listeners
still start so that they can respond to requests from clients that are attempting to connect to the database server.
Syntax