ASA Database Administration Guide
Running the Database Server
The general form for the server command is as follows:
executable [
server-options ] [
database-file [ database-options ], ...]
If you supply no options and no database file, then on Windows operating systems a dialog appears, allowing you to use a Browse button to locate your database file.
The elements of the database server command include the following:
Executable This can be either the personal server or the network server.
For the file names on different operating systems, see Introduction.
In this chapter, unless discussing network-specific options, we use the personal server in sample commands. The network server takes a very similar set of options.
Server options These options control the behavior of the database server for all running databases.
Database file You can specify zero, one, or more database file names. Each of these databases starts and remains available for applications.
| Caution The database file and the transaction log file must be located on the same physical machine as the database server. Database files and transaction log files located on a network drive can lead to poor performance and data corruption. |
Database options For each database file you start, you can provide database options that control certain aspects of its behavior.
In this section, we look at some of the more important and commonly-used options.
For full reference information on each of these options, see The database server.
In examples throughout this chapter where there are several options, we display them on separate lines for clarity, as they could be written in a configuration file. If you type them directly at the command prompt, you must type them all on one line.
Database and server options are generally case sensitive. You should type all options in lower case.
To list the database server options
Open a command prompt.
Type the following command:
dbeng9 -?
Starting the database server on Windows CE