15 likes Updated 4/9/18, 10:32 AM by naggerTags:

nmon Analyser

small graph

This is an Excel spreadsheet that takes an output file from topas/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 works with Excel 2003, 2007 or 2010 and supports 32-bit and 64-bit Windows. It does not run on Linux or the Apple Mac and the macros will not work with OpenOffice.

UPDATE: Latest version is 52.1  Download: nmon_analyser_v52_1.zip

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 was the personal project of the original developer - Stephen Atkins.
  • More recent improvements and from version 4 onwards are by Ron McCargar.
  • Warning: for large nmon data files (10+ MB), It is high recommended that you should install 64-bit Microsoft Excel 2013 or 2016 and have a minimum of 8GB of memory in your PC or preferably more.  This removes many failures to analyse large data files.

New in Version 5 - Thanks to Ron McCargar (IBM)

  • New Update 52.1
    • Bug fixes
    • 22nd July 2017
  • New update 51.2
    • Bug fixes plus support improvements for Apple Mac running the latest Excel
    • 4th November 2016
  • New update 50.5
    • Bug fixes
    • 5th May 2016
  • New update 5.0.2
    • Added support to run nmon Analyser on a Mac with Excel 2011 or higher.  Please note the following limitations: 
      • Pivot charts don't work,
      • Merge option doesn't work.
    • Fixed a problem when trying to import very large .nmon files it may fail.
    • On the AAA sheet renamed the "elapsed" value given to "Analysis time" (the elapsed time it took Excel to analyze the nmon file)
    • Enabling PIVOT charts would crash the analyzer on Excel 2010 and higher and has been fixed.   (Analyser - PIVOT = YES)
    • On the Analyser's Settings - DELIM value the user can now specify any value desired.
    • In ProcessFile() added a check for EOF before doing the import to possibly avoid an error.
    • Graphs that show Avg/Wavg/Max will now show Avg/Wavg on the Y1 axis and Min/Max as lines on the Y2 axis.  Also if the Analyzer Output option SyncAxis is YES then the Y1 and Y2
    • Several graphs were not sorted previously based on the Analyser's Settings - SORTDEFAULT value but are now.
    • Added On Error Resume Next in a few spots in order to be better able to analyze huge data sets without failing prematurely.

New in Version 4 - Thanks to Ron McCargar (IBM)

  • New update 4.7
    • Added a check for Power 8 and SMT mode 8.  In previous versions no check exists which defaults the number of CPUs shown to 2 on the CPU_SUMM sheet.
  • New update 4.6
    • Bug fixs for CPU_SUMM, INTERVAL, SORTDEFAULT, SYS_SUMM and nmon error data.
  • New update 4.5
    • Revert back to original CPU% calculations
    • Includes nmon for Linux CPU Steal time handling. Steal = Time waiting for other Virtual Machines to give you back "your" CPUs.
  • New update 4.2 includes bug fixes as V4 gets lots of further testing from users.
    • The elapsed time value produced on AAA was corrected (it did not include the time to open the file(s) and sort the data).
    • Added a new option on the Analyser sheet called BIGDATA.  Use this if you have large lines (up to 32K) or > 1048576 rows.
    • The analyser would fail on Excel 2007 if > 1048576 rows were encountered.  Use BIGDATA=YES.
    • The maximum allowed rows per .nmon file is now unlimited (based on available Excel/PC memory)
    • The SORTINP setting has been removed.  Data is now always sorted.
    • On the SYS_SUMM sheet the CPU% values were wrong and have been changed to the sum of users% + Sys% for each line.
    • On the SYS_SUMM sheet added the following additional fields from the LPAR tab (it it exists):  Virtual CPUs, Other LPARs, Pool CPUs, Entitled, Weight
    • On the LPAR tab the 1st and 3rd graphs showed incorrect values.
    • Updated nmon analyser to check for either hdiskpower, emcpower or just power when determining if EMC data is present.
    • Analysis supports any number of columns up to the Excel maximum of 16684.  On large data sets (> 10 MB) you most likely will require 64-bit Windows however and a minimum of 8 GB of RAM.

Note: Some tabs such as DISK* still use a max of 255 columns per sheet.

  • NPIV header was incorrectly shown at the bottom of the sheet previously.
  • NPIV and SEAnmon_analyser_v5_0_2.zipLICTRAFFIC sheets will no longer show any graphs (due to potential huge size.)

Version 3.5 for Excel 2007 and later

  • Improved support for Excel 2007, 2010 and 2014 in .xlsm format - thanks to Ron McCargar (IBMer).
  • Minor change needed for this support only.
  • I (Nigel Griffiths) have tried this on my Excel 2007 and it is fine. Sorry I don't have later Excel version available - please comment below if it works for you.
  • Microsoft says Office 2003 support is ended but can use newer formats, see; Microsoft Support Article
  • Version 3.5b 11 Feb 2015
    • 1. Fixed a bug if using the GRAPHS LIST - PICTURES option, the script would fail if LIST did not contain ZZZZ and NOLIST = DELETE.

      2. When using Excel 2013 with the GRAPHS - PICTURES option added error handling in OutputPics function to avoid a possible failure when determining the last row in the Charts sheet

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 filet ype 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.
  • FTP the file to your PC as an binary file (fpt "bin" option)
  • Now open the nmon_analyser spreadsheet, click on the "Analyse nmon data" button and select the .nmon file

Known problems

  • The WINDOWS sort command will fail if the filename or the directory name contains blanks or special characters.


Description Link

Download Current Version

nmon Analyser V52.1

nmon_analyser_v52_1.zip   22nd July 2017

Bug fixes

nmon Analyser V51.2 nmon_analyser_v51_2.zip    4th November 2016

Bug fixes + Improved Apple Mac and latest Excel support

nmon Analyser V50.5 nmon_analyser_v50_5.zip     6th May 2016

Bug fixes

nmon Analyser V5.0.2

 nmon_analyser_v5_0_2.zip  11 March 2016

Zip file including the 5.0 documentation

Online Forum for questions and FAQ http://www.ibm.com/developerworks/forums/forum.jspa?forumID=749&cat=72 - This is the AIX Performance Tools Forum
Find nmon for AIX and Linux at https://www.ibm.com/developerworks/mydeveloperworks/wikis/home?lang=en#/wiki/Power%20Systems/page/nmon
nmon Analyser Article

at DeveloperWorks
Find nmon Consolidator at https://www.ibm.com/developerworks/mydeveloperworks/wikis/home?lang=en#/wiki/Power%20Systems/page/nmon_consolidator