To stop a server, run the stop_iq command, for example:
stop_iq
Checking system... The following 2 server(s) are owned by 'admin' ## Owner PID Started CPU_Time –– ––––––––– ––––– –––––––– –––––––– 1: admin 4378 10:34:42 0:04 start_iq –gn 25 @iqdemo.cfg iqdemo.db –o /c –– Please note that ’stop_iq’ will shutdown a server completely without regard for users, connections or load process status. For a finer level of detail the utility ’dbstop’ has the options to control whether a server is stopped based on active connections. 2: admin 4726 10:41:09 0:04 start_iq –gn 25 @jd_banking.cfg jd_banking.db –o /c –– Enter the server to shutdown (’1’...’2’) or ’Q’ to Quit:
2
Shutting down server ... Checkpointing server ............... Server shutdown.
The stop_iq –agent command lets you stop the IQ Agent on your UNIX or Linux system.
To use stop_iq in a cron or at job, specify the utility with the appropriate –stop option:
stop_iq –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_iq –stop all
You can also use stop_iq to shut down IQ agent, for example:
stop_iq –agent –stop all
Setting –stop all shuts down all servers that were started by the user ID that starts the cron or at job.
You must specify the full path name to the stop_iq executable
in the cron statement.
For complete stop_iq syntax, see the Utility Guide.
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 Sybase Central menu. For details, see the Introduction to Sybase IQ.
Run the Stop utility, dbstop, documented in the Utility Guide.
