CHAPTER 2 Running Adaptive Server IQ

See “Using command-line switches” on page 28 for a description of commonly used startup parameters.

Note To start the server without starting any database, you omit the database file from the asiqsrv12 command and specify a servername. See “Naming the server and databases” on page 31 for a discussion of why it is preferable to include both the database and server in the startup command.

If you supply no switches and no database file on Windows NT, a dialog box is displayed, allowing you to use a Browse button to locate your database file.

To start the server in a separate session, use the Windows NT start command:

start asiqsrv12 [ server-switches ] database [ database-switches ]

Running the server outside the current session

When you log on to a computer using a user ID and a password, you establish a session. When you start a database server, or any other application, it runs within that session. When you log off the computer, all applications associated with the session terminate.

In a production environment, IQ database servers must be available all the time. To make this easier, you can run Adaptive Server IQ in such a way that, when you log off the computer, the database server remains running. The way you do this depends on your operating system.

Windows NT service You can run the Windows NT database server as a service. This has many convenient properties for running high availability servers.

UNIX daemon You can run the UNIX database server as a daemon by using the -udcommand-line option, enabling the database server to run in the background, and to continue running after you log off.

27

Page 47
Image 47
Sybase 12.4.2 manual Running the server outside the current session