1) Read the Microsoft Word document that comes with the nmon Analyser package. It includes some hints and tips for Excel Problems and Internationalization issues like character sets.
2) Use the latest nmon Analyser and latest Excel and then try again.
3) Note: There is no longer support now for the nmon Analyser - or at least no longer a volunteer from within IBM.
4) Does all your other nmon files have the same problem? If not, it strongly suggests that you have a duff nmon file.
5) Try using nmonchart instead. But note - if you have a duff nmon file then that too can fail.
- Duff will mean missing data like some columns or all lines of stats of a particular type or corruption so you have some mangled line formats.
Best of luck, Nigel @mr_nmon Griffiths
I am never going to debug the nmon Analyser (zero Excel debugging skill and indeed no interest in doing that)
but if you think your nmon file is good then you could email the nmon file to nigelargriffiths@hotmail.com
------------------------------
Nigel Griffiths
------------------------------
Original Message:
Sent: Tue July 25, 2023 10:06 AM
From: Kenny Ng
Subject: nmon for AIX
Microsoft Visual Basic
Getting run-time error 5:
Invalid procedure call or argument
When I ran the debug I got highlight against PP_DISKXFER
Mid(aa0, 6) = "total"
Thanks
Kenny
------------------------------
Kenny Ng
------------------------------