SA Service - startup behavior

[former_SQLA_member1694870]

The -s parameter does not seem to take effect in the startup behavior as described in the documentation:

-s Sets the startup behavior for SQL Anywhere services. You can set startup behavior to Automatic or Manual. The default is Manual.

Below is the statement I used to create the service with -s Automatic :

opt/sqlanywhere12/bin32s$ sudo ./dbsvc -as -t network -w db12 -n ubuntubox -x tcpip -c 10m -s Automatic @/home/user/test/dbtest.txt

The dbsvc -g db12 statement is listing the startup=Manual as below:

...
SQLANYDIR=/opt/sqlanywhere12
STARTUP=Manual
SVC_TOOL_CMDLINE="-n ubuntubox -x tcpip -c 10m -s Automatic @/home/user/test/dbfiles.txt -ud"
...

Ubuntu 12.04 LTS 32-bit
SA 12.0.1_3723

Is the -s parameter somehow tied to the type of account of the user who created the service?

[Dan_Cummins · Accepted solution]

-s Automatic is correct; it is a flag to dbsvc, though, and above it looks like it was put in the command line for dbsrv12/dbeng12

For it to be recognized as a flag to dbsvc, and not to dbsrv12, it should appear before the -w flag when creating the service.

So the dbsvc command line should look like:

dbsvc <dbsvc_switches> -w <service_name> <dbsrv_switches>

[former_SQLA_member1694870 · Accepted solution]

Thanks for the clarification! I should have paid more attention to the syntax!