Use promon to kill a server. But If I guess you got a 'hanging' _sqlsrv2 process. If you check with _connect you probably see connections on that pid. 'Bad' queries (still in 10.2A) tend to clog up the _sqlsrv2 proces event thought the query is stopped. (Nicely or brutaly).
You can see this within pomon R&D, 1, 3 and check the users connected with _connect table.
If disconnecting the users wont help then only restart of the database or kill -9 (sorry to say this) works. You absolutely have to make sure no locks are present for the users connected to that process, othewerise you bring down your database and might damage it permanently. Check this with _connect and promon to see if there are any locks before doing so.
Unfortunately I have to do this several times a month. I really hope Progress find ways to handle SQL user the same as they handle there remote ABL connections, that would make things a lot easier.
Regards,
Casper.
