#!/bin/csh -f
# define global environment variables
# Default DB2 product directory
setenv DB2DIR "/usr/lpp/db2_05_00"
setenv DB2HOME "/u/archive/sqllib"
#-----------------------------------------------------------------------
# DB2INSTANCE [Default null, values: Any valid instance name]
# Specifies the instance that is active by default.
#-----------------------------------------------------------------------
setenv DB2INSTANCE "archive"
setenv INSTHOME "/u/archive"
#-----------------------------------------------------------------------
# Add the directories:
# INSTHOME/sqllib/bin - database executables
# INSTHOME/sqllib/adm - sysadm executables
# INSTHOME/sqllib/misc - miscellaneous utilities
# to the user's PATH.
#-----------------------------------------------------------------------
setenv PATH ${PATH}:${INSTHOME}/sqllib/bin:${INSTHOME}/sqllib/adm
setenv PATH ${PATH}:${INSTHOME}/sqllib/misc
# create our signal file for CAMS NT .asp pages to tell we are NOT the
# running node anymore...
/bin/echo "" `/bin/hostname` "OnDemand is down" > /var/html/htdocs/failed.html
/bin/echo "" `/bin/hostname` "OnDemand is down
" >> /var/html/htdocs/failed.html
# Notify operations via ITO
/bin/echo "OnDemand shutdown initiated" | /opt/bin/ito_msg_gen critical OnDemand AIX OS
# This will stop OnDemand server
/opt/bin/dgsp arssockd
# shutdown DB2
/bin/cat << EOF | db2
connect to archive
force application all
quit
EOF
/usr/lpp/ars/bin/ars_db -hv
sleep 30
/usr/lpp/ars/bin/ars_adsm -tv
sleep 30
exit 0