Sunday, July 01, 2007

Terminate or Kill a Sybase Process

From time to time, you may need to kill an internal Sybase process or processes. This requires using Sybase’s sp_who command ascertain the process identification or PID. Then you will use the kill command. Here is a run of how to kill a process via SQL.

1> sp_who
2> go
1> kill PID
2> go

I always like to reconfirm that the process or processes was/were killed.

1> sp_who
2> go

For a specific login
1> sp_who esofthub
2> go
1> kill esofthub_PID
2> go

2 comments:

Anonymous said...

What is the Error code it will generate when we kill the process as you mentioned

Anonymous said...

Hi,

I have written an article about killing processes on linux. You can get an automatic way to stop zombie processes. You can read more about that at stop linux zombie process

Regards,
Javanus