ASA Database Administration Guide
Running the Database Server
Some common options
You can use the -n
as a server option (to name the server) or as a database option (to name the database).
The server and database names are among the connection parameters that client applications may use when connecting to a database. The server name appears on the desktop icon and in the title bar of the server window.
You may want to provide a meaningful database name for users of client applications. The database is identified by that name until it is stopped.
If you don't provide a database name, the default name is the root of the database file name (the file name without the .db extension). For example, in the following command the first database is named asademo, and the second sample.
dbeng9 asademo.db sample.db
You can name databases by supplying a -n
option following the database file. For example, the following command starts the sample database and names it MyDB:
dbeng9 asademo.db -n MyDB
Providing a database server name helps avoid conflicts with other server names on your network. It also provides a meaningful name for users of client applications. The server keeps its name for its lifetime (until it is shut down). If you don't provide a server name, the server is given the name of the first database started.
You can name the server by supplying a -n
option before the first database file. For example, the following command starts a server on the asademo database and gives the server the name Cambridge:
dbeng9 -n Cambridge asademo.db
If you supply a server name, you can start a database server with no database started. The following command starts a server named Galt with no database started:
dbeng9 -n Galt
For more information about starting databases on a running server, see Starting and stopping databases.
Server names and database names are case insensitive as long as the character set is single-byte.
For more information, see Connection strings and character sets.