Hello,

as a Sybase newby, I have the following question:

Can anyone give me advise on the best way to stop Sybase Adaptive Server
at system reboots? The unix configuration guide tells me that the
preferred method of stopping AS is via the Transact-SQL shutdown
command, and as a last resort one can use the kill command. This is not
helping me very much, because of course I don't want to issue kill
commands on the server processes, but also don't want to log in to the
database manually for issueing a shutdown command. The unix admin who
restarts the system should not be bothered by manually stopping the AS,
so a stop script should be created.

Perhaps it is possible to create an isql command that logins to the
database and shuts it down. If this is the case how can this be achieved
and in such a way that no passwords are needed in the script?

Regards,

Frank

"Frank" <no (AT) spam (DOT) org> wrote

I've a simple script that kills off processes before a db load. However,
this is only for a test server. Can you be sure important processes wont be
running on your server before attempting to shut it down?

Martin

If you dont' want/can't have the SA password in the script or 'sourced'
from somewhere else then you don't have much choice. AFAIK, 'kill -15'
is well received by the dataserver process and is somewhat equivalent to
doing a 'shutdown' from the isql prompt. Somebody please slap me if I'm
wrong... OK, just slap me anyway.

Frank wrote: