mjhjmtu

I'm trying to get the fs that have high space consumed. I'm trying to do this using df command with -g flag (gigabyte view) and I can't obtain my expected value.

df -g | sed 's/%//g'| awk '+$5>=75 print' | head -10

With this command below I got an error:

df -g | sed 's/%//g'| awk 'print $5>=75' | head -4

Error Message:

Syntax Error The source line is 1.
The error context is
 {print >>> $5>= <<<
awk: 0602-502 The statement cannot be correctly parsed. The source line is 1.

Here is the output of df -g command on AIX:

/tmp>df -g | sed 's/%//g'| awk '$5 >= 75 print ' | head -4
Filesystem GB blocks Free Used Iused Iused Mounted on
/dev/hd4 10.50 10.05 5 16492 1 /
/dev/hd2 25.50 18.15 29 64361 2 /usr
/dev/hd9var 2.50 0.72 72 4521 3 /var

Complete view:

Filesystem GB blocks Free %Used Iused %Iused Mounted on
/dev/hd4 10.50 10.05 5% 16492 1% /
/dev/hd2 25.50 18.15 29% 64357 2% /usr
/dev/hd9var 2.50 1.39 45% 4512 2% /var
/dev/hd3 21.50 20.24 6% 1495 1% /tmp

I tried on AIX 7.1 PowerPC_POWER8. I don't know what I'm doing wrong!

Concentrating on the awk code:

awk 'print $5>=75'

This should probably be

awk '$5 >= 75 print '

which will output the current input record if its fifth field is numerically greater than or equal to 75.

Judging from the output that you get, you probably want to check $4 rather than $5 though since I presume it's the fourth field that contains the percentage:

df -g | tr -d '%' | awk '$4 >= 75 print ' | head -4

Looking at the error message:
Using awk on OpenBSD (which seems to complain in exactly the same way as your AIX awk), the original code has a syntax error in that it's not possible to print $5 >= 75 (unless put inside parentheses in which case it will evaluate to 0 (false) or 1 (true)). mawk behaves the same.

GNU awk accepts the syntax in the original code, but it's obviously still not what you want.

Instead of using tr and awk twice, just use awk once:

df -g | awk ' sub("%", "", $4); if ($4 >= 75) print $4, $7 ' | sort -n

This replaces the percent signs in field 4 with the empty string (stripping them off); if the remaining value is at least 75, print fields 4 and 7, then pipe them to sort.

An improvement, based on remembering one of Stéphane's answers:

df -g | awk '$4+0 >= 75 print $4, $7 ' | sort -n

The "+0" addition forces a numerical comparison instead of a strictly string-based comparison.

If you want to keep the header, change the criteria to:

df -g | awk 'NR < 2 || $4+0 >= 75 print $4, $7 ' | sort -n

This is the error ... 'Filesystem GB blocks Free Used Iused Iused Mounted on'

The solution is:

# df -g | grep Filesystem | sed 's/%//g'| awk 'print $5>=75' | head -4