Sybase MAC OS X User Manual download pdf (Page 32)

Starting and stopping Adaptive Server

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.

1 2 ... 27 28 29 30 31 32 33 34 35 36 37 ... 53 54

No comments

Sybase MAC OS X User Manual Page 32