From reference: Sybase DocXchange
Function
Start a personal database server or network database server.
Syntax
{ dbeng11 | dbsrv11 }
[ server-options ] [ database-file [ database-options ] ...]
Server options
| Server option | Description |
|---|---|
| @data | Reads in options from a configuration file or environment variable. See @data server option. |
| -? | Displays usage information. See -? server option. |
| -b | Runs in bulk operations mode. See -b server option. |
| -c size | Sets initial cache size. See -c server option. |
| -ca 0 | Disables dynamic cache sizing [Windows, Unix, Mac OS X]. See -ca server option. |
| -cc { + | – } | Collects information about database pages to be used for cache warming. See -cc server option. |
| -ch size | Sets the cache size upper limit [Windows, Unix, Mac OS X]. See -ch server option. |
| -cl size | Sets the cache size lower limit [Windows, Unix, Mac OS X]. See -cl server option. |
| -cm size | Specifies the amount of address space allocated for an Address Windowing Extensions (AWE) cache [Windows]. See -cm server option. |
| -cr { + | – } | Warms the cache with database pages. See -cr server option. |
| -cs | Displays cache usage in the database server messages window. See -cs server option. |
| -cv { + | – } | Controls the appearance of messages about cache warming in the database server messages window. See -cv server option. |
| -cw | Enables use of Address Windowing Extensions for setting the size of the database server cache [Windows]. See -cw server option. |
| -dt temp-file-dir | Specifies the directory where temporary files are stored. See -dt server option. |
| -ec encryption-options | Enables packet encryption [network server]. See -ec server option. |
| -ep | Prompts for encryption key. See -ep server option. |
| -es | Allows unencrypted connections over shared memory. See -es server option. |
| -f | Forces the database to start without a transaction log. See -f recovery option. |
| -fc filename | Specifies the file name of a DLL containing the file system full callback function. See -fc server option. |
| -fips | Requires the use of FIPS-approved algorithms for strong database and communication encryption [Windows]. See -fips server option. |
| -ga | Automatically unloads the database after the last non-HTTP client connection is closed. In addition, shut down after the last database is closed. See -ga server option. |
| -gb level | Sets database process priority class to level [Windows, Unix, Mac OS X]. See -gb server option. |
| -gc num | Sets maximum checkpoint timeout period to num minutes. See -gc server option. |
| -gd level | Sets database starting permission. See -gd server option. |
| -ge size | Sets the stack size for threads that run external functions. See -ge server option. |
| -gf | Disables firing of triggers. See -gf server option. |
| -gk level | Sets the permission required to stop the server. See -gk server option. |
| -gl level | Sets the permission required to load or unload data. See -gl server option. |
| -gm num | Sets the maximum number of connections. See -gm server option. |
| -gn num | Sets the maximum number of tasks that the database server can execute concurrently. See -gn server option. |
| -gp size | Sets the maximum page size to size bytes. See -gp server option. |
| -gr minutes | Sets the maximum recovery time. See -gr server option. |
| -gss size | Sets the thread stack size to size bytes. See -gss server option. |
| -gt num | Sets the maximum number of physical processors that can be used (up to the licensed maximum). This option is only useful on multiprocessor systems. See -gt server option. |
| -gtc logical-processors-to-use | Controls the maximum processor concurrency that the database server allows. See -gtc server option. |
| -gu level | Sets the permission level for utility commands: utility_db, all, none, or DBA. See -gu server option. |
| -im submode | Runs the database server in memory, reducing or eliminating writes to disk. See -im server option. |
| -k | Controls the collection of Performance Monitor statistics. See -k server option. |
| -kl GSS-API-library-file | Specifies the file name of the Kerberos GSS-API library (or shared object on Unix) and enable Kerberos authenticated connections to the database server. See -kl server option. |
| -kr server-realm | Specifies the realm of the Kerberos server principal and enables Kerberos authenticated connections to the database server. See -kr server option. |
| -krb | Enables Kerberos-authenticated connections to the database server. See -krb server option. |
| -ks | Disables the creation of shared memory that the Performance Monitor uses to collect counter values from the database server [Windows]. See -ks server option. |
| -ksc | Specifies the maximum number of connections that the Performance Monitor can monitor [Windows]. See -ksc server option. |
| -ksd | Specifies the maximum number of databases that the Performance Monitor can monitor [Windows]. See -ksd server option. |
| -m | Truncates the transaction log after each checkpoint for all databases. See -m server option. |
| -n name | Uses name as the name of the database server. Note that the -n option is positional. See -n server option. |
| -o filename | Outputs messages to the specified file. See -o server option. |
| -oe filename | Specifies file to log startup errors, fatal errors and assertions to. See -oe server option. |
| -on size | Specifies a maximum size for the database server message log file, after which the file is renamed with the extension .old and a new file is started. See -on server option. |
| -os size | Limits the size of the log file for messages. See -os server option. |
| -ot filename | Truncates the database server message log file and appends output messages to it. See -ot server option. |
| -p packet-size | Sets the maximum network packet size [network server]. See -p server option. |
| -pc | Compresses all connections except same-computer connections. See -pc server option. |
| -pt size_in_bytes | Sets the minimum network packet size to compress. See -pt server option. |
| -qi | Does not display the database server system tray icon or database server messages window [Windows]. See -qi server option. |
| -qn | Does not minimize the database server messages window on startup [Windows and Linux]. See -qn server option. |
| -qp | Suppresses messages about performance in the database server messages window. See -qp server option. |
| -qs | Suppresses startup error windows. See -qs server option. |
| -qw | Does not display the database server message window. See -qw server option. |
| -r | Opens database in read-only mode. See -r server option. |
| -s facility-ID | Sets the Syslog facility ID [Unix, Mac OS X]. See -s server option. |
| -sb { 0 | 1 } | Specifies how the server reacts to broadcasts. See -sb server option. |
| -sf feature-list | Secures features for databases running on this database server. See -sf server option. |
| -sk key | Specifies a key that can be used to enable features that are disabled for the database server. See -sk server option. |
| -su password | Sets the password for the DBA user of the utility database (utility_db), or disable connections to the utility database. See -su server option. |
| -ti minutes | Sets the client idle time before shutdown—default 240 minutes. See -ti server option. |
| -tl seconds | Sets the default liveness timeout for clients in seconds—default 120 seconds. See -tl server option. |
| -tmf | Forces transaction manager recovery for distributed transactions [Windows]. See -tmf server option. |
| -tmt milliseconds | Sets the reenlistment timeout for distributed transactions [Windows]. See -tmt server option. |
| -tq time | Sets quitting time [network server]. See -tq server option. |
| -u | Uses buffered disk I/O [Windows, Unix, Mac OS X]. See -u server option. |
| -ua | Turns off use of asynchronous I/O [Linux]. See -ua server option. |
| -uc | Starts the database server in shell mode [Unix and Mac OS X]. See -uc server option. |
| -ud | Runs as a daemon [Unix, Mac OS X]. See -ud server option. |
| -uf | Specifies the action to take when a fatal error occurs [Unix, Mac OS X]. See -uf server option. |
| -ui | Opens the Server Startup Options window and displays the database server messages window, or starts the database server in shell mode if a usable display isn’t available [Linux and Mac OS X]. See -ui server option. |
| -um | Opens the Server Startup Options window and displays the database server messages window [Mac OS X]. See -um server option. |
| -ut minutes | Touches temporary files every min minutes [Unix, Mac OS X]. See -ut server option. |
| -ux | Displays the database server messages window and Server Startup Options window [Linux]. See -ux server option. |
| -v | Displays database server version and stop. See -v server option. |
| -vss | Enables and disables the Volume Shadow Copy Service (VSS). See -vss server option. |
| -x list | Specifies a comma-separated list of communication links to use. See -x server option. |
| -xa authentication-info | Specifies a list of database names and authentication strings for an arbiter server. See -xa server option. |
| -xf state-file | Specifies the location of the file used for maintaining state information about your database mirroring system. See -xf server option. |
| -xs | Specifies server side web services communications protocols. See -xs server option. |
| -z | Provides diagnostic information on communication links [network server]. See -z server option. |
| -ze | Displays database server environment variables in the database server messages window. See -ze server option. |
| -zl | Turns on capturing of the most recently-prepared SQL statement for each connection. See -zl server option. |
| -zn integer | Specifies the number of request log file copies to retain. See -zn server option. |
| -zo filename | Redirects request logging information to a separate file. See -zo server option. |
| -zoc | Redirects web service client information to a file. See -zoc server option. |
| -zp | Turns on capturing of the plan most recently used by the query optimizer. See -zp server option. |
| -zr { all | SQL | none } | Turns on logging of SQL operations. The default is NONE. See -zr server option. |
| -zs size | Limits the size of the log file used for request logging. See -zs server option. |
| -zt | Turns on logging of request timing information. See -zt server option. |
Database options
The following options can only be specified after a database file name in the database server command.
| Database option | Description |
|---|---|
| -a filename | Applies the named transaction log file. See -a database option. |
| -ad log-directory | Specifies the directory containing log files to be applied to the database. See -ad database option. |
| -ar | Applies any log files located in the same directory as the transaction log to the database. See -ar database option. |
| -as | Continues running the database after transaction logs have been applied (used in conjunction with -ad or -ar). See -as database option. |
| -ds | Specifies the location of all of the dbspaces for the database. See -ds database option. |
| -dh | Does not display the database when dblocate is used against this server. See -dh database option. |
| -ek key | Specifies encryption key. See -ek database option. |
| -m | Truncates (delete) the transaction log after each checkpoint for the specified database. See -m database option. |
| -n name | Names the database. See -n database option. |
| -r | Opens the specified database(s) in read-only mode. Database modifications not allowed. See -r database option. |
| -sm | Provides a database server name that can be used to access the read-only mirror database. See -sm database option. |
| -sn alternate-server-name | Provides an alternate server name for a single database running on a database server. See -sn database option. |
| –xp mirroring-options | Provides information to an operational server that allows it to connect to its partner and to the arbiter when database mirroring is being used. See -xp database option. |
Remarks
The dbeng11 command starts a personal database server. The dbsrv11 command starts a network database server.
The database-file specifies the database file name. If database-file is specified without a file extension, SQL Anywhere looks for database-file with extension .db. If you use a relative path, it is read relative to the current working directory. You can supply a full path.
If you want to start a database server from a batch file, you must use the dbspawn utility. See Start Server in Background utility (dbspawn).
The personal database server has a maximum of ten concurrent connections, uses at most one CPU for request processing, and doesn’t support network client/server connections.
