User's Guide
PART 1. Working with Databases
CHAPTER 1. Running the Database Server
A database server can have more than one database loaded at a time. You can load databases at the time the server is started, as follows:
dbeng6 asademo.db sample.db
You can also load databases after a server is started in the following ways:
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.
For more information, see Connecting to an embedded database.
From Interactive SQL, use the START DATABASE statement.
For a description, see START DATABASE statement.
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 page size than the server.
The permissions required to load databases is determined by the -gd server command-line option.
You can unload a database in the following ways:
Disconnect from a database loaded by a connection string. Unless you explicitly set the AUTOSTOP connection parameter to NO this happens automatically.
For information, see AutoStop connection parameter.
From Interactive SQL or Embedded SQL, use the STOP DATABASE statement.
For a description, see STOP DATABASE statement.