ASA User's Guide

A database server can have more than one database loaded at a time. You can load databases and start the server at the time, as follows:

dbeng6 asademo.db sample.db

You can also load databases after starting a server, in one of 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
```
-gd
```
server command-line option determines the permissions required to load databases.

You can unload a database by:

Disconnecting 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 .
Using the STOP DATABASE statement from Interactive SQL or Embedded SQL,.
For a description, see STOP DATABASE statement .


	Expand Search