# script performs an restore of a database from the specified device
#                                                                               

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

dbname=$1
timestamp=$2

echo "  Begin restore 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 "restore database $dbname user $username using $password from /home/db2inst1/BACKUP taken at $timestamp without prompting"
db2 -v "connect to $dbname"
db2 -v "unquiesce database"
db2 -v "connect reset"

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