Forcefully disconnect a user/kill a process?

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Ultramundane
Participant
Posts: 407
Joined: Mon Jun 27, 2005 8:54 am
Location: Walker, Michigan
Contact:

Forcefully disconnect a user/kill a process?

Post by Ultramundane »

What is the best way to forcefully disconnect/terminate a user process?

kill -15, then kill -9 on user processes? Just shutdown the server and wait for tcp_finwait2 time? I have tcp_finwait set at 60 so after 30 seconds AIX will terminate the network connections and the service can be restarted. You seem to be able to validate that the connections are gone by running
netstat -a | grep "$(hostname)\.dsrpc"

and that the service is down by running:
netstat -a | grep "\*\.dsrpc"
ps -ef | grep dsrpc

After all that, onto the issue.
Occassionally, a windows client will hang and will have to be terminated (on windows). This will sometimes leave a dsapi_slave 7 6 0 process running on the server using an entire CPU. That is, the process is using 100% of one cpu. This process will never stop. The client has closed their connection, yet the process is still running. I even let these processes run for several days and they still did not stop. Is it safe to kill these processes? Is there a better method?

Thanks.
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

Whack them. If the Client session is disconnected, then do a kill -15 else kill -9. You should do this regularly, because this problem has always existed with the product. Sometimes when viewing data the user kills the Designer rather than wait for that activity to finish. Those processes go nuts on the Server side and chew up resources. Get in the habit of clearing those yourself whenever you kill a Client.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Ultramundane
Participant
Posts: 407
Joined: Mon Jun 27, 2005 8:54 am
Location: Walker, Michigan
Contact:

Post by Ultramundane »

Will do. Thanks for your feedback.
Post Reply