You can start databases when you start the server, or after the server is running. To start a database when you start the server, see “Starting the database server” for details.
Sybase recommends that you run only one database per server, especially in a production environment.
There are several ways to start a database on a running server.
To start a database from DBISQL or Embedded SQL, use the START DATABASE statement. For a description, see START DATABASE statement [DBISQL] in the Sybase IQ Reference Manual.
To start and connect to a database from DBISQL or Sybase Central, use a data source that specifies the database file. See “Working with ODBC data sources”.
To start and connect to a database when you start DBISQL from a system command prompt, include the parameter “DBF=db-file” in the connection parameters. See “Connecting to the sample database from Sybase Central or DBISQL”
To start a database from Sybase Central, see Chapter 4, “Managing Databases,” in Introduction to Sybase IQ
To start an embedded database, while connected to a server, connect to a database using a DBF parameter. This parameter specifies a database file for a new connection. The database file is loaded onto the current server.
The server holds database information in memory using pages of a fixed size. Once a server has been started, you cannot load a database that has a larger Catalog page size or IQ page size than the server. For this reason, you should always set the Catalog page size to its maximum value, 32768 bytes, with the -gp switch.
The -gd server command-line option determines the permission level required to start databases. By default, this option is set to DBA, so that only users with database administrator privileges can start IQ databases. However, you can also set this option to ALL or NONE. ALL means that all users can start a database. NONE means that no users, including the DBA, can start a database.
You can stop a database in the following ways:
Disconnect from a database started by a connection string. The database stops automatically when the last user disconnects from it, unless you explicitly set the AUTOSTOP connection parameter to NO.
From DBISQL or Embedded SQL, use the STOP DATABASE statement.
For information, see STOP DATABASE statement [DBISQL] in the Sybase IQ Reference Manual.
