In addition to using the dbstop command, on UNIX platforms you can also stop the database server using the stop_asiq command. For full details on when to use stop_asiq, see the section “Stopping the database server” in Chapter 2, “Running Sybase IQ” in the Sybase IQ System Administration Guide.
stop_asiq [-agent | -stop { one | all } ]
When used in a UNIX operating system command line, stop_asiq is
an interactive utility that lists all of the servers owned by other
users, lists the server(s) you own, then asks you if you want to
stop your server. If you respond Y (yes), stop_asiq shuts
down your server and closes all users connections to your server.
If you respond N (no), stop_asiq returns
to the operating system command prompt level and your server continues
to run.
Note that when stop_asiq is used, the following message appears:
"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."
Normally, you should not shut down a server while the server is still connected to one or more clients. If you try this, you get a warning that any uncommitted transactions will be lost. Disconnect or close all the clients and try again.
The -agent option shuts down the IQ Agent. on UNIX. On Windows, the IQ Agent runs as a service and the Service Manager administers it. For more information about stopping the IQ Agent, see “Troubleshooting IQ Agent startup”in “Running Sybase IQ,” Sybase IQ System Administration Guide.
You can also use stop_asiq in a UNIX cron or at job with the -stop option. No operator prompting occurs and no operator action is required when the -stop option is specified.
-stop one In a UNIX cron or at job, shut down a single server, when exactly one running server was started by the user ID that starts the cron or at job.
-stop all In a UNIX cron or at job, shut down all servers that were started by the user ID that starts the cron or at job.
You must specify the full pathname to the stop_asiq executable
in the cron statement.
The following example illustrates using stop_asiq interactively to list all the servers that are running, then shut down one server.
% 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
start_asiq -c 32m -gd all -gl all -gm 10 -gn 25 -gp 4096 -ti 4400
-n hsin -x tcp
qadaily 24754 01:25:07 1286:53
start_asiq -gn 25 @/exp1/new.cfg asiqdemo.db
-o /exp1/qa
wb 28350 Apr.11 0:20
start_asiq -gn 25 @asiqdemo.cfg -o
/exp1/wb/mysybase12/asiq1
The following 1 server(s) are owned by ’janed’
## Owner PID Started CPU_Time
-- --------- ----- -------- -------- -----------------------
1: janed 2838 15:11:37 0:07
start_asiq -c 32m -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>? Y
Shutting down server (2838) ... Checkpointing server (2838) ... Server shutdown.
Chapter 2, “Running Sybase IQ” in Sybase IQ System Administration Guide
