SQL Anywhere database server syntax

dbsrv16 
 [ server-options ] [ database-file [ database-options ] ...]

Server option	Description
@data	Reads in options from a configuration file or environment variable. See @data database server option.
-?	Displays usage information. See -? database server option.
-al userid [ ;userid ... ]	Allow standard user authentication for specified users. See -al database server option.
-b	Runs in bulk operations mode. See -b database server option.
-c size	Sets initial cache size. See -c database server option.
-ca 0	Disables dynamic cache sizing [Windows, Unix, Mac OS X]. See -ca database server option.
-cc{ + \| - }	Collects information about database pages to be used for cache warming. See -cc database server option.
-ch size	Sets the cache size upper limit [Windows, Unix, Mac OS X]. See -ch database server option.
-chx size	Reserves address space for non-cache use [32-bit Windows, 32-bit Unix]. See -ch database server option.
-cl size	Sets the cache size lower limit [Windows, Unix, Mac OS X]. See -cl database server option.
-cp location [ ;location ... ]	Specifies set of directories or JAR files in which to search for classes. See -cp database server option.
-cr { + \| - }	Warms the cache with database pages. See -cr database server option.
-cs	Displays cache usage in the database server messages window. See -cs database server option.
-cv{ + \| - }	Controls the appearance of messages about cache warming in the database server messages window. See -cv database server option.
-dt temp-file-dir	Specifies the directory where temporary files are stored. See -dt database server option.
-ec encryption-options	Enables packet encryption [network server]. See -ec database server option.
-ep	Prompts for encryption key. See -ep database server option.
-es	Allows unencrypted connections over shared memory. See -es database server option.
-f	Forces the database to start without a transaction log. See -f database server recovery option.
-fc filename	Specifies the file name of a DLL containing the file system full callback function. See -fc database server option.
-fips	Requires the use of FIPS-certified algorithms for database and communication encryption [Windows, Unix, and Linux]. See -fips database server option.
-ga	Automatically unloads the database after the last non-HTTP client connection is closed. In addition, shuts down after the last database is closed. See -ga database server option.
-gb level	Sets database process priority class to level [Windows, Unix, Mac OS X]. See -gb database server option.
-gc num	Sets maximum checkpoint timeout period to num minutes. See -gc database server option.
-gd level	Sets database starting privilege. See -gd database server option.
-ge size	Sets the stack size for threads that run external functions. See -ge database server option.
-gf	Disables firing of triggers. See -gf database server option.
-gk level	Sets the privilege required to stop the server. See -gk database server option.
-gl level	Sets the privilege required to load or unload data. See -gl database server option.
-gm num	Sets the maximum number of connections. See -gm database server option.
-gn num	Sets the multiprogramming level of the database server. See -gn database server option.
-gna	Controls automatic tuning of the database server multiprogramming level. See -gna database server option.
-gnh num	Sets the maximum number of tasks that the database server can execute concurrently. See -gnh database server option.
-gnl num	Sets the minimum number of tasks that the database server can execute concurrently. See -gnl database server option.
-gns	Reports multiprogramming level statistics in the database server message log. See -gns database server option.
-gp size	Sets the maximum page size to size bytes. See -gp database server option.
-gr minutes	Sets the maximum recovery time. See -gr database server option.
-gss size	Sets the thread stack size to size bytes. See -gss database 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 database server option.
-gta logical-processors-to-use,...	Sets which logical processors the database server can use. See -gta database server option.
-gtc logical-processors-to-use	Controls the maximum processor concurrency that the database server allows. See -gtc database server option.
-gu level	Sets the privilege level for utility commands: utility_db, all, none, or DBA. See -gu database server option.
-im submode	Runs the database server in memory, reducing or eliminating writes to disk. See -im database server option.
-k	Controls the collection of Performance Monitor statistics. See -k database 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 database server option.
-kp server-principal	Specifies the Kerberos server principal and enable Kerberos authenticated connections to the database server. See -kp database server option.
-kr server-realm	Specifies the realm of the Kerberos server principal and enables Kerberos authenticated connections to the database server. See -kr database server option (deprecated).
-krb	Enables Kerberos-authenticated connections to the database server. See -krb database 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 database server option.
-ksc	Specifies the maximum number of connections that the Performance Monitor can monitor [Windows]. See -ksc database server option.
-ksd	Specifies the maximum number of databases that the Performance Monitor can monitor [Windows]. See -ksd database server option.
-m	Truncates the transaction log after each checkpoint for all databases. See -m database server option.
-n name	Uses name as the name of the database server. The -n option is positional. See -n database server option.
-o filename	Outputs messages to the specified file. See -o database server option.
-oe filename	Specifies file to log startup errors, fatal errors, and assertions to. See -oe database 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 database server option.
-os size	Limits the size of the log file for messages. See -os database server option.
-ot filename	Truncates the database server message log file and appends output messages to it. See -ot database server option.
-p packet-size	Sets the maximum communication packet size [network server]. See -p database server option.
-pc	Compresses all communication packets except same-computer connections. See -pc database server option.
-pt size-in-bytes	Sets the minimum network packet size to compress. See -pt database server option.
-qi	Does not display the database server system tray icon or database server messages window [Windows]. See -qi database server option.
-qn	Does not minimize the database server messages window on startup [Windows and Linux]. See -qn database server option.
-qp	Suppresses messages about performance in the database server messages window. See -qp database server option.
-qs	Suppresses startup error windows [Windows]. See -qs database server option.
-qw	Does not display the database server messages window. See -qw database server option.
-r	Opens database in read-only mode. See -r database server option.
-s facility-ID	Sets the Syslog facility ID [Unix, Mac OS X]. See -s database server option.
-sb { 0 \| 1 }	Specifies how the server reacts to broadcasts. See -sb database server option.
-sbx { + \| - }	Controls the default disk sandbox settings for all databases started on the database server that do not have explicit disk sandbox settings. See -sbx database server option.
-sf feature-list	Secures features for databases running on this database server. See -sf database server option.
-sk key	Specifies a key that can be used to enable features that are disabled for the database server. See -sk database 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 database server option.
-tdsl	Sets the TDS login request mode. See -tdsl database server option.
-ti minutes	Sets the client idle time before shutdown—default 240 minutes. See -ti database server option.
-tl seconds	Sets the default liveness timeout for clients in seconds—default 120 seconds. See -tl database server option.
-tmf	Forces transaction manager recovery for distributed transactions [Windows]. See -tmf database server option.
-tmt milliseconds	Sets the re-enlistment timeout for distributed transactions [Windows]. See -tmt database server option.
-tq time	Sets quitting time [network server]. See -tq database server option.
-ts	Sets up a database server trace session.
-u	Uses buffered disk I/O [Windows, Unix, Mac OS X]. See -u database server option.
-ua	Turns off use of asynchronous I/O [Linux]. See -ua database server option.
-uc	Starts the database server in shell mode [Unix and Mac OS X]. See -uc database server option.
-ud	Runs as a daemon [Unix, Mac OS X]. See -ud database server option.
-uf	Specifies the action that the database server takes when a fatal error or assertion failure occurs on a database server. See -uf database server option.
-ufd	Specifies the action that the database server takes when a fatal error or assertion failure occurs on a database. See -ufd database 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]. See -ui database server option.
-um	Opens the Server Startup Options window and displays the database server messages window if DBLauncher.app is running [Mac OS X]. See -um database server option.
-ut minutes	Touches temporary files every min minutes [Unix, Mac OS X]. See -ut database server option.
-ux	Displays the database server messages window and Server Startup Options window [Linux]. See -ux database server option.
-v	Displays database server version and stop. See -v database server option.
-vss{ + \| - }	Enables and disables the Volume Shadow Copy Service (VSS) [Windows]. See -vss database server option.
-wc[ + \| - ]	Enables write checksums for databases running on the database server. See -wc database server option.
-x list	Specifies a comma-separated list of communication protocols to use. See -x database server option.
-xa authentication-info	Specifies a list of database names and authentication strings for an arbiter server. See -xa database server option.
-xd	Prevents the database server from becoming the default database server. See -xd database server option.
-xf state-file	Specifies the location of the file used for maintaining state information about your database mirroring system. See -xf database server option.
-xm seconds	Sets the time to check for new IP addresses in seconds. The minimum value is 10 and the default value is 0. For a portable device, the default value is 120. See -xm database server option.
-xs	Specifies server-side web services communications protocols. See -xs database server option.
-z	Provides diagnostic information about communication links [network server]. See -z database server option.
-ze	Displays database server environment variables in the database server messages window. See -ze database server option.
-zl	Turns on capturing of the most recently-prepared SQL statement for each connection. See -zl database server option.
-zn integer	Specifies the number of request log file copies to retain. See -zn database server option.
-zo filename	Redirects request logging information to a separate file. See -zo database server option.
-zoc	Redirects web service client information to a file. See -zoc database server option.
-zp	Turns on capturing of the plan most recently used by the query optimizer. See -zp database server option.
-zr level	Turns on logging of SQL operations. The default is NONE. See -zr database server option.
-zs size	Limits the size of the log file used for request logging. See -zs database server option.
-zt	Turns on logging of request timing information. See -zt database server option.

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 transaction log files to be applied to the database. See -ad database option.
-al userid [ ;userid ... ]	Allow standard user authentication for specified users of the specified database. See -al 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.
-dh	Does not display the database when dblocate is used against this server. See -dh database option.
-ds	Specifies the location of the dbspaces for the database. See -ds database option.
-ek key	Specifies encryption key. See -ek database option.
-m	Truncates (deletes) the transaction log after each checkpoint for the specified database. See -m database option.
-n name	Names the database. The -n option is positional. See -n database option.
-r	Opens the specified database(s) in read-only mode. Database modifications not allowed. See -r database option.
-sbx { + \| - }	Controls disk sandboxing for the database, which restricts read-write file operations on the database to the directory where the main database file is located and any subdirectories of this directory. See -sbx database option.
-sm	Provides a database server name that can be used to access the read-only mirror database. See -sm database option (deprecated).
-sn alternate-server-name	Provides an alternate server name for a single database running on a database server. See -sn database option.
-wc[ + \| - ]	Enables write checksums for databases running on the database server. See -wc 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.

