Help with iostat


 
Thread Tools Search this Thread
Operating Systems AIX Help with iostat
# 1  
Old 02-05-2013
Help with iostat

Hello, I support Oracle 11g on AIX 7.1.

Using the command
Code:
$iostat -D hdisk2 hdisk4 hdisk5 5

I get the following output:
Code:
hdisk5         xfer:  %tm_act      bps      tps      bread      bwrtn    
                        44.0      1.4M   178.2        1.4M      14.7K
               read:      rps  avgserv  minserv  maxserv   timeouts      fails
                       174.6      3.0      0.2    279.7           0          0
              write:      wps  avgserv  minserv  maxserv   timeouts      fails
                         3.6      0.4      0.2     11.2           0          0
              queue:  avgtime  mintime  maxtime  avgwqsz    avgsqsz     sqfull
                         0.0      0.0     12.1      0.0        0.0         0.0
hdisk2         xfer:  %tm_act      bps      tps      bread      bwrtn    
                        87.4     14.0M   1544.1       12.1M       1.9M
               read:      rps  avgserv  minserv  maxserv   timeouts      fails
                       1441.0      1.7      0.2    316.7           0          0
              write:      wps  avgserv  minserv  maxserv   timeouts      fails
                       103.1      0.4      0.3     57.9           0          0
              queue:  avgtime  mintime  maxtime  avgwqsz    avgsqsz     sqfull
                         0.4      0.0    123.8      0.0        2.0        89.7
hdisk4         xfer:  %tm_act      bps      tps      bread      bwrtn    
                        93.0      2.8M   319.4        2.7M       1.6K
               read:      rps  avgserv  minserv  maxserv   timeouts      fails
                       319.2      3.0      0.2    312.3           0          0
              write:      wps  avgserv  minserv  maxserv   timeouts      fails
                         0.2      0.3      0.3      5.1           0          0
              queue:  avgtime  mintime  maxtime  avgwqsz    avgsqsz     sqfull
                         0.0      0.0     17.9      0.0        0.0         0.0
--------------------------------------------------------------------------------

I find this difficult to parse using awk or any other tool because for each iteration all the titles are printed again rather than repeating the value for the metric like vmstat does. That's a lot easier to capture the value for the metric.

Code:
kthr    memory              page              faults              cpu          
----- ----------- ------------------------ ------------ -----------------------
 r  b   avm   fre  re  pi  po  fr   sr  cy  in   sy  cs us sy id wa    pc    ec
 6 10 8800952 26424   0   0   0 7461 39909   0 4040 39689 12081 52 14 26  8  4.96  67.0
 5  3 8800817 24651   0   0   0 9434 108818   0 2357 8227 7222 47 12 33  8  4.47  60.4
 7  3 8801897 24468   0   0   0 31695 95003   0 3339 6179 8625 51 19 23  8  5.21  70.3

Does anyone have an idea how to parse this output so that it could be output to a CSV file and loaded into a spreadsheet?

Many thanks.
Moderator's Comments:
Mod Comment Please use code tags

Last edited by jim mcnamara; 02-05-2013 at 08:43 PM..
# 2  
Old 02-05-2013
Code:
iostat -D hdisk2 hdisk4 hdisk5 5 | awk ' BEGIN {
printf "dev,%tm_act,bps,tps,bread,bwrtn,"
printf "read: rps,avgserv,minserv,maxserv,timeouts,fails,"
printf "write: wps,avgserv,minserv,maxserv,timeouts,fails,"
printf "queue: avgtime,mintime,maxtime,avgwqsz,avgsqsz,sqfull"
} {
        for(i=1;i<=NF;i++) {
                if($i~/^hdisk/) {
                        printf "\n%s,", $i;
                }
                else if($i~/^[0-9]/) {
                        printf "%s,", $i;
                }
        }
} END {
        printf "\n";
}'

These 2 Users Gave Thanks to Yoda For This Post:
# 3  
Old 02-05-2013
Thanks that's really cool.
# 4  
Old 02-07-2013
You might also want to consider using the "-l" option, which switches to "long output".

I hope this helps.

bakunin
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Solaris

How to use IOSTAT command

Hello everyone, Can you please explain me what kind of information do IOSTAT show ? iostat -xnz 3 show me those informations: The I/O of the c0t0d0 disk is normal ? extended device statistics r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device 0.0 ... (3 Replies)
Discussion started by: adilyos
3 Replies

2. Shell Programming and Scripting

IOSTAT monitoring

Does anyone have an example of IOSTAT -eE in a script??????? Need to see the syntax in a script (4 Replies)
Discussion started by: walnutpony123
4 Replies

3. UNIX for Dummies Questions & Answers

transport errors in iostat

Hi Unix experts, I have a question regarding a disk failure seen in "iostat -Enm" output: # iostat -Enm c1t0d0 Soft Errors: 0 Hard Errors: 7 Transport Errors: 9 Vendor: FUJITSU Product: MAU3073NCSUN72G Revision: 0802 Serial No: 0514F005M0 Size: 73.40GB <73400057856 bytes> Media... (5 Replies)
Discussion started by: dyavuzy1
5 Replies

4. Solaris

iostat -En errors

I all, I would like to know what are the causes of : -soft error -harderror -transport error and how to avoid and repare them. I got the iostat out put below: atng-mm01% iostat -En | grep -i hard c0t0d0 Soft Errors: 1 Hard Errors: 0 Transport Errors: 0 c0t0d1 ... (3 Replies)
Discussion started by: zaza
3 Replies

5. Red Hat

iostat on Redhat 5

A find for the "iostat" command on a redhat 5 update 4 comes back with no results. Any separate rpm needs to be installed to get the binary for this ? Thanks in advance. (1 Reply)
Discussion started by: uxadmin007
1 Replies

6. Shell Programming and Scripting

iostat on solaris

Friends. I have to compare iostat -x output with a tool on solaris. Now there is column called wait in the output field which is showing zero. Now, in order to create some load on my system this is what i am doing I am creating a file using dd command , the size of which is... (5 Replies)
Discussion started by: achak01
5 Replies

7. Solaris

iostat -Eni

Sorry for asking basics. What exactly is the situation if device ID is same in iostat -Eni. What we must do then? Is there any relation b/w iostat and cfgadm? (3 Replies)
Discussion started by: mayahari
3 Replies

8. AIX

how to identified this iostat value

Hi All AIX expert i'm using AIX 5.2 When i execute this command which is : ---------------------------------------------------------------------- >> iostat -a System configuration: lcpu=4 disk=30 tty: tin tout avg-cpu: % user % sys % idle % iowait ... (2 Replies)
Discussion started by: adzuanamir
2 Replies

9. Filesystems, Disks and Memory

Help with iostat ...

All, I am attempting to help tune a Sun for better performance (mainly for SAS 9.1), and have found indicators pointing to poor I/O utilization. I have run iostat -cx, and found one device in particular where the %w is in the 90's during processing. I have a feeling that this is where the SAS... (3 Replies)
Discussion started by: dj_is
3 Replies

10. UNIX for Advanced & Expert Users

iostat output what is that mean

Hi all, i have run iostat -em, and get below result. Can i know what is this output meaning, and how to fix that problem. iostat -em ---- errors --- device s/w h/w trn tot sd7 0 1 0 1 sd8 1 1 0 2 sd9 0 1 0 1 sd10 0 ... (2 Replies)
Discussion started by: foongkt5220
2 Replies
Login or Register to Ask a Question