Starting Servers

Different ways to start a server.

Server Startup Methods for Any Platform

Several methods start the database server.

To Start the Server From ... Do This ...

Server startup utility

Enter a start_iq command on the command line.

Syntax:

start_iq [ options ] 

If you enter several command line options, you must enter them all on one line (without carriage returns).

For ease of use, specify the database name when you start the server. This starts the database and server together.

Omit the database name to start the server without starting a database. If you omit the database name, you must name the server explicitly using the -n server switch. Use this method when you create or restore a database, or when you only want to control starting and stopping the server, leaving database use to client software.

Configuration file

Start the server and the iqdemo database with a SAP Sybase-provided configuration file.

Server startup command

Place a server startup command in a shortcut or desktop icon.

ODBC datasource Include a server start line in the datasource.
Utility command Include a server start line in a utility command.
Interactive SQL Issue a SQL command from Interactive SQL to start an additional server.
Sybase Control Center To start in Sybase Control Center, see the Sybase Control Center for SAP Sybase IQ online help in SCC or at http://sybooks.sybase.com/sybooks/sybooks.xhtml?prodID=10680.

Windows Server Startup Methods

Several methods start a Windows server.

To start the server from... Do this...

Command line

Run the stop_iq or dbstop command.

Desktop

Right-click the server icon in the system tray, and choose Start server name.

Windows Start menu Click Start > All Programs > Sybase > Sybase IQ 16.0 > Start Sybase IQ Demo Database.

Service Manager

If you started the server as a Windows service:
  1. On the Control Panel, choose Administrative Tools > Services.
  2. Choose the SAP Sybase IQ service, then click Start the service.