Terminate an Open Server thread.
sp_terminate spid [, options]
The thread ID. This can be obtained with the sp_who procedure or by calling srv_thread_props.
Determines whether the thread is terminated immediately or by a queued disconnect event. Specify “deferred” to queue a disconnect event that occurs after previous events are handled. This is the default action. Specify “immediate” to terminate the thread immediately, ignoring current or queued events for the thread.
1> execute utility...sp_who
2> go
spid status loginame hostname blk cmd
----- ---------- ------------ ---------- ---- ----------------
1 runnable 0 NETWORK HANDLER
2 sleeping 0 CONNECT HANDLER
3 sleeping 0 DEFERRED HANDLER
4 runnable 0 SCHEDULER
12 runnable ned sonoma 0 PRINT TASK
24 running bud sonoma 0
(0 rows affected)
This example shows how to use isql to locate and terminate an errant server thread. The thread terminates immediately.
1> execute utility...sp_terminate 12, "immediate"
2> go
spid = 12;
dbrpcinit(dbproc, "sp_terminate", (DBUSMALLINT) 0);
dbrpcparam(dbproc, "@spid", 0, SYBINT4, -1,
-1, &spid);
dbrpcparam(dbproc, "@options", 0, SYBCHAR, 9,
9, "deferred");
dbrpcsend(dbproc);
This DB-Library example queues a SRV_DISCONNECT event for the thread with the thread. The next time the thread becomes runnable, it receives the disconnect event and terminates.
Use sp_who or sp_ps to find the spid for the thread to be terminated.
In a Server-Library program, use srv_termproc to terminate a thread.
spid terminated.
spid scheduled for termination.
spid not currently in use.
