脚本：   backup_database.sh    

#!/bin/bash

BACKUPDIR="/iqdbbackup/20170830_full"
CONNSTR="uid=dba;pwd=xxxx;eng=iqdm_n01"
DBRUN="dbisql -onerror exit -nogui -c"

TODAY=`date +%Y%m%d%H%M%S`

if [ $# -ne 1 ]
then
echo "Unknown parameter"
exit 1
fi

MODE=F

while getopts "if" arg
do
case ${arg} in
 i)
MODE=I
;;
 f)
  MODE=F
;;
esac
done

if [ "$MODE" == "F" ]
then
DUMPSQL="backup database full to '${BACKUPDIR}/iqdm_${MODE}_${TODAY}.dmp'"
else
DUMPSQL="backup database incremental to '${BACKUPDIR}/iqdm_${MODE}_${TODAY}.dmp'"
fi

${DBRUN} ${CONNSTR} ${DUMPSQL}