Shell Programming and Scripting

num_tasks=`sqlplus -s batch_user/batch_user@acsblest << EOF1 
set heading off
SET FEEDBACK OFF
SET PAGESIZE 0
SET LINESIZE 900
select cp_num_run_ from fusionhc_chk where cc_alias = 'eCustomerCMEObjMgr_enu';
EOF1`

echo $num_tasks

max_tasks=`sqlplus -s batch_user/batch_user@acsblest << EOF2 
set heading off
SET FEEDBACK OFF
SET PAGESIZE 0
SET LINESIZE 900
select cp_max_task from fusionhc_chk where cc_alias = 'eCustomerCMEObjMgr_enu';
EOF2`
echo $max_tasks
per_load=$num_tasks/$max_tasks
echo $per_load
if [ "$per_load" -gt "0.95" ]
then
echo "not good"
fi
exit

3
20
3/20

result=\
`sqlplus -s batch_user/batch_user@acsblest << EOF1 
set heading off
SET FEEDBACK OFF
SET PAGESIZE 0
SET LINESIZE 900
select cp_num_run_ / cp_max_task 
      from fusionhc_chk 
      where cc_alias = 'eCustomerCMEObjMgr_enu';
EOF1`
echo $result

result=`echo "$num_tasks / max_tasks " | bc -l`
echo $result

#!/bin/ksh

typeset -i num_tasks="${1}"
typeset -i max_tasks="${2}"

typeset threshold='.95'

echo "num->[$num_tasks]"
echo "max->[$max_tasks]"

per_load=$(echo "scale=2; $num_tasks / $max_tasks" | bc)

echo "per_load->[$per_load]"

if [ "$(echo "if (${per_load} > ${threshold}) 1" | bc)" -eq 1 ]; then
   echo "not good"
fi

num_tasks=`sqlplus -s batch_user/batch_user@$SIEBEL_DB_ORACLESID << EOF2 
set heading off
SET FEEDBACK OFF
SET PAGESIZE 0
SET LINESIZE 900
select cp_num_run_ / cp_max_task 
      from fusionhc_chk 
      where cc_alias = 'eCustomerCMEObjMgr_enu';
EOF2`
echo $num_tasks
set -x
if [ $num_tasks > 0.95 ]
then
echo "not good"
fi
exit

.15
+ [ .15 ]
+ 1> 0.95
+ echo not good
not good
+ exit

if [ "$(echo "if (${$num_tasks} > '.95') 1" | bc)" -eq 1 ]; then
   echo "not good"
fi

.15
+ bc
srvr_load_check.ksh[42]: "if (${$num_tasks} > '.95') 1": bad substitution
+ [  -eq 1 ]
+ exit