Starting the database server

This section describes how to start a database server running the demo database. See Chapter 2, “Running Sybase IQ” in System Administration Guide: Volume 1 for more information.

NoteIf your system has multiple users or is one of several machines in a subnet, edit the file $IQDIR15/demo/iqdemo.cfg to specify a unique port and server name. Change the arguments to the -n servername switch and -x tcpip{port=####} to specify a server name and port number that are not in use. If SQL Anywhere is installed on your system, do not use port number 2638.

StepsStarting a server running the demo database from Windows

  1. Log in to the host machine.

  2. Click Start, point to Programs, choose Sybase | Sybase IQ 15.2 | Start Sybase IQ Demo Database.

    When you start a server successfully, the server icon appears in the system tray. The server name is your system name followed by an underscore and iqdemo.

StepsStarting a server running the demo database from the command line (UNIX or Windows)

  1. Log in to the host machine.

  2. Change to a directory where you have write permission and make a copy of the $IQDIR15/demo directory there (%IQDIR15%\demo on Windows).

  3. At the command prompt, type the following command:

    start_iq @iqdemo.cfg iqdemo.db
    

    This starts a server running the demo database.

StepsStarting a server running the demo database with Sybase Central

The following steps assume that you have started Sybase Central and are running the Sybase IQ plug-in.

  1. Click Tools, point to Sybase IQ 15.2, choose Start Server.

  2. Follow the instructions on the screen.

    See Start Server Wizard in Sybase IQ 15.2 online help for specific connection parameters.