Specifies how the database server reacts to broadcasts.
iqsrv16 -sb { 0 | 1 } ...
TCP/IP.
The database server starts one or more UDP listeners so that it can respond to three types of broadcasts:
client connection broadcasts looking for this server.
database server enumeration broadcasts (such as those from the dblocate utility or the Find Servers Wizard of the administration tools Connect window).
broadcasts sent by another database server that is looking for any database servers with the same name.
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 -sb option controls the behavior of the UDP listeners within the database server.
When the -sb option is not specified, the database server responds to all three types of requests.
If you specify -sb 0, then the database server responds to (3) only. This 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. Since the database server does not respond to database server enumeration broadcasts, the database server is not included in the output of dblocate.
If you specify -sb 1, then the database server responds to (1) and (3). Since the database server does not respond to database server enumeration broadcasts, the database server is not included in the output of dblocate.