Page 1 of 1

Inactive sessions

Posted: Tue Aug 03, 2010 3:24 am
by kamesh_sk
HI,

We are connecting to DS client through agents like citrix client, and after a few minutes of inactive session citrix disconnects and hence my connection to Datastage. This creates a lot of Inactive session in the server and when i use ps -fu dsadm|grep dsapi there are lot of slave or inactive sessions.
Due to these inactive sessions i get the problem of project lock quiet often.
I need to kill these inactive sessions after N period/time...
Can anyone help me to understand/know as how do i kill these inactive sessions without manual intervention.

Would really appreciate any response or help .

Thanks
Kamesh

Posted: Tue Aug 03, 2010 6:41 am
by chulett
I'm assuming the "deadlock daemon" is still around in this version, it is something that would periodically clear things of that nature for you. Search here for the details on enabling / configuring it.

Posted: Tue Aug 03, 2010 7:23 am
by kamesh_sk
Thanks,

The following viewtopic.php?t=93324&postdays=0&postorder=asc&start=0 helped a lot.
I believe now i can configure the dsdlockd.config file under the engine and kill my locks .
Great tip and help.
Thanks

Posted: Tue Aug 03, 2010 7:51 am
by JRodriguez
Well... From the Big Blue's new bag of tricks for 8.x

There is a nice script under the default IS installation (/IBM/InformationServer/ASBServer/bin) directory cleanup_abandoned_locks.sh that should help you out with cleaning all orphan sessions

The script need to be execute while logged in as root. Please make sure that all users are logged out before you do this