The elements of the database server command include the following:

Executable The dbeng16 command starts a personal database server.
The dbsrv16 command starts a network database server.

The support for TCP/IP in the network server enables you to perform tasks from your desktop computer, including database management with Sybase Central.

On Windows operating systems, except Windows Mobile, the name of the personal database server executable is dbeng16.exe. On Unix operating systems its name is dbeng16.

On Windows operating systems, including Windows Mobile, the name of the network database server executable is dbsrv16.exe. On Linux and Unix operating systems, the name is dbsrv16.
Server options These options control the behavior of the database server for all running databases.
Database file You can specify zero, one, or more database file names. Each of these databases starts and remains available for applications.

Caution

The database file and the transaction log file must be located on the same physical computer as the database server or accessed via a SAN or iSCSI configuration. Database files and transaction log files located on a remote network directory can lead to poor performance, data corruption, and database server instability.

For more information, see http://www.sybase.com/detail?id=1034790.

For best results, the transaction log should be kept on a different disk from the database files. See The transaction log.
Database options For each database file you start, you can provide database options that control certain aspects of its behavior.

Database and server options are generally case-sensitive. You should enter all options in lowercase.

The database-file specifies the database file name. If database-file is specified without a file extension, database server 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 supply no options and no database file, then on Windows operating systems a window appears, allowing you to browse to your database file.

To start a database server from a batch file, 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 four cores on one CPU for request processing, and doesn't support network client/server connections. By default, the personal database server only uses the shared memory protocol. You must use the -x option to use TCP/IP with the personal database server. See -x database server option.

In addition, there are other minor differences, such as the default privilege level that is required to start new databases, or the privileges required to execute the CHECKPOINT statement. For more information about the differences between the personal database server and the network database server, see SQL Anywhere database servers.

By default, the database server page size is the same as the largest page size of the databases on the command line. Once the database server starts, you cannot start a database with a larger page size than the database server. See Maximum page size considerations.

The following command starts the SQL Anywhere sample database running on a personal database server:

dbeng16 "%SQLANYSAMP16%\demo.db"

The following command starts the SQL Anywhere sample database running on a network database server:

dbsrv16 "%SQLANYSAMP16%\demo.db"

The following example, entered all on one line, starts a database server named myserver that starts with a cache size of 3 MB and loads the sample database:

dbsrv16 -c 3m -n myserver "%SQLANYSAMP16%\demo.db"

Examples of starting a database server

SQL Anywhere database server syntax

Syntax

Server options

Database options

Remarks

Caution

Example

See also