#!/usr/bin/ksh
# script performs an backup of a database to the specified device
#                                                                               

#                                                                               
if [ -f /home/db2inst1/sqllib/db2profile ]; then
    . /home/db2inst1/sqllib/db2profile
fi

dbname=$1

#                                                                               
# Force anyone that is connected to the database                                
#   
   echo "  Force off any connected users"
   echo ""
   RC=1
   Counter=0
   while [ $RC -ne 0 ]
      do
         Counter=`expr $Counter + 1`
         if [ Counter -gt 40 ]
            then  echo "Could not force off all users...."
                  echo ""
                  echo `date +"%a %D %H:%M"` "*** FAILED Backup of $dbname  Could not force off all users">>$JobLog         
                     exit 14
         fi
         sleep 15
         /home/db2inst1/db2force.sh $dbname
         RC=$?
      done
      
# quiesce the database and backup the database

echo "  Begin backup of database $dbname at:" `date +"%a %D %H:%M"`
echo " "
   
db2 -v "connect to $dbname"
db2 -v "quiesce database immediate force connections"
db2 -v "connect reset"
db2 -v "backup database $dbname to /home/db2inst1/BACKUP with 2 buffers buffer 1024 parallelism 1 without prompting"
db2 -v "connect to $dbname"
db2 -v "unquiesce database"
db2 -v "connect reset"

echo "  Finish backup database $dbname at:" `date +"%a %D %H:%M"`
echo " "

# compress the backup image.

echo " begin compress the backup file"

echo " "
cd /home/db2inst1/BACKUP
gzip -v $dbname*.001

echo " end compress the backup file"
echo " "