Skip to main content
 
developerworks > Community >  Dashboard > Systems > Other Performance Tools > nmonanalyser
developerWorks
Log In   View a printable version of the current page.
Overview New to Forums Wikis
nmonanalyser
Browse space Browse Space    
Added by nagger, last edited by atkinss on May 05, 2011  (view change) show comment
Labels: 
(None)

nmon Analyser

This is an Excel spreadsheet that takes an output file from Nigel's Monitor (nmon)and produces some nice graphs to aid in analysis and report writing. It also performs some additional analyses for ESS, EMC and FAStT subsystems. It requires Excel 2002 or later.

Please note:

  • The Analyser is not officially supported by IBM and no warrantee is given or implied. Use it at your own risk.
  • No support is offered by IBM. Please post any questions you have to the forum (see link below)
  • nmon analyser is the personal project of the author - Stephen Atkins.

Version 3.3

  • Support for new features in NMON12 for POWER6 and AIX V6.1
  • Improved support for topasout and Linux 
  • Dynamic invokation of Windows SORT command for large files
  • Automatic support for locales that use comma as a decimal separator 
  • New facility to allow merging of NMON files for trend analysis
  • Automated creation of user-defined PivotChart
  • Removal of SVCTimes option (replaced by new sheet from NMON12)
  • Removal of DISKSORT option - to see if anyone complains and in preparation for Analyser V4!
  • Changed REPROC option to work in all multi-file situations
  • New summary workbook for multi-file mode

NOTE:  V3.3 is designed for use with NMON12 and topas/nmon but will work with most older versions.   In case of problems analysing older files, try using V3.2.7 (link below)

V3.3.g fixes a problem on the PAGE tab when Active Memory Expansion is used.

Instructions for use

  • Make sure you have the latest version of NMON
  • Use NMON to capture data to a file (using one of the -f, -x, or -X options). This will create a file in the current directory with a name made up from
    the hostname, the date, the time and with a filetype of nmon. This is a comma-delimited text file with the data in snapshot order.
    I recommend that you keep the number of snapshots to around 300 in order to avoid problems with over-large files. The graphs will also look better.
  • If the file contains more than 65K lines you will need to sort it using the "sort -A" command:
    e.g. sort -A filename.nmon > filename.csv
  • FTP the file to your PC (ideally using the ASCI or TEXT options)
  • Now open the nmon_analyser spreadsheet, click on the "Analyse nmon data" button and select the .nmon file

Known problems

  • The PIVOT option does not work with Excel 2007/2010 (any help with fixing this will be much appreciated!) 
  • The MERGE feature will fail if the files have been sorted.
  • If you use the NOLIST=DELETE option you must have LIST=SYS_SUMM,DISK_SUMM,CPU_SUMM as a minimum.
  • The WINDOWS sort command will fail if the filename or the directory name contains blanks or special characters.
  • FIRST/LAST interval processing does not work correctly for files that do not have T0001 as the first interval or which have timestamps > 5 characters in length

Requested functions

  • Fix the problem with FIRST/LAST interval processing for files that do not start with T0001
  • Allow FIRST/LAST to be specified as time values rather than interval numbers
  • Produce disk response times analyses
  • Reduce the memory footprint to allow processing of larger files
  • Remove more section dependencies
  • Allow for customised graphs

Links

Description Link
Download nmon Analyser V3.3 nmon_analyser.zip version 3.3.f (200KB Zip file, 10 Jan 2011)
Download nmon Analyser V3.2 nmon_analyser_v327.zip (163KB Zip file, 20 Feb 2008)
Online Forum for questions and FAQ http://www-03.ibm.com/systems/power/community/forums.html take the Performance Tools link
Find nmon for AIX and Linux at http://www.ibm.com/developerworks/wikis/display/WikiPtype/nmon
nmon Analyser Article
at developerWorks 		http://www.ibm.com/developerworks/aix/library/au-nmon_analyser/index.html
Find nmon Consolidator at http://www.ibm.com/developerworks/wikis/display/WikiPtype/nmonconsolidator

Comments  (Hide)

Great! Can you make it work with OpenOffice.org please? The macro's have issues at the moment.

Posted by fanatik at Apr 02, 2009 06:57 | Permalink

I'm trying nmon_analyzer with OpenOffice and I cannot even open the nmon -f output file...
It would be useful to be able to use OO as well as EXCEL!

Posted by trux at Sep 15, 2009 05:18 | Permalink

We have looked at OpenOffice but it is very slow.

If you can re-implement the features in Open Office we will have it hosted on the nmon wiki pages.

Posted by Nicolette at Sep 21, 2009 13:16 | Permalink

Has anyone noticed that the merge function of the 3.3.e version of the nmon Analyser puts the data points out of order? I tried the merge files from 4/9-4/12 and the graphs have datapoints from 4/10 and 4/11 at the end of them!? Numerous tests have yielded the same problem...

Posted by JakeAtOffutt at Apr 12, 2010 09:35 | Permalink

When I run nmon anaylizer (V3.3) under excel 2010, I get the following pop-up message:
"Object library invalid or contains references to object definitions that could not be found"
Can nmon analyzer run under excel 2010? If so, what steps do I need to take?
Thanks.

Posted by SonnyLuke at Sep 02, 2010 14:36 | Permalink

It is Excel problem as far as I know, something related to Addins. You have to delete all .exd files and restart excel before loading the nmon. Happen to me once, and this solution worked for me..

Posted by RoySebastianus at Nov 03, 2010 09:44 | Permalink

In the instructions for use(Nmon Analyzer), It says "If the file contains more than 65K lines you will need to sort it using the "sort -A" command:
e.g. sort -A filename.nmon > filename.csv"

but I cannot really find sort -A option in UNIX. Can some one please help me understand what it does?

Thanks,
Raj

Posted by OracleAppsDBA at Nov 10, 2010 12:22 | Permalink