#!/bin/csh -f
#
# nightly_backup.sh - written by Kevin P. Inscoe (kevin.inscoe@cbis.com)
#
#

# define global environment variables
source /opt/bin/ondemand_globals.sh
env

# define local variables
set adsm_save = "/backup/adsm/adsmfiles_`/bin/date '+%y%m%d'`.tar"

# announce ourselves
/bin/echo "Nightly OnDemand backup beginning at" `/bin/date` "..."
/bin/uname -a

# This will stop OnDemand server
/opt/bin/dgsp arssockd

# shutdown DB2 from OnDemand

# shutdown DB2
/bin/echo "Stopping DB/2..."
/bin/cat << EOF | db2
connect to archive
force application all
quit
EOF

/bin/echo "Stopping DB/2 from OnDemand..."
/usr/lpp/ars/bin/ars_db -hv
sleep 30

# restart DB2 without OnDemand
/bin/ps -ef | /bin/grep db2
/bin/echo "Restarting DB/2 without OnDemand..."
db2start
sleep 30

# start OnDemand backup
/usr/lpp/ars/bin/ars_db -v -y /backup/db2

# Start DB/2 archive connection
/usr/lpp/ars/bin/ars_db -gkv

# backup ADSM catalogs database to /adsmfiles
/usr/lpp/ars/bin/ars_adsm -dv

# tar /adsmfiles to $adsm_save and compress
cd /adsmfiles
/bin/echo "adsm save file is" $adsm_save
/bin/tar cvf $adsm_save .
/bin/compress $adsm_save
cd /tmp

# Restart OnDemand listeners now
sleep 300
/usr/lpp/ars/bin/arssockd

# perform makesysb's
/bin/rm -f /spdata/backup/bos.obj.node1*
/usr/bin/mksysb '-m' '-v' '-i' '-X' /spdata/backup/bos.obj.node1.`/bin/date '+%y%m%d'`

# Now cleanup old archives...
/opt/bin/clean_archive.sh

# Say goodnight Gracie...
/bin/echo "Nightly OnDemand backup done at" `/bin/date` "..."
/bin/uname -a

exit 0