xctl problem on script

I have a script which will run across the co-servers with the informix xctl command. The script is running fine at the command prompt; but it fails if i run same when I put it on the crontab. Script: allusers=`/usr/informix/bin/xctl /usr/informix/bin/onstat -u | grep informix | wc -l | awk ' { print $1 }'` echo $allusers Will anyone please help me out. I tried even exporting the xctl command also; but failed. Thanks Sent via Deja.com http://www.deja.com/

Are you sure you are setting all of the environment variables properly in the script?. INFORMIXDIR, and INFORMIXSERVER need to be set. What errors do you get? The exact error output would be quite helpful. Will In article <93cju3$jjj$1@nnrp1.deja.com>, mazafar4@my-deja.com wrote: > I have a script which will run across the co-servers with the informix > xctl command. The script is running fine at the command prompt; but it > fails if i run same when I put it on the crontab. > Script: > allusers=`/usr/informix/bin/xctl /usr/informix/bin/onstat -u | grep > informix | wc -l | awk ' { print $1 }'` > echo $allusers > > Will anyone please help me out. I tried even exporting the xctl command > also; but failed. > > Thanks > > Sent via Deja.com > http://www.deja.com/ > Sent via Deja.com http://www.deja.com/

The complete script is this: INFORMIXSERVER=tcms; export INFORMIXSERVERtoolsdir=/usr/informix/bin; export toolsdir allusers=`$toolsdir/xctl $toolsdir/onstat -u | grep informix | wc -l | awk ' {print $1 }'` ##XCTL="$toolsdir/xctl"; export XCTL ##ONSTAT="$toolsdir/onstat"; export ONSTAT ##allusers=`$XCTL $ONSTAT -u | grep informix | wc -l | awk ' {print $1 }'` if [ $allusers -gt 1 ] then echo "Informix" else echo "Sorry" fi In article <93clcp$kr2$1@nnrp1.deja.com>, William Rice <ricew@operamail.com> wrote: > Are you sure you are setting all of the environment variables properly > in the script?. INFORMIXDIR, and INFORMIXSERVER need to be set. > > What errors do you get? The exact error output would be quite helpful. > > Will > > In article <93cju3$jjj$1@nnrp1.deja.com>, > mazafar4@my-deja.com wrote: > > I have a script which will run across the co-servers with the > informix > > xctl command. The script is running fine at the command prompt; but > it > > fails if i run same when I put it on the crontab. > > Script: > > allusers=`/usr/informix/bin/xctl /usr/informix/bin/onstat -u | grep > > informix | wc -l | awk ' { print $1 }'` > > echo $allusers > > > > Will anyone please help me out. I tried even exporting the xctl > command > > also; but failed. > > > > Thanks > > > > Sent via Deja.com > > http://www.deja.com/ > > > > Sent via Deja.com > http://www.deja.com/ > Sent via Deja.com http://www.deja.com/

INFORMIXDIR is not set, my guess would be it should be set to /usr/informix. If this is not the problem, redirect standard error and standard out to a file, and post what that file contains... Will In article <93cmj2$lta$1@nnrp1.deja.com>, mazafar4@my-deja.com wrote: > The complete script is this: > INFORMIXSERVER=tcms; export INFORMIXSERVER> toolsdir=/usr/informix/bin; export toolsdir > allusers=`$toolsdir/xctl $toolsdir/onstat -u | grep informix | wc -l | > awk ' {print $1 }'` > ##XCTL="$toolsdir/xctl"; export XCTL > ##ONSTAT="$toolsdir/onstat"; export ONSTAT > ##allusers=`$XCTL $ONSTAT -u | grep informix | wc -l | awk ' {print > $1 }'` > if [ $allusers -gt 1 ] > then > echo "Informix" > else > echo "Sorry" > fi > > In article <93clcp$kr2$1@nnrp1.deja.com>, > William Rice <ricew@operamail.com> wrote: > > Are you sure you are setting all of the environment variables properly > > in the script?. INFORMIXDIR, and INFORMIXSERVER need to be set. > > > > What errors do you get? The exact error output would be quite > helpful. > > > > Will > > > > In article <93cju3$jjj$1@nnrp1.deja.com>, > > mazafar4@my-deja.com wrote: > > > I have a script which will run across the co-servers with the > > informix > > > xctl command. The script is running fine at the command prompt; but > > it > > > fails if i run same when I put it on the crontab. > > > Script: > > > allusers=`/usr/informix/bin/xctl /usr/informix/bin/onstat -u | grep > > > informix | wc -l | awk ' { print $1 }'` > > > echo $allusers > > > > > > Will anyone please help me out. I tried even exporting the xctl > > command > > > also; but failed. > > > > > > Thanks > > > > > > Sent via Deja.com > > > http://www.deja.com/ > > > > > > > Sent via Deja.com > > http://www.deja.com/ > > > > Sent via Deja.com > http://www.deja.com/ > Sent via Deja.com http://www.deja.com/