Sybase 12.4.2 manual Stopping the database server, Pid

Stopping the database server

Example — Stop a server with stop_asiq

The following example uses the stop_asiq utility on UNIX systems to shut down an Adaptive Server IQ server and close all user connections to it.

When you issue the stop_asiq command, Adaptive Server IQ lists all the servers owned by other users, followed by the server(s) you own. It then asks if you want to stop your server. For example:

%stop_asiq

Checking system			for ASIQ 12 Servers ...
The following		3	server(s) are owned by other users.
##	Owner		PID	Started	CPU_Time
-- ---------			----- --------		--------	-----------------------
	hsin	19895		Mar.21	1:33
asiqsrv12 -c 16m -gd all -gm 10 -gn 25 -gp 4096 -ti 4400 -tl 300
-n hsin -x tcp
qadaily	24754		01:25:07 1286:53
asiqsrv12 -gn		25 @/express1/qa/daily/engine/new.cfg asiqdemo.db
-o /express1/qa
washburn 28350				Apr.11	0:20
asiqsrv12 -gn		25 @asiqdemo.cfg -o
/express1/users/washburn/mysybase12.4.0/asiq1
The following		1	server(s) are owned by ’janed’
##	Owner		PID	Started	CPU_Time
-- ---------		-----		--------	--------	-----------------------
1:	janed		2838	15:11:37	0:07

asiqsrv12 -c 16m -gd all -gm 10 -gn 25 -gp 4096 -ti 4400 -tl 300 @asiqdemo.cfg

--

Please note that ’stop_asiq’ will shutdown a server completely without regard for users connections or load processes status. For a finer level of detail the utility ’dbstop’ has the options to control whether a server is stopped based on active connections.

Do you want to stop the server displayed above <Y/N>?

To shut down the server, type Y (yes). Messages like the following display:

Shutting down server (2838) ...

Checkpointing server (2838) ...

Server shutdown.

To leave the server running, type N (no). You return to the system prompt and IQ does not shut down the server.

44