The stop_asiq utility has been improved in the 12.7 ESD #3 release. It now searches the process table by login, user id (UID), and/or truncated user login. This functionality was added to accommodate UNIX and Linux systems where users with logins longer then eight characters exist. The -user parameter lets you specify a particular user on the stop_asiq command to easily stop server processes no matter how the table displays them.
The following syntax updates current stop_asiq syntax in the Sybase IQ Utility Guide.
stop_asiq [ -agent | -cleanup ] [ -stop [one | all ] ] [-wait <seconds>] [-user <user_name>] [ -help ]
The user parameter performs two functions.
If, due to truncation or substitution, stop_asiq cannot find the server/agent owned by the current user, the system manager can specify the name/id found in the process table in the -user argument to shut down the server/agent with the stop_asiq utility.
A user with root privileges can shut down another user’s server/agent without having to log in as that user. The stop_asiq utility has no 'su' or root powers, so a nonprivileged user cannot shut down a server owned by another user.
% stop_asiq -user joe
Checking system ...The following 2 server(s) are owned by other users. ## Owner PID Started CPU Time Additional Information -- --------- ------- -------- -------- ------------------------------ bill 15939 Jul.03 522:34 SVR:mpx_w DB:mpx_mult PORT:6722 asiqsrv12 -n mpx_w @/duncan/users/bill/mpx_a/mpx/w/params.cfg -x tcp jim 16180 Jul.03 553:45 SVR:mpx_r1 DB:r1 PORT:6732 asiqsrv12 @asiqdemo.cfg asiqdemo.db -gn 25 -o /ciaran/users/jim/127test The following 1 server(s) are owned by 'joe' ## Owner PID Started CPU Time Additional Information -- --------- ------- -------- -------- ------------------------------- 1: joe 28155 Mar.30 152:19 SVR:joe_asiqdemo DB:asiqdemo PORT:1746 asiqsrv12 @asiqdemo.cfg asiqdemo -gn 25 -o /fiona/users/joe/12.6/ASIQ-12 --
Please note that 'stop_asiq' will shut down a server completely without regard for users, connections, or load process status. For more control, use the 'dbstop' utility, which has options that control stopping servers based on active connections. Do you want to stop the server displayed above <Y/N>?