Sybase IQ gives you great flexibility in performing these three steps. This chapter explains options for steps 1 and 2 and suggests which to choose, depending on your situation. The next chapter explains options for step 3.
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 utility, start_asiq. See “Starting servers with the startup utility”.
See “Rules for running multiplex servers” before starting a multiplex server.
Run the Start Database Server wizard in Sybase Central. See “Starting servers with Sybase Central”. To start and stop multiplex servers interactively, always use Sybase Central.
Start the server from the Windows Start menu. See “Starting servers from the Windows Start menu”.
Start the server and the sample database with a Sybase-provided configuration file. See “Starting the asiqdemo database”.
Place a server startup command in a shortcut or desktop icon.
You can also configure Windows systems to start an IQ
server automatically when the system is booted. For details, see “Installing Sybase
IQ as a Service” in Sybase IQ Installation and Configuration Guide.
Include a server startline in an ODBC data source. See “Creating and editing ODBC data sources”.
Include a server startline in a utility command.
Issue a SQL command from Interactive SQL to start an additional server. See “Starting a server from DBISQL”.
If you will be using remote data access capabilities
to insert data from other databases or to issue queries to other
databases, see Chapter 16, “Accessing Remote Data”and Chapter 17, “Server Classes for Remote Data Access.”
