How do we use multiple commands with AWK

Shell Programming and Scripting
1

Hi,
I have a scenario where in, I have a file named abc.txt.
I extract the file names from it using.

 
awk '/dbf$/{print $NF}' abc.txt
/u01/oradata/omc/systab/omcdef.dbf
/u01/oradata/omc/oratemp/temptab1.dbf

Now I need to further enhance this command and also extract the mount point details using df -k

Eg. The final out put should be like

 
The mount point details for '/u01/oradata/omc/systab/omcdef.dbf' are:
 
/u01/oradata/omc/systab (/dev/vx/dsk/omcdg/systab_v) : 15080098 total allocated Kb
9728233 free allocated Kb
5351865 used allocated Kb
35 % allocation used
 
 
The mount point details for '/u01/oradata/omc/oratemp/temptab1.dbf' are:
 
/u01/oradata/omc/oratemp (/dev/vx/dsk/omcdg/oratemp_v) : 11305721 total allocated Kb
3429324 free allocated Kb
7876397 used allocated Kb
69 % allocation used

How do I achieve this with AWK?

2

Use Following :

for i in `awk '/dbf$/{print $NF}' abc.txt`
do
Dev=`df -k $i|sed 1d|awk '{print $6}'`
Tot=`df -k $i|sed 1d|awk '{print $2}'`
Free=`df -k $i|sed 1d|awk '{print $4}'`
Used=`df -k $i|sed 1d|awk '{print $3}'`
Per=`df -k $i|sed 1d|awk '{print $5}'`
echo "The mount point details for $i are :"
echo " $i      ( $Dev )       :      $Tot  total allocated kb "
echo " $Free free allocated Kb "
echo "$Used  used allocated Kb"
echo "$Per % allocation used"
done

Hope this helps...

3

Using an array to minimize the calls to awk :

#!/bin/bash
for F in $(awk '/dbf$/{print $NF}' abc.txt)
do
    A=( $(df -k $F | sed 1d) )
    echo "The mount point details for $F are :"
    echo "$F      ( ${A[5]} )       :      ${A[1]}  total allocated kb"
    echo "${A[3]} free allocated Kb"
    echo "${A[2]} used allocated Kb"
    echo "${A[4]}% allocation used"
done
4

Thanks frans,
will check it also...