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! Us e 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.