How to hiding Password in the joblog

Gerald sui · Post by **Gerald sui** » Sat Sep 29, 2007 12:49 am

Hi,All.I have one job Sequence that using one Execute_Command activity to invoke one shell script to achieve some particular purpose.And I need pass some password values through the Execute_Command activity to script, then these password values will be displayed in the job log.But this is not allowed.Can anyone told me how to hiding the password values in the joblog.
Thank you so much in advance for any reply.

ray.wurlod · Post by **ray.wurlod** » Sat Sep 29, 2007 2:28 am

Pre-set the the password (and anything else you'd like) in an environment variable, and make reference to that environment variable in the script rather than hard-coding the password.

Gerald sui · Post by **Gerald sui** » Sat Sep 29, 2007 3:50 am

First,ray,Thanks for your reply.

Maybe I am not explian clearly.Let me take one Example.I want to calls up script MyScript.sh in one Exec_Command_AAA activity,and pass password $CMDW_DB2_PASSWORD(it's a Env Variable) to script MyScript.sh .Then I need switch to ExecCommand tab in activity Exec_Command_AAA. And specify the following things

Command
ksh
Parameters
#$CMDW_UTILITY_FILE_ROOT#/MyScript.sh #$CMDW_DB2_PASSWORD#

Then in this sequence job's job log,Will display the below information.
ETL_XXX..JobControl (@Execute_Command_AAA): Executed: ksh /home/dsdev2/r60_PCR173/dsutil/ag/MyScripts.sh dsadm

Notes:dsadm is the value of env variable $CMDW_DB2_PASSWORD.

Thank you so much for any reply[/img]

JoshGeorge · Post by **JoshGeorge** » Sat Sep 29, 2007 5:14 am

You might want to check if the type for $CMDW_DB2_PASSWORD is set as encrypted in the administrator itself.

ray.wurlod · Post by **ray.wurlod** » Sat Sep 29, 2007 3:26 pm

Don't pass it on the command line. Access it within the script.

Code: Select all

dsjob -user gerald -password $CMDW_DB2_PASSWORD -run -jobstatus $1 $2