write_suspend.sh script (DB2)

#!/bin/sh
 export INSTHOME=/db2home/db2inst2
 date >> $INSTHOME/write_suspend.log
 echo "----START SUSPEND----" >> $INSTHOME/write_suspend.log << EOF
 EOF
 #connect to the database
 $INSTHOME/sqllib/bin/db2 connect to test >> $INSTHOME/write_suspend.log
 echo "+++" >> $INSTHOME/write_suspend.log << EOF_1
 EOF_1
 #set write condition for database
 $INSTHOME/sqllib/bin/db2 set write suspend for database >> $INSTHOME/write_suspend.log
 echo "+++" >> $INSTHOME/write_suspend.log << EOF_2
 EOF_2
 echo "----END----" >> $INSTHOME/write_suspend.log << EOF_3
 EOF_3

Loading...