|
Creates, modifies, and deletes SQL Anywhere services.
dbsvc [ modifier-options ] -d svc
dbsvc [ modifier-options ] -g svc
dbsvc [ modifier-options ] -l
dbsvc [ modifier-options ] -u svc
dbsvc [ modifier-options ] creation-options -w svc details
dbsvc [ modifier-options ] -x svc
details:
<full-executable-path> [ options ]
| Major option | Description |
|---|---|
| @data |
Use this option to read in options from the specified environment variable or configuration file. See Using configuration files. If you want to protect passwords or other information in the configuration file, you can use the File Hiding utility to obfuscate the contents of the configuration file. See File Hiding utility (dbfhide). |
| -d service-name | Removes the named service from the list of services. If you supply -y, the service is deleted without confirmation. |
| -g service-name | Lists the definition of the service, not including the password. |
| -l | Lists the available SQL Anywhere services. |
| -u service-name | Start the service named service-name. |
| -w executable parameters |
Creates a new service, or overwrites one if one of the same name exists. If you supply -y, the existing service is overwritten without confirmation. You must supply the full path to the executable that you want to use as a service, as the account under which the service is running may not have the appropriate SQL Anywhere installation directory in its path. You must supply parameters appropriate for the service you are creating. See:
|
| -x service-name | Stop the service named service-name. |
| Creation option | Description |
|---|---|
| -a acct |
All services run under a Windows account. If you run under an account you have created, you must name the account with the -a option and supply a password with the -p option. The Login as a Service privilege is required for all accounts other than the LocalSystem account. If an account does not have the Login as a Service privilege enabled, you are prompted to enable it. If the -y option is also specified, dbsvc attempts to grant the Login as a Service privilege without prompting you. If the -q option is specified without the -y option, you are not prompted to grant the Login as a Service privilege and dbsvc fails. |
| -as | All services run under a Windows account. When -as is specified, the service runs under the Windows LocalSystem account. No password is required. One of -a or -as must be used. |
| -i | Displays an icon that you can double-click to display the Server Messages window. |
| -p | Use this option with the -a option to specify the password for the account under which the service runs. |
| -rg dependency,... | Specifies one or more load ordering groups that must be started before the service being created is allowed to start. |
| -rs dependency,... | All the services in the list must have started before the service being created is allowed to start. |
| -s startup | Sets startup behavior for SQL Anywhere services. You can set startup behavior to Automatic, Manual, or Disabled. The default is Manual. |
| -sd description | Use this option to provide a description of the service. The description appears in the Windows Service Manager. |
| -sn name |
Use this option to provide a name for the service. This name appears in the Windows Service Manager. If you do not specify the -sn option, the default service name is SQL Anywhere - svc. For example, the following service is named SQL Anywhere - myserv by default. dbsvc -as -w myserv "c:\Program Files\SQL Anywhere 10\win32\dbeng10.exe" To have the service name myserv appear in the Windows Service Manager, you need to execute the following (entered all on one line): dbsvc -as -sn myserv -w myserv "c:\Program Files\SQL Anywhere 10\win32\dbeng10.exe" |
| -t type |
Specifies the type for this service. You can choose from the following types:
The default setting for all service types is Standalone. |
| Modifier option | Description |
|---|---|
| -cm |
Displays the command used to create the service. This option can be used to output the creation command to a file, which can then be used to add the service on another computer or restore a service to its original state if changes have been made to it. You must specify the -g option or -l option with -cm or the command fails. Specifying -g displays the creation command for the specified service, while specifying -l displays the creation command for all services. If the specified service does not exist, the command to delete the service is generated. For example, if service_1 does not exist on the computer, dbsvc -y -d "service_1" If the service does not use the LocalSystem account, there is no way to retrieve the password, so it is not included in the command that is generated. If you created the service with |
| -o log-file |
Writes output from the Service utility (dbsvc) to the specified file. The -o option must occur before the -d, -g, -l, -u, and -x options. When you specify the -o option for both dbsvc and for the executable that you are running as a service (for example, the database server), log files are created for both. For example: dbsvc -o out1.txt -y -as -w mydsn install-dir\win32\dbsrv10 -n mysrv -o c:\out2.txt In this case, the output from dbsvc is logged to out1.txt, while the output from the database server is logged to c:\out2.txt. |
| -q | Do not display messages in the Server Messages window. If you specify -q, it is also recommended that you specify a file where messages are logged using the -o option. If you specify this option when modifying or deleting an existing service, you must also specify -y or the operation will fail. |
| -y | Automatically performs the action without prompting for confirmation. This option can be used with the -w or -d options. If you specify -q when modifying or deleting an existing service, you must also specify -y or the operation will fail. |
A service runs a database server or other application with a set of options. This utility provides a comprehensive way of managing SQL Anywhere services on Windows. The Service utility provides the same functionality as the Create Service wizard in Sybase Central.
You must be a member of the Administrators group on the local computer to use the Service utility.
You can access the Service utility in the following ways:
From Sybase Central, using the Create Service wizard. See Creating a Windows service.
At a command prompt, using the dbsvc command.
Exit codes are 0 (success) or non-zero (failure). See Software component exit codes.
Create a personal server service called myserv, which starts the specified server with the specified parameters. The server runs as the LocalSystem user:
dbsvc -as -w myserv "c:\Program Files\SQL Anywhere 10\win32\dbeng10.exe" -n myeng -c 8m "c:\temp\mysample.db"
Create a network server service called mynetworkserv. The server runs under the local account, and starts automatically when the computer is restarted:
dbsvc -as -s auto -t network -w mynetworkserv "c:\Program Files\SQL Anywhere 10\win32\dbsrv10.exe" -x tcpip -c 8m "c:\temp\mysample.db"
List all details about service myserv:
dbsvc -g myserv
Delete the service called myserv, without prompting for confirmation:
dbsvc -y -d myserv
Create a service dependent on the Workstation service and the TDI group:
dbsvc -rs Workstation -rg TDI -w ...
Create a service called mysyncservice:
dbsvc -as -s manual -t dbmlsync -w mysyncservice "c:\Program Files\SQL Anywhere 10\win32\dbmlsync.exe" -c "SQL Anywhere 10 CustDB"
Generate the command to create the service_1 service and output it to a file called restoreservice.bat:
dbsvc -cm -g service_1 > restoreservice.bat
The restoreservice.bat file contains the following:
dbsvc -t Standalone -s Manual -as -y -w "service_1" "c:\Program Files\SQL Anywhere 10\win32\dbeng10.exe"
Create a MobiLink listener service that is started manually:
dbsvc -as -i -w myListener "c:\Program Files\SQL Anywhere 10\win32\dblsn.exe" "@c:\temp\dblsn.opt"
Start the myListener service:
dbsvc -u myListener
Stop the myListener service:
dbsvc -x myListener