Our DataStage installation is on Windows 2008 Server R2 and our version is the IIS v9.1.2.0. Now I have developed some SSH scripts to remotely execute netezza scripts on the Linux Netezza Server since NZSQL tool does not have a Windows equivalent. The Shell script that is using the SSH commands are running fine when invoked from the command prompt. I have also setup SSH passwordless authentication for a OS USER that is mapped to a DataStage User.
However when I try to run the Script from a DataStage Job (either from a Sequence's execute command activity stage or from a parallel Job's before/after job routine) the Job successfully executes all other commands that are present in the Shell Script like creation of a directory and so on but while executing the SSH command the Job seems to hang as is evident from the director where we can see no further generation of logs but the Job seems to be running indefinitely (I manually killed the process after 24 hours of execution
![Smile :)](./images/smilies/icon_smile.gif)
Has anyone of you faced this issue and have managed to resolve it.
Many thanks in advance.