script SAP DB2 restore

#!/bin/sh
echo "Starting Proses Restoring"
date
echo ""

/db2/db2dxp/sqllib/adm/db2stop force
/db2/db2dxp/sqllib/adm/db2start
hari=`date|awk '{print $1}'`
echo "Hari ini "$hari
if [ $hari = Mon ]; then
   days=sabtu
   else
   if [ $hari = Tue ]; then
      days=senin
      else
      if [ $hari = Wed ]; then
         days=selasa
         else
         if [ $hari = Thu ]; then
            days=rabu
            else
            if [ $hari = Fri ]; then
               days=kamis
               else
               if [ $hari = Sat ]; then
                  days=jumat
               fi
            fi
         fi
      fi
   fi
fi
echo "Convert " $hari " --> "$days
echo "Restore database DXP hari "$days
date
echo ""
cd /tmp

/db2/db2dxp/db2_software/bin/db2 deactivate db DXP
/db2/db2dxp/db2_software/bin/db2 restore database DXP from /sapiso/SAPPRO/db2/backup/$days REPLACE EXISTING
/db2/db2dxp/db2_software/bin/db2 rollforward db DXP query status

echo "Extract log database DXP"
date
echo ""

cd /sapiso/SAPPRO/db2/backup/$days
tar -xvf backuplog$days.tar
mv S*.LOG /db2/DXP/log_dir
echo "Restore log database DXP"
date
echo ""

/db2/db2dxp/db2_software/bin/db2 "rollforward db DXP to end of logs and complete overflow log path ('/db2/DXP/log_dir')"

/db2/db2dxp/db2_software/bin/db2 activate db DXP
/db2/db2dxp/db2_software/bin/db2 rollforward db DXP query status

echo " Restore Completed"
date
echo ""
cd /db2/DXP/log_dir
rm S*LOG