DSXchange

Hi All,
During datastage restart we need to kill all active datastage cilent connections running on the server.But some of the connections takes time to close.....it goes into FIN_WAIT state...so can someone tell me the reasons for that and what are the unix commands to kill the active connections......???

Do you know how to identify "active connections"? That would be a mandatory first step - I should have thought - before even thinking about killing them. The best way, of course, is to contact the owners of those sessions and ask them to close them. The next best way is to identify the client connections, through a combination of LIST.READU and LISTU commands and queries against the DS_LICENSE table. And they ought never to be killed with UNIX commands; there is a utility in Director for logging processes out, and a DataStage administrator command available from the DS.TOOLS menu.

Or just wait. How much time does it take for them to close? I typically am able to restart within 10 minutes or so.