Sybase 12.4.2 manual Using the startup utility, Starting the server on Unix

Starting the server on UNIX

Note the server starting directory

Note what directory you are in when you start the server. The server startup directory determines the location of any database files you create with relative pathnames. If you start the server in a different directory, Adaptive Server IQ cannot find those database files.

Any server startup scripts should change directory to a known location before issuing the server startup command.

Using the startup utility

For most situations, the easiest way to start a database server on UNIX is by using the startup script that Sybase provides. Using this script ensures that all required parameters are set correctly, except in special situations described later in this chapter.

❖To start the server on UNIX using the startup utility:

1 Change to a writable directory.

2 Run the start_asiq utility at the system prompt. The simple form of this command is:

start_asiq servername [ database ]

You can also include server switches or database switches, as discussed in the next section.

This command starts the named server as a background process, starts the named database if you specify it, and sets all required startup options. Once the server starts, it sends a message to the window or console where you started the server indicating that the server is running. It also displays the version of the Open Client communications library that is in use, and “possible problems” messages on failure to start. This message is saved in the stderr log. After that, all server messages go to the server log. The server log is in $ASLOGDIR/servername.nnn.svrlog, where nnn is the number of times the server has been started. See Chapter 1, “Environment Variables and Registry Entries” in Adaptive Server IQ Reference Manual for a description of $ASLOGDIR and other environment variables you may need to set.

The start_asiq command displays messages as to whether the server started or not, and

The start_asiq utility also adds the appropriate library path to the environment and sets parameters that govern Adaptive Server IQ. Parameter settings vary by platform. See your Adaptive Server IQ Installation and Configuration Guide for a list of parameter settings for your platform.

24