ASA Database Administration Guide
  Running the Database Server

Starting and stopping databases

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

dbeng9 asademo sample

Caution    The database file must be on the same machine as the database server. Managing a database file that is located on a network drive can lead to file corruption.

Starting a database on a running server 

You can also start databases after starting a server in one of the following ways:

• Connect to a database using a DatabaseFile (DBF) connection parameter while connected to a server. The DatabaseFile (DBF) connection parameter specifies a database file for a new connection. The database file is started on the current server.

  For more information, see Connecting to an embedded database, or DatabaseFile connection parameter [DBF].

• Use the START DATABASE statement, or choose Start Database from the File menu in Sybase Central when you have a server selected.

  For more information, see START DATABASE statement.

Limitations 

• The server holds database information in memory using pages of a fixed size. Once a server has been started, you cannot start a database that has a larger page size than the server.

• The -gd server option decides the permissions required to start databases.

Stopping a database 

You can stop a database by:

• Disconnecting from a database started by a connection string. Unless you explicitly set the AutoStop (ASTOP) connection parameter to NO, this happens automatically.

  For more information, see AutoStop connection parameter [ASTOP].

• Using the STOP DATABASE statement from Interactive SQL or Embedded SQL.

  For more information, see STOP DATABASE statement.