Shell Programming and Scripting

I have a script that works well if i execute manually using informix user. However, it does not execute properly if triggered using the scheduler (ESP). This is the partial part where it doesn't work.

i added some tracing but i can't figure it out.

Code:

#!/bin/ksh

let db_is_up=0
db_is_up=`onstat - 2>/dev/null | grep Up | wc -l`
echo "db_is_up = "$db_is_up >> space_out1.log
if [ $db_is_up -eq 1 ]; then
#if [-n  "`onstat - 2>/dev/null | grep Up`" ]; then
echo "bfore PAGESIZE "$PGSIZE >> space_out1.log
PGSIZE=`onstat -b | grep "buffer size" | awk '
BEGIN { tok_cnt=0 ; buffer_size="" ; }
{
tok_cnt = split ( $0 , tok_arr, " " ) ;
  {
  for ( i=0 ; i <= tok_cnt ; i++ )
    {
    if ( tok_arr[i] == "buffer" )
      {
      buffer_size=tok_arr[i-1]
      printf ("%s", buffer_size )
      }
    }
  }
}
'`

Moderator's Comments:

edit by bakunin: please use CODE-tags when posting code, terminal output or similar things. Thank you.

Check the runtime environment settings
Use absolute path in your script

Try sourcing the profile, like

Code:

. ~/.profile
#then your code

regards,
Agamed

there's nothing inside the .profile. it's just contain the HISTFILE and PATH. the path is already defined on the script. Actually the script runs but stop on the part

export INFORMIXDIR=$IFXDIR
export INFORMIXSERVER=$IFXINS
export ONCONFIG=$IFXCFG
export PATH=$IFXDIR/bin:$IFXDIR/lib:/usr/bin:/usr/local/bin:/etc:/usr/sbin:/sbin:/bin

echo "INFORMIXDIR ="$IFXDIR >> space_out1.log
echo "INFORMIXSERVER ="$IFXINS >> space_out1.log
echo "ONCONFIG ="$IFXCFG >> space_out1.log
echo "PATH ="$PATH >> space_out1.log

I can see the values of the above parameters and all of those are good.

if [ $db_is_up -eq 1 ]; then
.......
fi

originally, this is the code, but this does not work.

if [-n "`onstat - 2>/dev/null | grep Up`" ]; then
echo "PAGESIZE" ......
fi

I decided to set it to

db_is_up=`onstat - 2>/dev/null | grep Up | wc -l`
if [ $db_is_up -eq 1 ]; then
echo ......
fi

Any idea on the korn shell side? is the logic correct? Although, i doubt it is something from the environment settings, I can't figure out what is missing as the variables above are the on needed.

a) On which OS are you ?

b) Try to use

Code:

set -x

analyze the output and see if it helps to locate where the erroneous behaviour occures

Post the error you are getting on the screen or log, that will help us analyze the error.

As per your post, this is the latest code you are using

Code:

db_is_up=`onstat - 2>/dev/null | grep Up | wc -l`
if [ $db_is_up -eq 1 ]; then
echo ......
fi

Try giving the full path for "onstat"

regards,
Ahamed

Back to fundamentals.
Please post the output from this command when typed on the command line:

Code:

onstat -

Next let's see if "onstat" works in background.

Code:

nohup onstat - &

The output should be in a file called "nohup.out". Please post that output.