
setParams() {
	echo "set parameters for $SID..."
	_o=`cat <<EOF | dbmcli -d $SID -u dbm,xxx 2>&1
	param_rmfile
	param_startsession
	param_init OLTP
	param_put CAT_CACHE_SUPPLY 1300
	param_put SEQUENCE_CACHE 6
	param_put MAXCPU 2
	param_put MAXUSERTASKS 120
	param_put SESSION_TIMEOUT 60
	param_put REQUEST_TIMEOUT 30
	param_checkall
	param_put MAXDATAVOLUMES 10
	param_commitsession
	param_addvolume 1 DATA $DEVSPACEHOME/$SID/DISKD0001 F 100000
	param_addvolume 2 DATA $DEVSPACEHOME/$SID/DISKD0002 F 100000 
	param_addvolume 3 DATA $DEVSPACEHOME/$SID/DISKD0003 F 100000 
	param_addvolume 4 DATA $DEVSPACEHOME/$SID/DISKD0004 F 100000 
	param_addvolume 5 DATA $DEVSPACEHOME/$SID/DISKD0005 F 100000
	param_addvolume 6 DATA $DEVSPACEHOME/$SID/DISKD0006 F 100000
	param_addvolume 7 DATA $DEVSPACEHOME/$SID/DISKD0007 F 100000
	param_addvolume 8 DATA $DEVSPACEHOME/$SID/DISKD0008 F 100000
	param_addvolume 1 LOG  $DEVSPACEHOME/$SID/DISKL001  F 12800
	quit
	EOF`
	_test=`echo $_o | grep ERR`
	if [ "$_test" != "" ]; then
        echo "set parameters failed: $_o" 1>&2
        exit 1
	fi
}


setBackup() {
	echo "set backup media"
	_o=`cat <<EOF | dbmcli -d $SID -u dbm,xxx 2>&1
	medium_put logsave $HOME/$SID/autolog FILE AUTO 
	quit
	EOF`
	_test=`echo $_o | grep ERR`
	if [ "$_test" != "" ]; then
        echo "setting backup $SID failed: $_o" 1>&2
        exit 1
	fi
}

restore() {
	echo -e "restoring full: $1"
	_o=`cat <<EOF | dbmcli -d $SID -u dbm,xxx 2>&1
	db_admin 
	medium_put myrecover $1 FILE DATA 0 8 YES
	util_connect dbm,xxx
	db_activate RECOVER myrecover data
	quit
	EOF`
	_test=`echo $_o | grep ERR`
	if [ "$_test" != "" ]; then
        echo "recovering $SID failed: $_o" 1>&2
        exit 1
	fi
}

