script help please

db2girl · #1 (**permalink**) 03-14-11, 23:50

How can I sum up "Total Pages" and "Used Pages" for:

DAT Object Summary
INX Object Summary
LOB Object Summary
LBA Object Summary
XDA Object Summary

in the attached file?

Can I use cut, awk ... to get this info? Please provide some examples.

Thanks

pdreyer · #2 (**permalink**) 03-15-11, 03:38

Code:

awk '/Object Summary: Total/ {tot[$1]+=$6;used[$1]+=$10} 
END {for (n in tot) {printf "%3s %9s %9s\n",n,tot[n],used[n]}}' insp.out.txt

db2girl · #3 (**permalink**) 03-15-11, 19:43

Thx a lot!

Internet Services

Web Development

Digital Marketing

Consumer Tech