Ways to Start Database Servers

The first step in running Sybase IQ is to start the database server.

You can start the server in all of these ways:

Start the server with the Sybase-provided server startup utility, start_iq.
Run the Start Database Server wizard in Sybase Central. See the Online Help for the Sybase Central IQ Plug-in. To start and stop multiplex servers interactively, always use Sybase Central.
Using the Sybase Control Center. See Sybase Control Center 3.2.0 > Sybase Control Center for Sybase IQ.
Start the server from the Windows Start menu.
Start the server and the iqdemo database with a Sybase-provided configuration file.
Place a server startup command in a shortcut or desktop icon.

Note: You can also configure Windows systems to start an IQ server automatically (as a Windows Service) when the system is booted. For details, see the Installation and Configuration Guide.
Include a server startline in an ODBC data source.
Include a server startline in a utility command.
Issue a SQL command from Interactive SQL to start an additional server.

Note: If you will be using remote data access capabilities to insert data from other databases or to issue queries to other databases, see System Administration Guide: Volume 2 > Accessing Remote and Data System Administration Guide: Volume 2 > Server Classes for Remote Data Access.

The Server Startup Utility
The startup utility, start_iq, runs on all platforms, and ensures that required parameters are set correctly, with a few documented exceptions.
Starting Servers from the Windows Start Menu
Certain methods for starting the database server are specific to Windows systems. You can also use any of the generic methods to start the database server.

Parent topic: Sybase IQ Startup

Related concepts

How to Start the iqdemo Database

International Languages and Character Sets

Server Names

ODBC Data Sources

Ways to Start and Stop Databases

Connection Parameters in ODBC Data Sources

JDBC Drivers

Starting a Server from Interactive SQL

Connecting to the Demo Database from Interactive SQL

Created August 28, 2013. Send feedback on this help topic to Technical Publications: pubs@sap.com