Specifies how the database server reacts to broadcasts.
TCP/IP.
This option has not been fully tested with servers in the cloud.
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.