
!
NMON_Analyser User Guide for V5.2.1
Preface
"#$$%N"&Mon'"
"($#)$*#"+(,#(#
"+-+.$(/"$(
011203415)$6//7/+(#)/+
++#-.($
48/ 6/"09#+/7/+09#:6
$/709#/++;#(99(
+ <<$#(#$<7)<!=:=>/?/"
4# 6"09#(#6+/7/+,#+
09#)+)#
Please note:6(/+##,"$(%@A'$+
"+$2++=)#(09#
6"=)09###/7($$/(B
+,CAD()$
/"/)"((+%"E7)$#$'/%#6FG
5!6F5'(/"/)1+
7/+#)($$#"D(1#+$H7
4+"2)+(6A3$I$)D#3"
%$##"E)$#$'
1(,)(()J#;+
4$%)/'++##++#
7
+$"
+ <<///)$#$<,/7<#$$</7<+$>"?KL</7<J/M1$<"<
$
4$
+ <<///)$#$<,/7<#$$<($<+$<($>?
:=!N?G
New in V5.2.1
Tested on Excel 2016: Please note you may experience the following issue “texttocolumns
method of range class failed” a possible work around:
“I installed Excel 2016 on my mac. I open excel , enable macros run the latest analyzer. It fails with
“texttocolumns method of range class failed”. Then i see in the background that the Sheet2 has no data
J"(

!
in column A, i.e. data didn't get copied into Excel from the .nmon file. I put in a 1 into first cell of column
A (could add any data really to avoid the error) and hit the button to continue. Then it fails like it should
saying "no valid nmon data".
I shut down Excel and I came back in again later rerun the analyzer and I did not get the problem it
seemed like a 1 time thing, it ran through it successfully. Tested it a few more times, it doesn’t happen
anymore. Uncertain what caused this to fail the 1
st
time but FYI“
New in V5.2
Add Merge support when running on a Mac.
New in V5.12
Fixed problems if running on Mac Excel 2016
New in V5.1
If Merge = Yes then the 1st file's data would appear twice incorrectly.
The Avg and Max CPU% on the SYS_SUMM column was being calculated incorrectly.
The default save format used on a Mac may not have been set correctly in some cases.
If importing multiple .nmon files that contain multiple "AAA,x86," records popup errors would be
shown to the user.
New in V5.0.2
Added support to run nmon Analyzer 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.
++$+OO,",O$O%+$709#
I+$('
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.
Added new options SHOWMACPROGRESS and SHOWLINUXCPUUTIL
New in V4.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 in V4.6
If an INTERVAL range was specified the CPU_SUMM sheet would contain no data.
If the SORTDEFAULT setting was set to YES then sheets like NETPACKET would incorrectly
display a SortKey value on the graph.
If the LPAR sheet didn't exist, then SYS_SUMM graph would not display CPU% as expected.
On the SYS_SUMM sheet if the LPAR sheet exists, the CPU% column will be now what it was
back with analyzer version 3.4a or Avg CPU% "=M4/LPAR!C2*100." and Max CPU% =
"=M4/LPAR!C2*100.".
J"(

!
If the nmon data contained ERROR tags, the resulting ERROR sheet would incorrectly list
thousands of columns at the end containing 'N/A'
New in V4.3
Added a new setting called SORTDEFAULT. This setting indicates if the 1st graph on 'default'
sheets (ones not handled else where by the Analyzer) are sorted. Note: If Yes, this will also
reorder the columns.
Added support for the CPU_ALL, CPUnnn Steal% column that is being added to nmon for Linux.
New in V4.2
+JD++"++(J,/##$,
1(#+#7"(03<J/J+7/)75+03"+
,)"
5+03#+#7)$#+7"++/","28,"29)
/+++"+,"@8,"(
+/+,+,"28,"29"+/+++"+
,"@8,"(%43P2#'
New in V4.0
5+$,#/##,6#
+$+(%'+
/++#A6H5+(+,"
%Q'R=CG:/
5+I/(09#:(R=CG://#
A6H5?B01
5+$9$$//$(/$%),)
09#<J3$$'
5+1D56J"+)$,H//
+1B11++3JM,//"+,)#+"+
$(M@1M(#+
+1B11++(/"(($+JD)%
9' 3J2+JD2J3J2028"+
+JD)+"++/##,
$I#+#7(++7/2$#/S//+
$"(03
$)(#$+09#$9$$(C="
%RA'$7/;=)8/+/,
$$$(CA(D
J6+/##+/+)$(++,
J610635D4463+/"+/"+%
+"I'
New in V3.5
13550D#<9#5J3JM)J6H"+,#+
/+09#
New in V3.4
J"(

!
6$,(09#:
1(=)8/
)#($,(,$)
8#615
$+,$)(3J2J3J13J+"
"+(+J3J13J+
3#+"(+H61QDF40D+
49)"/++0D0
$##3J12H61Q11B11615
J"=(

!
5)(3
(G
J(#
/G
/G
/G
/G
/G
/=:
#+#7(J/C15$C6,,#+#79/+#+(+$)(
3J+/+3J1+
/=
/=
/=
/=
/G
/=
3#""C
3#""%9$/$'!
"!
A#+J#"
4$"
J,3+
J"
8)J)+"
6"+#
+-8"+,".+
1B11=
=
AAAAG
AAA3G
AAAH
AAA0
AAA
AAA
AAA
AAAJ
AAAD
AAA
3J
3J:
3J1:
(H61Q2011203241H+:
03<J/J+)$C
415)$C
HA1BC
HD0HC
H16T0C
H8D650C
HF40DC
H61QA16T0!
H61QA1B!
H61QD0H!
J"G(