run rexec in execute command stage

caola · Post by **caola** » Mon Sep 28, 2015 10:30 am

I have a ksh as below to run rexec command.
When I run the ksh in command line, it can finish successfully. But when I login to Datastage with the same user AA and invoke it from execute command stage, it gives an error:
Password: 3004-303 There have been too many unsuccessful login attempts; please see
rexec: Error in rexec system call,
rexec: (The following system error may itself be in error)
rexec: Inappropriate ioctl for device

The ksh is:

#!/bin/ksh

export HOME=XXXX
export USER=AA

SERVER=$1
Command=$2

rexec $SERVER "$Command"

return $?

I don't understand why...it's the same user, the same server...Can anybody help me out. Great thanks!

chulett · Post by **chulett** » Mon Sep 28, 2015 11:01 am

Doesn't really matter what user you log in with, the jobs run under whatever user ('engine credentials') has been setup for running jobs. Guessing that's your issue here.

qt_ky · Post by **qt_ky** » Mon Sep 28, 2015 2:07 pm

Double click a detailed job log entry to see which user it executes under.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 28, 2015 6:58 pm

Does the rexec session require a password? Authentication key?

rkashyap · Post by **rkashyap** » Mon Sep 28, 2015 8:46 pm

You are using which flavor of Unix?

Confirm that a valid entry in the .netrc file for the remote host and user actually running the job exists.
Adding to previous posts ... Information used by the automatic login feature of the rexec is in .netrc file. DataStage jobs run as phantoms and not necessarily under the login-user, consequently their UNIX environment is different than that of login-user. The .netrc is only for a specific user.

caola · Post by **caola** » Tue Sep 29, 2015 3:13 am

chulett wrote:Doesn't really matter what user you log in with, the jobs run under whatever user ('engine credentials') has been setup for running jobs. Guessing that's your issue here.

Yes. When checking the environment variables of the job, it has
USER=dsadm1
HOME=/home/dsadm1
ISUSER=AA

That's why I export HOME and USER to AA in the ksh. Then it should go to the HOME directory looking for the .netrc file and run rexec.

rkashyap · Post by **rkashyap** » Tue Sep 29, 2015 5:51 pm

Which flavor of Unix? What are the permissions on .netrc?

qt_ky · Post by **qt_ky** » Wed Sep 30, 2015 6:12 am

Double click a detailed job log entry, and look up top, at the field named "User." What is the value in that field?