[Orca-users] Re: Mimicking ORCA data gathering on IBM AIX

[Blair Zajac]

This definitely can't be loaded directly into Orca presently.  It may be
easy to create a Perl script as you suggested to transform this data into
a format that Orca understands, but probably the easiest way is to edit
the source code to aixmonitor to output data in a form that Orca understands.

Here's a sample measurement of what Orca understands.  The two paragraphs
are actually just two lines in the output file but word wrapped here for ease
of reading:

timestamp locltime DNnsrkcmdit uptime usr% sys% wio% idle% 1runq 5runq
15runq #proc #runque #waiting #swpque scanrate smtx smtx/cpu ncpus
mntC_/ mntU_/ mntA_/ mntP_/ mntc_/ mntu_/ mnta_/ mntp_/ mntC_/home
mntU_/home mntA_/home mntP_/home mntc_/home mntu_/home mnta_/home
mntp_/home disk_runp_c0t6d0 disk_runp_c0t0d0 disk_runp_c0t1d0
disk_peak disk_mean disk_rd/s disk_wr/s disk_rK/s disk_wK/s swap_avail
page_rstim freememK free_pages hme0Ipkt/s hme0Opkt/s hme0InKB/s
hme0OuKB/s hme0IErr/s hme0OErr/s hme0Coll% hme0NoCP/s hme0Defr/s
tcp_Iseg/s tcp_Oseg/s tcp_InKB/s tcp_OuKB/s tcp_Ret% tcp_Dup%
tcp_Icn/s tcp_Ocn/s tcp_estb tcp_Rst/s tcp_Atf/s tcp_Ldrp/s tcp_LdQ0/s
tcp_HOdp/s nfs_call/s nfs_timo/s nfs_badx/s nfss_calls nfss_bad
v2reads v2writes v3reads v3writes dnlc_ref/s dnlc_hit% inod_ref/s
inod_hit% inod_stl/s pp_kernel pagesfree pageslock pagesio pagestotl

1002317740 16:35:40 wwwwwwwwwww 450616 0.1 0.1 0.0 99.8 0.46 0.18 0.11
65 0.00 0.00 0.00 0.000 0 0 2 7669178 2217609 5374878 29.208 922624
103183 819441 11.184 493688 26771 417549 6.025 256576 551 256025 0.215
0.00000 0.44642 0.00000 0.446 0.149 0.0 0.4 0.0 2.8 845032 600 342384
42798 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
0.000 0.000 0.000 0.000 0.000 0.000 0.000 0 0.000 0.000 0.000 0.000
0.000 0.000 0.000 0.000 0 0 0 0 0 0 4.800 100.000 0.000 100.000 0.000
6158 42798 6476 0 62555

The first line gives names to the columns that appear in the following lines.

If you can get this, then it would be pretty straight forward to load into
Orca.

I would also look at

	http://www.orcaware.com/orca/docs/orcallator.html

to give the column names to the data that aixmonitors that is closest to
Solaris so that orcallator.cfg can be minimally modified.

Best,
Blair

> Erik Melander wrote:
> 
> Attached is the output from a uniprocessor box (log.out) and an
> multi-processor box (log-smp.out).  The comments
> at the top of each file explains what each field means.  The data attached is
> one full interval.  If more information is
> required, please don't hesitate to ask!
> 
> Thanks.
> 
>  -----Original Message-----
> From: Blair Zajac [mailto:blair at orcaware.com]
> Sent: Friday, October 05, 2001 3:53 PM
> To: orca-discuss at yahoogroups.com
> Subject: Re: [orca-discuss] Re: Mimicking ORCA data gathering on IBM AIX
> 
>      This is great stuff.  Orca running on AIX would be great.
> 
>      What is the format of aixmonitor's flat files?  It may be easier
>      just to
>      modify them slightly into a format that Orca understands instead of
>      introducing another process, in this case Perl, to manipulate the
>      output
>      files.
> 
>      Can you send the first several lines of output?
> 
>      Best,
>      Blair
> 
>      EMelander at wyndham.com wrote:
>      >
>      > If you are looking for an excellent utility like top to extract
>      > statistics from the AIX kernel, then you may consider 'monitor' (a
>      > derivative of top?).  Not only can the application run in daemon
>      mode
>      > and output to a flat text file, but it can also log to an rrd
>      > database file.  I am very new to writing a script to transform
>      this
>      > data into a form useable by orca, but it looks very promising.
>      >
>      > For more information visit: http://aixmonitor.sourceforge.net/
>      >
>      > To find a copy you can download it from:
>      > http://prdownloads.sourceforge.net/aixmonitor/monitor-3.1.tar.Z
>      >
>      > or if you prefer the installp image from:
>      >
>      http://prdownloads.sourceforge.net/aixmonitor/freeware.monitor.bff.Z
>      >
>      > In the interim I will be working on a perl script to properly
>      format
>      > this data, however the more experienced here may have more
>      success.
>      > Hopefully this will generate some traffic ...
> 
>                          Name: log-smp.out
>    log-smp.out           Type: unspecified type (application/octet-stream)
>                      Encoding: quoted-printable
>               Download Status: Not downloaded with message
> 
>                      Name: log.out
>    log.out           Type: unspecified type (application/octet-stream)
>                  Encoding: quoted-printable
>           Download Status: Not downloaded with message