Starting and stopping adaptive server – Sybase MAC OS X User Manual

Page 32

Advertising
background image

Starting and stopping Adaptive Server

22

sp_password null, new_password

where null is the default password and new_password is the password that you
are assigning to the “sa” account.

Starting and stopping Adaptive Server

Once you have installed the server, you may need to stop it, or to reinitialize it
using an alternative disk location. you can stop the server by sending this
Transact-SQL command to the server:

shutdown [with nowait]

You can send this command either by using

jISQL

, or by executing

/Applications/Sybase/System/OCS-12_5/bin/isql.

You can also stop the server by using this operating system command, although
this method is not recommended, as data corruption may occur.

sudo kill -9 <pid>

where <pid> is obtained from another operating system command:

ps -ax | grep dataserver

Warning!

Use the

kill

command only as a last resort.

Once the server is stopped, you can restart it in one of two ways:

Open the Terminal window, and execute the

startserver

command found in

/Applications/Sybase/System/ASE-12_5/install:

startserver -f RUN_hostname_SYBASE

From the Finder, double-click the Start_servername.command file in
/Applications/Sybase. The command file is recognized by the Finder as a
shell script.

Advertising
This manual is related to the following products: