To stop a server, run the stop_asiq command, for example:
stop_asiq
Checking system for IQ 12 Servers ...The following 2 server(s) are owned by 'kthayer' ## Owner PID Started CPU_Time -- --------- ----- -------- -------- 1: kthayer 4378 10:34:42 0:04 start_asiq @asiqdemo.cfg asiqdemo.db -o /c--2: kthayer 4726 10:41:09 0:04 start_asiq @jd_banking.cfg jd_banking.db -o /c--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. Enter the server to shutdown (’1’...’2’) or ’Q’ to Quit:
2
Shutting down server ...Checkpointing server ...............Server shutdown.
The stop_asiq -agent command lets you stop the IQ Agent on your Unix or Linux system. This is compatible with Sybase IQ 12.5 if you have ESD8 or above installed.
To use stop_asiq in a cron or at job, specify the utility with the appropriate -stop option:
stop_asiq -stop one
Setting -stop one shuts down a single server, when exactly one running server was started by the user ID that starts the cron or at job. This prevents accidentally shutting down the wrong server if several are running.
stop_asiq -stop all
Setting -stop all shuts down all servers that were started by the user ID that starts the cron or at job.
You can specify both options on the same command, for example:
stop_asiq -agent -stop all
You must specify the full pathname to the stop_asiq executable
in the cron statement.
There are other ways to stop an IQ database server:
Run the Interactive SQL (DBISQL) STOP ENGINE command
Select the server name and choose Stop from the dropdown in Sybase Central. For details, see Introduction to Sybase IQ.
Run the Stop utility, documented in the Sybase IQ Reference Manual, Chapter 4, “Database Administration Utilities.”
