Pruebas

NMON_Consolidator User Guide (V1.6)

Preface

NMON_Consolidator is written and maintained by Stephen Atkins of IBM Systems and Technology Group as a personal project. Support for NMON_Consolidator is provided on a best efforts basis. Please read this user guide before reporting a problem. Excel 2002 Edition (or later) is required.

Several people have requested on Open Office versionof this tool. There are significant problems with doing this because of the relatively limited support for dynamic charts in OO. Any skilled OO developers who want to tackle this problem with me are welcome.

Links:
NMON home page
http://www.ibm.com/developerworks/wikis/display/WikiPtype/nmon
NMON_Consolidator home pagehttp://www.ibm.com/developerworks/wikis/display/WikiPtype/nmonconsolidator
User Forum
http://www.ibm.com/developerworks/forums/dw_forum.jsp?forum=749&cat=56

Features in V1.6

• Support for interval averaging for files containing more than 250 intervals
• New option to create a summary file which can later be used for trend analysis
• Removes the requirement for files to have CRLF line endings
• New option to report only System +Process memory for AIX LPARs
• Adds support for Active Memory Sharing (when available in topas/nmon)
• Table of Contents


Preface 1


FEATURES IN V1.6 1


TABLE OF CONTENTS 2


INTRODUCTION 4


INSTALLATION 4


DATA COLLECTION 4

COLLECTING DATA USING NMON 5
Preparing the files for analysis 5

Parameters 5

IN THE CONSOLIDATOR FILE 6
IN THE SHEETSFILE 6
DYNAMIC SETTINGS 7
Static Settings 7

Running the tool 7


THE OUTPUT 8

THE CONTROL SHEET 8
GROUP DEFINITION 8
Node definition 9
The ToD_Graphs sheet 10
THE WAVG_GRAPHS SHEET 10
NOTES ON THE “WEIGHTED AVERAGE” AS USED IN THE CONSOLIDATOR 10
The Node_Graphs sheet 11
THE GROUP_TOTALS SHEET 11
THE GROUP_AVERAGES SHEET 11
THE TREND_GRAPHS SHEET11
THE TOTAL_SAVINGS SHEET 11
THE GROUP_SAVINGS SHEET 12
OTHER SHEETS 12
CPU 12
KB_read, KB_wrtn and KBps 12
tps 13
Net_KBps 13
Net_pkts 13
Mem_MB 13
Paging 13
RIOC 13
Files 13

Customising the “Sheets” file 14

THE CONTROL SHEET 14
CUSTOMISING GRAPHS 15

ERROR MESSAGES 15

HOW TO REPORT A PROBLEM 16

APPENDIX: NOTES ON BATCHOPERATION 17

SAMPLE .BAT FILES 17
GETCSV.BAT 17
consolidator.bat 17
putxls.bat 17
Control.txt 17
NMON Consolidator Batch.xls 17

Introduction

NMON_Consolidator reads in up to 255 nmon or topasout files to produce a consolidated set of data in the form of an Excel spreadsheet (requires Excel 2002 or later).

A separate sheet is generated for each majorperformance statistic; graphs are automatically generated showing summary data for each server and for the installation as a whole. The tool allows nodes to be grouped together and will automatically calculate group totals and group averages for each statistic. Because the graphs are pre-defined the user is free to edit the titles, colours and fonts to suit their own requirements and can simply deleteunwanted charts, or entire sheets, to reduce the amount of output.

Administrators who tend partitioned servers will find this tool provides the ability to get an overview of an entire machine "at-a-glance” and provides the opportunity for modelling different partitioning scenarios (e.g. moving dedicated partitions into the shared pool).

The ability to view performance data for all nodes sideby side will be of particular benefit to administrators of clustered applications (e.g. Oracle RAC) and allows the easy identification of load balancing issues.

If all the files processed are from the same LPAR then the trend graphs which are produced by the tool can be useful as input to, or validation of, a capacity plan.

The other major use of this tool will be for modelling server...