{ BroadcastListener | BLISTENER }={ YES | NO }

TCP/IP (server side)

YES

This option allows you to turn broadcast listening off for this port.

Using -sb 0 is the same as specifying BroadcastListener=NO on TCP/IP.

If broadcast listening is off, then the database server does not respond to UDP broadcasts. This means that clients must use either the HOST= TCP protocol option to specify the hostname of the database server, or register the database server with LDAP and use LDAP on the clients to find the database server. This also means that the dblocate utility does not include the database server in its output.

• -sb dbeng12/dbsrv12 server option
• Broadcast (BCAST) protocol option
• DoBroadcast (DOBROAD) protocol option
• Server Enumeration utility (dblocate)
• Host connection parameter
• Host (IP) protocol option

Start a database server that accepts TCP/IP connections, and requires that TCP/IP connections use the Host connection parameter or Host protocol option:

dbsrv12 -x tcpip(BroadcastListener=NO) ...

The following is a fragment of a client connection string to connect to the database server:

...LINKS=tcpip(...HOST=myhost;...);...