Starting the database server

This section describes how to start a database server running the sample database. For complete information on starting servers, see Sybase IQ System Administration Guide.

NoteIf your system has multiple users or is one of several machines in a subnet, edit the file $ASDIR/demo/asiqdemo.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 Adaptive Server Anywhere, if that product is installed on your system.

StepsStarting a server running the sample database from Windows

  1. Log in to your host machine as the user DBA, or using an account with DBA privileges.

  2. From the Start menu, choose Programs > Sybase > Adaptive Server IQ 12.7 > Start Sybase IQ Demo Database.

    This starts a server running the sample database. The server window appears briefly, then disappears, after which the server appears as an icon in the system tray. The server name is your system name followed by an underscore and asiqdemo.

StepsStarting a server running the sample database from the command prompt (UNIX or Windows)

  1. Log in as the user DBA, or using an account with DBA privileges privileges

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

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

    start_asiq @asiqdemo.cfg asiqdemo.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. In the left pane, select the Sybase IQ plug-in.

  2. Click the Utilities tab in the right pane, or press Alt+T, I, S.

  3. Double-click Start Server or tab into the container, then press S.

  4. Follow the instructions in the Start Server Wizard.

    The following sections describe the Start Server Wizard’s screens and your options.