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
Inactive sessions
Moderators: chulett, rschirm, roy
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
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
-
- Premium Member
- Posts: 425
- Joined: Sat Nov 19, 2005 9:26 am
- Location: New York City
- Contact:
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
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
Julio Rodriguez
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses