topic Execute command in AWK and integrate with POSIX shell in Operating System - HP-UX

Execute command in AWK and integrate with POSIX shell

yc_2 — Thu, 24 Apr 2003 07:32:58 GMT

Hi,

I want to perform a backup automatically when the log files are full in informix.

Have though of an endless loop as follows:
while true
do
onstat -l | grep "U--" | awk '{if (NR==[number of table] [execute backup]}'.
done

The [execute backup] is a script using ontape command which already available.

Appreciate any advice on how to call the backup script within AWK or a better way to do it.

Thanks in advance,
YC

Re: Execute command in AWK and integrate with POSIX shell

Carlos Fernandez Riera — Thu, 24 Apr 2003 07:59:55 GMT

We need a little sample of data.

The sintax for executing inside awl is system

i.e.
while true
do
onstat -l | grep "U--" | awk '{if (NR==[number of table]) commd="echo " $1 ; system(commd) }'.
sleep 300
done

Re: Execute command in AWK and integrate with POSIX shell

James R. Ferguson — Thu, 24 Apr 2003 09:31:47 GMT

Hi:

Since you appear to be using 'awk' only to count the number of records, you could (simply) do:

...
onstat -l | grep "U--" | [`wc -l` = $N] && echo "ok"
...

Regards!

...JRF...

Re: Execute command in AWK and integrate with POSIX shell

Zafar A. Mohammed_1 — Thu, 24 Apr 2003 12:30:29 GMT

Leong,

I don't know what's the reason caputring the Log file and then issuing ontape command.

If you just issue ontape -a command it will copy all full logical logs automatically.

Thanks
Zafar