asking for password on db2 script

[cougartrace]

I have a script that does DB2 HADR monitoring, however during execution it asks me for the user password - is there anyway to pass that password in the script?


DB2HADRDBNAME=TDWD
#Get the local DB2 instance name
DB2INST=db2tdwd
HADRROLE="UNKNOWN"
HADRSTAT="UNKNOWN"
HADRROLE=$(su - $DB2INST -c "db2pd -hadr -db $DB2HADRDBNAME" |grep -p "HADR Information" |grep -v HADR |grep -v Role | awk '{print $1}')
HADRSTAT=$(su - $DB2INST -c "db2pd -hadr -db $DB2HADRDBNAME" |grep -p "HADR Information" |grep -v HADR |grep -v Role | awk '{print $2}')
if [[ $? = "0" ]];
then
echo "Info: $DB2HADRDBNAME ROLE IS $HADRROLE,
state is in $HADRSTAT state"
exit 0
else
echo "ERROR: CAN NOT GET INFORMATION FOR
$DB2HADRDBNAME "
exit 1
fi

 

[Annihilannic]

Which part asks for a password? The db2pd programme?

Most programmes that ask for a password communicate directly with the terminal, so you usually can't cheat by stuffing the password into standard input. Usually expect works well in those situations. It comes with an autoexpect recording tool which is handy for writing your expect script if you prefer not to do so manually.

Incidentally, seting the variables to "UNKNOWN" is superfluous as those values will be overwritten by the subsequent lines, irrespective of their success or failure.

Also for efficiency I recommend you capture the db2pd output only once and just echo it to your awk and/or grep filters twice to pull out the required pieces of information.

Annihilannic.