The SQL Anywhere 11.0.1 Help is incorrect when it says the -xd option only applies to the network server... it applies to dbeng11 as well as dbsrv11.
The -xd option (see Help here) was introduced in 11.0.1 to prevent the database server from becoming the default database server... for 99.99% of the world's SQL Anywhere installations, accidentally connecting to the wrong database server because "it's the default" or some other goofy reason is a clear and present danger, and anything one can do to prevent that from happening is a good idea.
That's my opinion, anyway... the other 0.01%, I've never met, they may not exist.
Testimonials: The SQL Anywhere Monitor that comes in the box uses -xd. Foxhound (now) uses -xd. You should too. It should be the default.
Also highly recommended is -sb 0 to stop the engine from listening for UDP broadcasts ...but that's another topic. BTW, both the SQL Anywhere Monitor and Foxhound specify -sb 0 as well as -xd.
asked 25 Mar '10, 12:11
answered 19 Aug '10, 16:30