#!/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