{"id":76,"date":"2016-06-28T16:06:26","date_gmt":"2016-06-28T13:06:26","guid":{"rendered":"https:\/\/amsd.go.ro\/wordpress\/?p=76"},"modified":"2021-09-07T11:25:22","modified_gmt":"2021-09-07T08:25:22","slug":"sybase-sql-anywhere-database-server-command-line-options","status":"publish","type":"post","link":"https:\/\/amsd.go.ro\/wordpress\/?p=76","title":{"rendered":"Sybase SQL Anywhere database server command line options"},"content":{"rendered":"<blockquote>\n<p>Reference: <a href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbadmin_en11.html\">SQL Anywhere Server &#8211; Database Administration<\/a><\/p>\n<\/blockquote>\n<h1 class=\"title\">The SQL Anywhere database server<\/h1>\n<p><a class=\"indexterm\" name=\"d5e8175\"><\/a><a class=\"indexterm\" name=\"d5e8178\"><\/a><a class=\"indexterm\" name=\"d5e8181\"><\/a><a class=\"indexterm\" name=\"d5e8184\"><\/a><a class=\"indexterm\" name=\"d5e8187\"><\/a><a class=\"indexterm\" name=\"d5e8190\"><\/a><a class=\"indexterm\" name=\"d5e8193\"><\/a><a class=\"indexterm\" name=\"d5e8196\"><\/a><\/p>\n<p>Starts a personal database server or network database server.<\/p>\n<h2><a name=\"dbserver-bridgehead-37958341111\"><\/a>Syntax<\/h2>\n<pre class=\"synopsis\">{ <span><strong class=\"literal\">dbeng11<\/strong><\/span> | <span><strong class=\"literal\">dbsrv11<\/strong><\/span> } \n [ <em class=\"replaceable\">server-options<\/em> ] [ <em class=\"replaceable\">database-file<\/em> [ <em class=\"replaceable\">database-options<\/em> ] ...]<\/pre>\n<h2><a name=\"dbserver-bridgehead-37958381111\"><\/a>Server options<\/h2>\n<div class=\"informaltable\">\n<table border=\"1\">\n<tbody>\n<tr>\n<th><span style=\"font-size: x-small;\">Server option<\/span><\/th>\n<th><span style=\"font-size: x-small;\">Description<\/span><\/th>\n<\/tr>\n<\/tbody>\n<tbody>\n<tr>\n<td><span><strong class=\"literal\">@<\/strong><\/span><em class=\"replaceable\">data<\/em><\/td>\n<td>Reads in options from a configuration file or environment variable. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/filename-database-dbengine.html\">@data server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-?<\/strong><\/span><\/td>\n<td>Displays usage information. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/question-database-dbengine.html\">-? server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-b<\/strong><\/span><\/td>\n<td>Runs in bulk operations mode. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/b-database-dbengine.html\">-b server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-c<\/strong><\/span> <em class=\"replaceable\">size<\/em><\/td>\n<td>Sets initial cache size. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/c-database-dbengine.html\">-c server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-ca 0<\/strong><\/span><\/td>\n<td>Disables dynamic cache sizing [Windows, Unix, Mac OS X]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/ca-database-dbengine.html\">-ca server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-cc<\/strong><\/span> { <span><strong class=\"literal\">+<\/strong><\/span> | <span><strong class=\"literal\">&#8211;<\/strong><\/span> }<\/td>\n<td>Collects information about database pages to be used for cache warming. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-5415081.html\">-cc server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-ch<\/strong><\/span> <em class=\"replaceable\">size<\/em><\/td>\n<td>Sets the cache size upper limit [Windows, Unix, Mac OS X]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/ch-database-dbengine.html\">-ch server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-cl<\/strong><\/span> <em class=\"replaceable\">size<\/em><\/td>\n<td>Sets the cache size lower limit [Windows, Unix, Mac OS X]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/cl-database-dbengine.html\">-cl server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-cm<\/strong><\/span> <em class=\"replaceable\">size<\/em><\/td>\n<td>Specifies the amount of address space allocated for an Address Windowing Extensions (AWE) cache [Windows]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-4740598.html\">-cm server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-cp<\/strong><\/span> <em class=\"replaceable\">location<\/em>[ <span><strong class=\"literal\">;<\/strong><\/span><em class=\"replaceable\">location<\/em> &#8230; ]<\/td>\n<td>Specifies set of directories or jar files in which to search for classes. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/da-dbserver-s-3667774.html\">-cp server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-cr<\/strong><\/span> { <span><strong class=\"literal\">+<\/strong><\/span> | <span><strong class=\"literal\">&#8211;<\/strong><\/span> }<\/td>\n<td>Warms the cache with database pages. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-5415664.html\">-cr server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-cs<\/strong><\/span><\/td>\n<td>Displays cache usage in the database server messages window. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/cs-database-dbengine.html\">-cs server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-cv<\/strong><\/span> { <span><strong class=\"literal\">+<\/strong><\/span> | <span><strong class=\"literal\">&#8211;<\/strong><\/span> }<\/td>\n<td>Controls the appearance of messages about cache warming in the database server messages window. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-5416712.html\">-cv server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-cw<\/strong><\/span><\/td>\n<td>Enables use of Address Windowing Extensions for setting the size of the database server cache [Windows]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/cw-database-dbserver.html\">-cw server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-dt<\/strong><\/span> <em class=\"replaceable\">temp-file-dir<\/em><\/td>\n<td>Specifies the directory where temporary files are stored. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-3699735.html\">-dt server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-ec<\/strong><\/span> <em class=\"replaceable\">encryption-options<\/em><\/td>\n<td>Enables packet encryption [network server]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/ec-database-dbserver.html\">-ec server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-ep<\/strong><\/span><\/td>\n<td>Prompts for encryption key. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/ep-option.html\">-ep server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-es<\/strong><\/span><\/td>\n<td>Allows unencrypted connections over shared memory. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-4146798.html\">-es server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-f<\/strong><\/span><\/td>\n<td>Forces the database to start without a transaction log. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/rec-f-database-dbengine.html\">-f recovery option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-fc<\/strong><\/span> <em class=\"replaceable\">filename<\/em><\/td>\n<td>Specifies the file name of a DLL containing the file system full callback function. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-5543996.html\">-fc server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-fips<\/strong><\/span><\/td>\n<td>Requires the use of FIPS-approved algorithms for strong database and communication encryption [Windows]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-5299616.html\">-fips server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-ga<\/strong><\/span><\/td>\n<td>Automatically unloads the database after the last non-HTTP client connection is closed. In addition, shut down after the last database is closed. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/ga-database-dbengine.html\">-ga server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-gb<\/strong><\/span> <em class=\"replaceable\">level<\/em><\/td>\n<td>Sets database process priority class to <em class=\"replaceable\">level<\/em> [Windows, Unix, Mac OS X]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/gb-database-dbengine.html\">-gb server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-gc<\/strong><\/span> <em class=\"replaceable\">num<\/em><\/td>\n<td>Sets maximum checkpoint timeout period to <em class=\"replaceable\">num<\/em> minutes. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/gc-database-dbengine.html\">-gc server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-gd<\/strong><\/span> <em class=\"replaceable\">level<\/em><\/td>\n<td>Sets database starting permission. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/gd-database-dbengine.html\">-gd server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-ge<\/strong><\/span> <em class=\"replaceable\">size<\/em><\/td>\n<td>Sets the stack size for threads that run external functions. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/ge-database-dbengine.html\">-ge server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-gf<\/strong><\/span><\/td>\n<td>Disables firing of triggers. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/gf-database-dbengine.html\">-gf server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-gk<\/strong><\/span> <em class=\"replaceable\">level<\/em><\/td>\n<td>Sets the permission required to stop the server. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/gk-database-dbengine.html\">-gk server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-gl<\/strong><\/span> <em class=\"replaceable\">level<\/em><\/td>\n<td>Sets the permission required to load or unload data. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/gl-database-dbengine.html\">-gl server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-gm<\/strong><\/span> <em class=\"replaceable\">num<\/em><\/td>\n<td>Sets the maximum number of connections. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/gm-database-dbengine.html\">-gm server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-gn<\/strong><\/span> <em class=\"replaceable\">num<\/em><\/td>\n<td>Sets the maximum number of tasks that the database server can execute concurrently. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/gn-database-dbengine.html\">-gn server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-gp<\/strong><\/span> <em class=\"replaceable\">size<\/em><\/td>\n<td>Sets the maximum page size to <em class=\"replaceable\">size<\/em> bytes. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/gp-database-dbengine.html\">-gp server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-gr<\/strong><\/span> <em class=\"replaceable\">minutes<\/em><\/td>\n<td>Sets the maximum recovery time. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/gr-database-dbengine.html\">-gr server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-gss<\/strong><\/span> <em class=\"replaceable\">size<\/em><\/td>\n<td>Sets the thread stack size to <em class=\"replaceable\">size<\/em> bytes. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/gss-database-dbengine.html\">-gss server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-gt<\/strong><\/span> <em class=\"replaceable\">num<\/em><\/td>\n<td>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 <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/gt-database-dbengine.html\">-gt server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-gtc<\/strong><\/span> <em class=\"replaceable\">logical-processors-to-use<\/em><\/td>\n<td>Controls the maximum processor concurrency that the database server allows. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-3165478.html\">-gtc server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-gu<\/strong><\/span> <em class=\"replaceable\">level<\/em><\/td>\n<td>Sets the permission level for utility commands: utility_db, all, none, or DBA. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/gu-database-dbengine.html\">-gu server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-im<\/strong><\/span> <em class=\"replaceable\">submode<\/em><\/td>\n<td>Runs the database server in memory, reducing or eliminating writes to disk. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/da-dbserver-s-3511900.html\">-im server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-k<\/strong><\/span><\/td>\n<td>Controls the collection of Performance Monitor statistics. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-4981044.html\">-k server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-kl<\/strong><\/span> <em class=\"replaceable\">GSS-API-library-file<\/em><\/td>\n<td>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 <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-51397801.html\">-kl server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-kr<\/strong><\/span> <em class=\"replaceable\">server-realm<\/em><\/td>\n<td>Specifies the realm of the Kerberos server principal and enables Kerberos authenticated connections to the database server. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/kerberos-s-3277943.html\">-kr server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-krb<\/strong><\/span><\/td>\n<td>Enables Kerberos-authenticated connections to the database server. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-51397802.html\">-krb server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-ks<\/strong><\/span><\/td>\n<td>Disables the creation of shared memory that the Performance Monitor uses to collect counter values from the database server [Windows]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/da-dbserver-s-5379541.html\">-ks server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-ksc<\/strong><\/span><\/td>\n<td>Specifies the maximum number of connections that the Performance Monitor can monitor [Windows]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/da-dbserver-s-5382076.html\">-ksc server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-ksd<\/strong><\/span><\/td>\n<td>Specifies the maximum number of databases that the Performance Monitor can monitor [Windows]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/da-dbserver-s-5383038.html\">-ksd server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-m<\/strong><\/span><\/td>\n<td>Truncates the transaction log after each checkpoint for all databases. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/m-database-dbengine.html\">-m server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-n<\/strong><\/span> <em class=\"replaceable\">name<\/em><\/td>\n<td>Uses <em class=\"replaceable\">name<\/em> as the name of the database server. Note that the -n option is positional. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/n-database-dbengine.html\">-n server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-o<\/strong><\/span> <em class=\"replaceable\">filename<\/em><\/td>\n<td>Outputs messages to the specified file. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/o-database-dbengine.html\">-o server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-oe<\/strong><\/span> <em class=\"replaceable\">filename<\/em><\/td>\n<td>Specifies file to log startup errors, fatal errors and assertions to. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-6364119.html\">-oe server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-on<\/strong><\/span> <em class=\"replaceable\">size<\/em><\/td>\n<td>Specifies a maximum size for the database server message log file, after which the file is renamed with the extension .<em class=\"filename\">old<\/em> and a new file is started. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-5168594.html\">-on server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-os<\/strong><\/span> <em class=\"replaceable\">size<\/em><\/td>\n<td>Limits the size of the log file for messages. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/os-database-dbengine.html\">-os server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-ot<\/strong><\/span> <em class=\"replaceable\">filename<\/em><\/td>\n<td>Truncates the database server message log file and appends output messages to it. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-3954981.html\">-ot server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-p<\/strong><\/span> <em class=\"replaceable\">packet-size<\/em><\/td>\n<td>Sets the maximum network packet size [network server]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/p-database-dbengine.html\">-p server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td>\n<p class=\"table\"><span><strong class=\"literal\">-pc<\/strong><\/span><\/p>\n<\/td>\n<td>Compresses all connections except same-computer connections. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/pc-database-dbserver.html\">-pc server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-pt<\/strong><\/span> <em class=\"replaceable\">size_in_bytes<\/em><\/td>\n<td>Sets the minimum network packet size to compress. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/pt-database-dbserver.html\">-pt server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-qi<\/strong><\/span><\/td>\n<td>Does not display the database server system tray icon or database server messages window [Windows]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-6255667.html\">-qi server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-qn<\/strong><\/span><\/td>\n<td>Does not minimize the database server messages window on startup [Windows and Linux]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-3000328.html\">-qn server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-qp<\/strong><\/span><\/td>\n<td>Suppresses messages about performance in the database server messages window. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/qp-option.html\">-qp server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-qs<\/strong><\/span><\/td>\n<td>Suppresses startup error windows. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-6270400.html\">-qs server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-qw<\/strong><\/span><\/td>\n<td>Does not display the database server message window. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-6270173.html\">-qw server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-r<\/strong><\/span><\/td>\n<td>Opens database in read-only mode. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/r-database-dbengine.html\">-r server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-s<\/strong><\/span> <em class=\"replaceable\">facility-ID<\/em><\/td>\n<td>Sets the Syslog facility ID [Unix, Mac OS X]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/s-database-dbengine.html\">-s server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-sb<\/strong><\/span> { <span><strong class=\"literal\">0<\/strong><\/span> | <span><strong class=\"literal\">1<\/strong><\/span> }<\/td>\n<td>Specifies how the server reacts to broadcasts. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/sb-database-dbserver.html\">-sb server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-sf<\/strong><\/span> <em class=\"replaceable\">feature-list<\/em><\/td>\n<td>Secures features for databases running on this database server. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-3752812.html\">-sf server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-sk<\/strong><\/span> <em class=\"replaceable\">key<\/em><\/td>\n<td>Specifies a key that can be used to enable features that are disabled for the database server. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-5042328.html\">-sk server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-su<\/strong><\/span> <em class=\"replaceable\">password<\/em><\/td>\n<td>Sets the password for the DBA user of the utility database (utility_db), or disable connections to the utility database. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/su-database-dbengine.html\">-su server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-ti<\/strong><\/span> <em class=\"replaceable\">minutes<\/em><\/td>\n<td>Sets the client idle time before shutdown&mdash;default 240 minutes. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/ti-database-dbengine.html\">-ti server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-tl<\/strong><\/span> <em class=\"replaceable\">seconds<\/em><\/td>\n<td>Sets the default liveness timeout for clients in seconds&mdash;default 120 seconds. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/tl-database-dbengine.html\">-tl server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-tmf<\/strong><\/span><\/td>\n<td>Forces transaction manager recovery for distributed transactions [Windows]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/tmf-database-dbengine.html\">-tmf server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-tmt<\/strong><\/span> <em class=\"replaceable\">milliseconds<\/em><\/td>\n<td>Sets the re-enlistment timeout for distributed transactions [Windows]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/tmt-database-dbengine.html\">-tmt server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-tq<\/strong><\/span> <em class=\"replaceable\">time<\/em><\/td>\n<td>Sets quitting time [network server]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/tq-database-dbengine.html\">-tq server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-u<\/strong><\/span><\/td>\n<td>Uses buffered disk I\/O [Windows, Unix, Mac OS X]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/u-database-dbengine.html\">-u server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-ua<\/strong><\/span><\/td>\n<td>Turns off use of asynchronous I\/O [Linux]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-3445636.html\">-ua server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-uc<\/strong><\/span><\/td>\n<td>Starts the database server in shell mode [Unix and Mac OS X]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-4113379.html\">-uc server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-ud<\/strong><\/span><\/td>\n<td>Runs as a daemon [Unix, Mac OS X]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/ud-database-dbengine.html\">-ud server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-uf<\/strong><\/span><\/td>\n<td>Specifies the action to take when a fatal error occurs [Unix, Mac OS X]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-4644438.html\">-uf server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-ui<\/strong><\/span><\/td>\n<td>Opens the <span class=\"guilabel\">Server Startup Options<\/span> window and displays the database server messages window, or starts the database server in shell mode if a usable display isn&#8217;t available [Linux and Mac OS X]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-4154966.html\">-ui server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-um<\/strong><\/span><\/td>\n<td>Opens the <span class=\"guilabel\">Server Startup Options<\/span> window and displays the database server messages window [Mac OS X]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/da-dbserver-s-3481364.html\">-um server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-ut<\/strong><\/span> <em class=\"replaceable\">minutes<\/em><\/td>\n<td>Touches temporary files every <em class=\"replaceable\">min<\/em> minutes [Unix, Mac OS X]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/ut-database-dbengine.html\">-ut server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-ux<\/strong><\/span><\/td>\n<td>Displays the database server messages window and <span class=\"guilabel\">Server Startup Options<\/span> window [Linux]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-3555914.html\">-ux server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-v<\/strong><\/span><\/td>\n<td>Displays database server version and stop. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/v-database-dbengine.html\">-v server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-vss<\/strong><\/span><\/td>\n<td>Enables and disables the Volume Shadow Copy Service (VSS). See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/vss-database-dbengine.html\">-vss server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-x<\/strong><\/span> <em class=\"replaceable\">list<\/em><\/td>\n<td>Specifies a comma-separated list of communication links to use. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/x-database-dbengine.html\">-x server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-xa<\/strong><\/span> <em class=\"replaceable\">authentication-info<\/em><\/td>\n<td>Specifies a list of database names and authentication strings for an arbiter server. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-5139376.html\">-xa server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-xd<\/strong><\/span><\/td>\n<td>Prevents the database server from becoming the default database server. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/da-dbserver-s-5283536.html\">-xd server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-xf<\/strong><\/span> <em class=\"replaceable\">state-file<\/em><\/td>\n<td>Specifies the location of the file used for maintaining state information about your database mirroring system. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-5139780.html\">-xf server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-xs<\/strong><\/span><\/td>\n<td>Specifies server side web services communications protocols. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/xs-database-dbengine.html\">-xs server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-z<\/strong><\/span><\/td>\n<td>Provides diagnostic information on communication links [network server]. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/z-database-dbengine.html\">-z server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-ze<\/strong><\/span><\/td>\n<td>Displays database server environment variables in the database server messages window. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-5091122.html\">-ze server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-zl<\/strong><\/span><\/td>\n<td>Turns on capturing of the most recently-prepared SQL statement for each connection. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/zl-option-dbserver.html\">-zl server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-zn<\/strong><\/span> <em class=\"replaceable\">integer<\/em><\/td>\n<td>Specifies the number of request log file copies to retain. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-5551610a.html\">-zn server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-zo<\/strong><\/span> <em class=\"replaceable\">filename<\/em><\/td>\n<td>Redirects request logging information to a separate file. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/zo-database-dbengine.html\">-zo server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-zoc<\/strong><\/span><\/td>\n<td>Redirects web service client information to a file. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/da-dbserver-s-5133280.html\">-zoc server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-zp<\/strong><\/span><\/td>\n<td>Turns on capturing of the plan most recently used by the query optimizer. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-4981337.html\">-zp server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-zr<\/strong><\/span> { <span><strong class=\"literal\">all<\/strong><\/span> | <span><strong class=\"literal\">SQL<\/strong><\/span> | <span><strong class=\"literal\">none<\/strong><\/span> }<\/td>\n<td>Turns on logging of SQL operations. The default is NONE. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/zr-database-dbengine.html\">-zr server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-zs<\/strong><\/span> <em class=\"replaceable\">size<\/em><\/td>\n<td>Limits the size of the log file used for request logging. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/zs-database-dbengine.html\">-zs server option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-zt<\/strong><\/span><\/td>\n<td>Turns on logging of request timing information. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-3179137.html\">-zt server option<\/a>.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<h2><a name=\"dbserver-bridgehead-37958431111\"><\/a>Database options<\/h2>\n<p>The following options can only be specified after a database file name in the database server command.<\/p>\n<div class=\"informaltable\">\n<table style=\"width: 595px; height: 452px;\" border=\"1\">\n<tbody>\n<tr>\n<th>\n<p><span style=\"font-size: x-small;\">Database option<\/span><\/p>\n<\/th>\n<th>\n<p><span style=\"font-size: x-small;\">Description<\/span><\/p>\n<\/th>\n<\/tr>\n<\/tbody>\n<tbody>\n<tr>\n<td><span><strong class=\"literal\">-a<\/strong><\/span> <em class=\"replaceable\">filename<\/em><\/td>\n<td>Applies the named transaction log file. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/rec-a-database-dbengine.html\">-a database option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-ad<\/strong><\/span> <em class=\"replaceable\">log-directory<\/em><\/td>\n<td>Specifies the directory containing transaction log files to be applied to the database. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-3223660.html\">-ad database option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-ar<\/strong><\/span><\/td>\n<td>Applies any log files located in the same directory as the transaction log to the database. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-3224488.html\">-ar database option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-as<\/strong><\/span><\/td>\n<td>Continues running the database after transaction logs have been applied (used in conjunction with -ad or -ar). See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-3225078.html\">-as database option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-dh<\/strong><\/span><\/td>\n<td>Does not display the database when dblocate is used against this server. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-3722169.html\">-dh database option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-ds<\/strong><\/span><\/td>\n<td>Specifies the location of the dbspaces for the database. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-5376426.html\">-ds database option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-ek<\/strong><\/span> <em class=\"replaceable\">key<\/em><\/td>\n<td>Specifies encryption key. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/ek-database-engine.html\">-ek database option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-m<\/strong><\/span><\/td>\n<td>Truncates (deletes) the transaction log after each checkpoint for the specified database. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/db-m-database-dbengine.html\">-m database option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-n<\/strong><\/span> <em class=\"replaceable\">name<\/em><\/td>\n<td>Names the database. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/db-n-database-dbengine.html\">-n database option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-r<\/strong><\/span><\/td>\n<td>Opens the specified database(s) in read-only mode. Database modifications not allowed. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/r-database-dbserver.html\">-r database option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-sm<\/strong><\/span><\/td>\n<td>Provides a database server name that can be used to access the read-only mirror database. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/da-dbserver-s-3637974.html\">-sm database option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><span><strong class=\"literal\">-sn<\/strong><\/span> <em class=\"replaceable\">alternate-server-name<\/em><\/td>\n<td>Provides an alternate server name for a single database running on a database server. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-41861441.html\">-sn database option<\/a>.<\/td>\n<\/tr>\n<tr>\n<td>&#8211;<span><strong class=\"literal\">xp<\/strong><\/span> <em class=\"replaceable\">mirroring-options<\/em><\/td>\n<td>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 <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbserver-s-4186144.html\">-xp database option<\/a>.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<h2><a name=\"dbserver-bridgehead-37958451111\"><\/a>Remarks<\/h2>\n<p>The <span><strong class=\"literal\">dbeng11<\/strong><\/span> command starts a personal database server. The <span><strong class=\"literal\">dbsrv11<\/strong><\/span> command starts a network database server.<\/p>\n<p><a class=\"indexterm\" name=\"d5e8861\"><\/a><a class=\"indexterm\" name=\"d5e8864\"><\/a><a class=\"indexterm\" name=\"d5e8867\"><\/a><\/p>\n<p>The <em class=\"replaceable\">database-file<\/em> specifies the database file name. If <em class=\"replaceable\">database-file<\/em> is specified without a file extension, SQL Anywhere looks for <em class=\"replaceable\">database-file<\/em> with extension <em class=\"filename\">.db<\/em>. If you use a relative path, it is read relative to the current working directory. You can supply a full path.<\/p>\n<p><a class=\"indexterm\" name=\"d5e8875\"><\/a><\/p>\n<p>If you want to start a database server from a batch file, you must use the dbspawn utility. See <a class=\"olink\" href=\"http:\/\/dcx.sap.com\/1101\/en\/dbadmin_en11\/dbspawn-spawn-dbutilities.html\">Start Server in Background utility (dbspawn)<\/a>.<\/p>\n<p>The personal database server has a maximum of ten concurrent connections, uses at most one CPU for request processing, and doesn&#8217;t support network client\/server connections.<\/p>\n<p>In addition, there are other minor differences, such as the default permission level that is required to start new databases, or the permissions required to execute the CHECKPOINT statement.<\/p>\n<p>Both personal and network database servers are supplied for each supported operating system, with one exception. On Windows Mobile, only the network server is supplied. The support for TCP\/IP in the network server enables you to perform tasks from your desktop computer, including database management, with Sybase Central.<\/p>\n<h2><a name=\"da-dbserver-b-5335999\"><\/a>Examples<\/h2>\n<p>The following command starts the SQL Anywhere sample database running on a personal database server:<\/p>\n<table class=\"programlisting\">\n<tbody>\n<tr>\n<td class=\"programlisting\">\n<pre id=\"d5e8885\">dbeng11 \"c:\\Documents and Settings\\All Users\\Documents\\SQL Anywhere 11\\Samples\\demo.db\"<\/pre>\n<\/td>\n<td class=\"copytoclipboard\">&nbsp;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>The following command starts the SQL Anywhere sample database running on a network database server:<\/p>\n<table class=\"programlisting\">\n<tbody>\n<tr>\n<td class=\"programlisting\">\n<pre id=\"d5e8887\">dbsrv11 \"c:\\Documents and Settings\\All Users\\Documents\\SQL Anywhere 11\\Samples\\demo.db\"<\/pre>\n<\/td>\n<td class=\"copytoclipboard\">&nbsp;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>The following example, entered all on one line, starts a server named <span><strong class=\"literal\">myserver<\/strong><\/span> that starts with a cache size of 3 MB and loads the sample database:<\/p>\n<table class=\"programlisting\">\n<tbody>\n<tr>\n<td class=\"programlisting\">\n<pre id=\"d5e8890\">dbeng11 -c 3m -n myserver \"<em class=\"replaceable\">samples-dir<\/em>\\demo.db\"<\/pre>\n<\/td>\n<td class=\"copytoclipboard\">&nbsp;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Reference: SQL Anywhere Server &#8211; Database Administration The SQL Anywhere database server Starts a personal database server or network database server. Syntax { dbeng11 | dbsrv11 } [ server-options ] [ database-file [ database-options ] &#8230;] Server options Server option [&hellip;]<\/p>\n<div class=\"link-more\"><a href=\"https:\/\/amsd.go.ro\/wordpress\/?p=76#more-76\" class=\"more-link\">Continue reading &#10142; <span class=\"screen-reader-text\">Sybase SQL Anywhere database server command line options<\/span><\/a><\/div>","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[16,13,17,10,20,12],"class_list":["post-76","post","type-post","status-publish","format-standard","hentry","category-technology","tag-ps_56","tag-ps_40","tag-ps_33","tag-ps_32","tag-ps_19","tag-ps_17"],"_links":{"self":[{"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/76","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=76"}],"version-history":[{"count":1,"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/76\/revisions"}],"predecessor-version":[{"id":168,"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/76\/revisions\/168"}],"wp:attachment":[{"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=76"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=76"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=76"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}