Start a SQL Anywhere database server and display the database server messages window to view information about the database server.
This lesson assumes that you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Connecting to the sample database.
At a command prompt, run the following command to start the database server, name the database server demo16 by using the -n server option, and connect to the sample database:
dbsrv16 -n demo16 "%SQLANYSAMP16%\demo.db"
On Windows, the database server appears as an icon in the system tray. You have successfully started a database server running the sample database. However, you cannot see or manipulate the data in the database yet. The SQL Anywhere database server icon is the only visible indication that anything has happened.
Double-click the SQL Anywhere database server icon in the system tray to display the database server messages window.
The database server messages window displays useful information, including:
The server name The name in the title bar (in this case demo16) is the server name. In this tutorial, you assigned the server name by using the -n server option. If you do not provide a server name, the database server is given the name of the first database started. This name can be used by applications when they connect to a database.
The version and build numbers The numbers following the server name (for example, 126.96.36.1993) are the version and build numbers. The version number represents the specific release of SQL Anywhere, and the build number relates to the specific instance of the software that was compiled.
Startup information When a database server starts, it sets aside some memory that it uses when processing database requests. This reserved memory is called the cache. The amount of cache memory appears in the window. The cache is organized in fixed-size pages, and the page size also appears in the window. In this case, the startup cache size and page size are the default values. For many purposes, including those of this tutorial, the default startup options are fine.
Database information The names of the database file and its transaction log file appear in the window.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|