Starting and Stopping Databases

You can start databases when you start the server, or after the server is running.

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 Interactive SQL or Embedded SQL, use the START DATABASE statement.
To start and connect to a database from Interactive SQL, use a data source that specifies the database file.
To start and connect to a database when you start Interactive SQL from a system command prompt, include the connection parameter “DBF=db-file”.
To start an embedded database while connected to a server, connect to a database using a DBF parameter that specifies a database file for a new connection. The database file is loaded onto the current server.