Tuesday, April 23, 2013

AIX iostat -DlRTV; report only nonzero stat rows

This morning I was preparing a spreadsheet from 10 hours worth of stats collected on an IBM Power AIX system with:

iostat -DlRT 15 2400

That kind of stuff takes me forever.  Don't smirk - you try manipulating the dinky keyboard and diminutive trackpad of a Lenovo laptop with sasquatch hands.  It took me at least ten minutes to sort out the rows with only zeroes in the reported stats (based on bps bytes-per-second=0.0) and delete them.

Something was prodding my memory... wasn't there some cool option I used in the past to only report lines with nonzero stats?  Something other than piping it to awk?

Sure enough!  The -V option.  Much nicer!  Now back to the work of driving the Oracle reads up to 1 mb from single 32kb database blocks, in order to drive down the IOPs count and make qfulls disappear!

[sasquatch@moutainhome] $ iostat -DlRTV 1 1

System configuration: lcpu=64 drives=32 paths=64 vdisks=0

Disks:                     xfers                                read                                write                                  queue                    time
-------------- -------------------------------- ------------------------------------ ------------------------------------ -------------------------------------- ---------
                 %tm    bps   tps  bread  bwrtn   rps    avg    min    max time fail   wps    avg    min    max time fail    avg    min    max   avg   avg  serv
                 act                                    serv   serv   serv outs              serv   serv   serv outs        time   time   time  wqsz  sqsz qfull
hdisk6          54.0   9.7M 185.0   9.7M   0.0  185.0   6.2    0.2   30.2     0    0   0.0   0.0    0.0    0.0     0    0   0.0    0.0    0.6    0.0   0.0   0.0  05:35:27
hdisk3          61.0   4.7M 143.0   4.7M   0.0  143.0   5.9    0.2   29.3     0    0   0.0   0.0    0.0    0.0     0    0   0.0    0.0    0.0    0.0   0.0   0.0  05:35:27
hdisk10         16.0 786.4K  24.0 786.4K   0.0   24.0   8.2    0.3   30.4     0    0   0.0   0.0    0.0    0.0     0    0   0.0    0.0    0.0    0.0   0.0   0.0  05:35:27

No comments:

Post a Comment