AIX

AIX

Connect with fellow AIX users and experts to gain knowledge, share insights, and solve problems.

 View Only
Back to discussions
Expand all | Collapse all

unable to open nmon file using nmon analyzer

  • 1.  unable to open nmon file using nmon analyzer

    Posted Fri September 25, 2009 12:50 AM

    Originally posted by: manu12


    Hi,

    I have latest nmon analyzer v33c and nmon 12e , using excel 2007 I am unable to open .nmon file and getting error "subscript out of range" while opening the file

    Please suggest.

    Best Regards,

    Manoj


  • 2.  Re: unable to open nmon file using nmon analyzer

    Posted Fri September 25, 2009 03:27 AM

    Originally posted by: SystemAdmin


    I think the amount of data you have collected is more than the number of rows in excel (which is 65536 in excel 2003...in 2007 think its 1 million). Do nmon collection once again and this time break it down into smaller files instead of one single large file.

    r/
    R


  • 3.  Re: unable to open nmon file using nmon analyzer

    Posted Tue July 12, 2011 07:00 AM

    Originally posted by: tucero


    Hello,

    I have the following error when i run nmon analyzer
    "the file contains more than 65K lines"
    In the page of nmon analyzer it has a solution for this problem that is the following:
    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

    However i run this command to sort the file but the tool does not seem to run correctly since it produces many excelsheets instead of one.

    Is there any other way to sort it?

    Thank you