Power

 View Only
  • 1.  nmon for AIX

    Posted Tue July 25, 2023 10:06 AM

    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
    ------------------------------


  • 2.  RE: nmon for AIX

    Posted Wed July 26, 2023 01:23 PM

    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
    ------------------------------



  • 3.  RE: nmon for AIX

    Posted Thu July 27, 2023 02:48 PM
    I am trying to run nmon consolidator I can't figure out how to get it past security.

    I have Norton on my home computer and it removed the scripts that make it work. I "restore" it in Norton but it the button to select files a "picture".

    When I try to run it on my work computer Office 365 blocks the macro and there is no override.

    Anyone have any ideas?

    Where is Stephen when you need him? :--(

    Thanks

    Christopher




  • 4.  RE: nmon for AIX

    Posted Fri July 28, 2023 05:21 AM

    Hi,

    Remove Norton from your computer.

    Stopping using Microsoft tools.

    Upgrade to njmon sending the data to InfluxDB and graphing with Grafana.

    Cheers, Nigel @mr_nmon Griffiths



    ------------------------------
    Nigel Griffiths
    ------------------------------



  • 5.  RE: nmon for AIX

    Posted Mon July 31, 2023 10:44 AM

    Did you try to open the properties of the xlsm in file explorer and select "unblock" then you should be able to run the macro. "Great new feature in MS Office (8-(("



    ------------------------------
    Ralf Schmidt-Dannert
    ------------------------------