Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » SQL Anywhere database connections » Tutorial: Connecting to the sample database

 

Lesson 1: Starting the SQL Anywhere database server and displaying the database server messages window

Start a SQL Anywhere database server and display the database server messages window to view information about the database server.

Prerequisites

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.

 Task

  1. 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.

  2. Double-click the SQL Anywhere database server icon in the system tray to display the database server messages window.

    The SQL Anywhere 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, 16.0.0.1403) 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.

Results

A database server running the sample database is started, and the database server messages window is displayed.

Next

Proceed to Lesson 2: Connecting to the database.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0