START ENGINE statement [DBISQL]

Description

Starts a database server.

Syntax

START ENGINE AS engine-name [ STARTLINE command-string ]

Examples

Example 1

Start a database server, named “eng1”, without starting any databases on it:

START ENGINE AS eng1

Example 2

This example shows the use of a STARTLINE clause.

START ENGINE AS eng1 STARTLINE 'start_iq -c 8096'

Usage

To specify a set of options for the server, use the STARTLINE keyword together with a command string. Valid command strings are those that conform to the database server command line description in Chapter 1, “Running the Database Server” in the Utility Guide.

Several server options are required for Sybase IQ to operate well. To ensure that you are using the right set of options, Sybase recommends that you start your server by using either Sybase Central or a configuration file with the start_iq command.