#!/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 # 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