Sunday, April 28, 2013

How To Clear Locked datastage Jobs

There are times when a user may be disconnected from the network while a job is open. You would normally use the web console to look for open sessions and then disconnect these but there are some occassions when the sessions do not appear on the web console.
This handy little script is what you need.

cd \IBM\InformationServer\ASBServer\bin
C:\IBM\InformationServer\ASBServer\bin>cleanup_abandoned_locks.bat
Enter the username: jim
Enter the password: jim
C:\IBM\InformationServer\ASBServer\bin>

Note that this script is found (and run) on the DSEngine Server.

0 comments:

Post a Comment

Please Post your Comments..!