Shell Programming and Scripting

Friends, I have a awk script which will calculate values for columns which is working fine in linux but failing in solaris.
here is my awk script

iostat -dt $INTERVAL $ITERATION | awk 'NR>4' | egrep -v "Linux|Device|Time|AM|PM|sda[0-9]" | awk '{if(/^$/){printf("%f \n"
,sum); sum=0}else{sum+=$2}}
but a similar thing is failing on solaris

here is the script on solaris

sar -d 2 2 | sed -n '/Average/!p;/Average/q;' | egrep -v "nfs[0-9]|device"|awk 'NR > 2 { if ($1 !~ /,.+/) print }'|

awk ' {if(/^$/){printf("%f \n"
,sum); sum=0}else{sum+=$2}} '
.

Can any one pls clarify why its failing in solaris and whats the remedy

Hi.

You should use /usr/xpg4/bin/awk in Solaris.

Give that a try.

And also, we are happy to help anybody but you you doesn't seem to accept our suggestions to improve your code. We have already suggested two times here and here that the way you construct your command is inefficient. Too much pipes.

I have the feeling that you are just looking for a solution. Not to improve your skills. We have a french saying that goes approximately like this:
"I you give a fish to a starving man, he will eat one day. If you learn him to fish, he will eat every day".

Can u pls suggest how i can improve the code here. i wld love to incorporate this ideas to my code as i am still just learning the abc of awk.

All you want to do can be done in one awk command. No need for cut, sed or grep as awk can do all that.

awk work on the <condition> {action} paradigm, so all your negative egrep can be given in the <condition> part. Also, if you want to skip a number of lines, just add a condition like NR>3, NR being the number of the line being processed. Have a look at your two other posts and try it yourself.

man awk is also the way to go to start with.

Your question has already been answered in your previous posts here and here. You just need to adjust the code a little bit.

This is what i have trimmed down to

Code:

 sar -d 3 3 | awk 'NR>4 { if ($0 !~ /:/ && $1 !~ /,.+/) print}' | sed -n '/Average/!p;/Average/q;' | grep -v "nfs[0-9]"

. Now i need to compute the sum of the 2nd column like for fisrt iteration print the sun , then again print the sum for the 2nd iteration. pls guide me from here.

To keep the forums high quality for all users, please take the time to format your posts correctly.

First of all, use Code Tags when you post any code or data samples so others can easily read your code. You can easily do this by highlighting your code and then clicking on the # in the editing menu. (You can also type code tags [code] and [/code] by hand.)

Second, avoid adding color or different fonts and font size to your posts. Selective use of color to highlight a single word or phrase can be useful at times, but using color, in general, makes the forums harder to read, especially bright colors like red.

Third, be careful when you cut-and-paste, edit any odd characters and make sure all links are working property.

Thank You.

The UNIX and Linux Forums

---------- Post updated at 10:24 AM ---------- Previous update was at 10:22 AM ----------

I'd strongly recommend reconsidering the 'trimmed down' version in favor of the previously mentioned alternate solutions - you seem to be missing the point and insisting on the 'sub-optimal' solution(s).
The purely awk-based solution(s) lends itself very easily to calculating of sum - you should be able to start with that and 'guide' yourself to the complete solution.
Good luck.