START SERVER statement [Interactive SQL]

Starts a database server.

Syntax

START SERVER AS database-server-name [ STARTLINE command-string ]

Remarks

The START SERVER statement starts a database server. To specify a set of options for the database server, use the STARTLINE keyword together with a command string.

START ENGINE is accepted for compatibility reasons, but is deprecated.

This SQL statement is not supported for SAP HANA databases.

Privileges

None

Side effects

None

Standards

ANSI/ISO SQL Standard
Not in the standard.

Example

This example starts a database server named sample without starting any databases on it.

START SERVER AS sample;

This example shows the use of a STARTLINE clause.

START SERVER AS eng1 STARTLINE 'dbsrv17 -c 8M';