Concepts of performance analysis with the RMF Spreadsheet Reporter

The RMF™ Spreadsheet Reporter is the powerful workstation solution for graphical presentation of RMF Postprocessor data. Use it to convert your RMF data to spreadsheet format and generate representative charts for all performance relevant areas.

The RMF Spreadsheet Reporter offers the following features:

ease of use - manage the related resources by means of an Explorer-like GUI
fast path to graphical presentation - prepare the SMF data in one single step
batch mode - generate the input files for the spreadsheets without any GUI interaction

Performance data derived from SMF records is the basis for z/OS® performance analysis and capacity planning. The basic idea of the RMF Spreadsheet Reporter is to exploit the graphical presentation facilities of a workstation for these purposes: it extracts performance measurements from SMF records, produces Postprocessor Report Listings and Overview Records and converts this Postprocessor output into spreadsheets. Thus, the Spreadsheet Reporter offers a complete solution of enhanced graphical presentation of RMF measurement data.

The Spreadsheet Reporter also provides several sample spreadsheet macros to help you in viewing and analyzing performance data at a glance.

Figure 1 shows a sample chart created with the Spreadsheet Reporter. It shows the CPU utilization of selected workloads for the prime shift.

Figure 1. Spreadsheet - CPU utilization for selected workloads

This figure shows a sample Spreadsheet: the CPU utilization for selected workloads.

DISCLAIMER OF WARRANTIES

All spreadsheet macros are sample code created by IBM®. They are not part of any standard IBM product and are provided to you solely for the purpose of assisting you in the development of your applications, and to demonstrate what can be done with RMF performance data.

This includes that service and upgrades for the macros through the standard IBM service channels are not available. In addition, you should be aware that there is no guarantee that the spreadsheet macros will work on your system or with your spreadsheet application, even if you use one of the listed versions.

Nevertheless, enhancements and possible fixes for the spreadsheet macros may become available in future, but they will not be shipped through the standard IBM service channels. You should monitor the RMF homepage available at

http://www.ibm.com/systems/z/os/zos/features/rmf/

for enhancements: You find information about the Spreadsheet Reporter on the Tools page, which is accessible from the RMF homepage.