Starting the database server

This section describes how to start a database server running the sample database. For complete information on starting servers, seeChapter 2, “Running Sybase IQ” in System Administration Guide: Volume 1.

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 the -x ‘tcpip{port=####} to specify a server name and port number that are not in use. Avoid the port number 2638, which is also the default port for SQL Anywhere, if that product is installed on your system.

StepsStarting a server running the sample database from Windows

  1. Log in to the host machine.

  2. Click Start, point to Programs, choose Sybase | Sybase IQ 15.1 | 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 sample 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 sample database.

StepsStarting a server running the sample 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.1, choose Start Server.

  2. Follow the instructions on the screen.

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