How to get the datastage user name who has run the job...

datisaq · Post by **datisaq** » Fri Feb 05, 2010 4:53 am

In a target field i have to populate the datastage user name who has run the job? I used the system variable @LOGNAME but the output of it's the default user name "dsadm" not the user who has login into the datastage and ran the job.

There is also a variable "ISUSER" which is present in the datastage log of my jobs it's having the correct datastage user name.

But where this variable is set and where it's present i didn't find it?

can anyone please provide pointers to this?

ray.wurlod · Post by **ray.wurlod** » Fri Feb 05, 2010 5:48 am

Check DataStage credentials in the domain management part of Web Console for Information Server. My guess is that all login users are mapped to dsadm.

invincibleDeepak · Post by **invincibleDeepak** » Fri Feb 05, 2010 6:14 am

You can get this information from unix too.

invincibleDeepak · Post by **invincibleDeepak** » Fri Feb 05, 2010 6:15 am

You can get this information from unix too.

datisaq · Post by **datisaq** » Fri Feb 05, 2010 7:04 am

Thanks Ray for you reply....

You're absolutely correct the login users are mapped to "dsadm".
But our administrator is not willing to change it now.

Can you please let me know, is there any other procedure to get it?

In UNIX also, for that job the user name it's showing as dsadm only.

In my datastage job log the ISUSER variable is having correct value but i didn't know where this variable will present?

It'll be really great if you tell where this variable will be>

ray.wurlod · Post by **ray.wurlod** » Fri Feb 05, 2010 5:25 pm

There is no way to change this mapping other than to change the mapping. The threat of a major security breach given that every disgruntled employee has administrator access should convince your Administrator to get it right.