RMF Spreadsheet Reporter Overview

[Albert...@ibm-main.lst]

Hi List
I play around with the RMF Spreadsheet Reporter. I have created a report
successfully.

My problem:
SMF input dataset contains one day ( 07/17/2007)
If I create a overview, the first interval is 07/17/2007-21.15.00

//****************************************************************
//* RMF POSTPROCESSING OPTIONS
//****************************************************************
//SYSIN DD *
DATE(07012007,07312007)
NOSUMMARY
OVERVIEW(RECORD)
OVW(DEFMU2FM(WDEFL(MU2FMPW0)))
OVW(ACTMU2FM(WACTL(MU2FMPW0)))
OVW(MINMU2FM(WMINL(MU2FMPW0)))
OVW(MAXMU2FM(WMAXL(MU2FMPW0)))
OVW(NLDMU2FM(NLDEFL(MU2FMPW0)))
OVW(NLAMU2FM(NLACTL(MU2FMPW0)))
OVW(LBUMU2FM(LBUSYL(MU2FMPW0)))
OVW(PBUMU2FM(PBUSYL(MU2FMPW0)))
OVW(LDMMU2FM(LDEFMSU(MU2FMPW0)))
OVW(LDAMU2FM(LACTMSU(MU2FMPW0)))
OVW(CAPMU2FM(WCAPPER(MU2FMPW0)))
OVW(NLDPHY(NLDEFL(PHYSICAL)))
OVW(LBUPHY(LBUSYL(PHYSICAL)))
OVW(PBUPHY(PBUSYL(PHYSICAL)))
OVW(RMFX9CPC(PBUSYL(PHYSICAL)))
OVW(LASTRNG(PBUSYL(PHYSICAL)))
SYSOUT(H)

What's my mistake. Many thanks
Albert

VERLAGSGRUPPE WELTBILD GMBH
Sitz der Gesellschaft: Augsburg
Handelsregister Augsburg HRB 6035
Ust-ID-Nr: DE 127501299

Geschäftsführung:
Carel Halff (Vorsitzender), Dr. Klaus Driever, Werner Ortner, Herbert Zoch

Vorsitzender des Aufsichtsrates:
Dr. Klaus Donaubauer

[Albert...@ibm-main.lst]

I solved my problem. 'Sort SMF Datasets' must be selected in
Settings/Options/General

[Thomas H Puddicombe]

Statistician's First Commandment: "Know your data and know it well"

Have you empirically and independently proven beyond any doubt that the
range of timestamps in the input dataset meets or exceeds all of the
desired reporting interval? Does the date range in the data make more
sense if you adjust it for GMT offset?

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit written
agreement or government initiative expressly permitting the use of e-mail
for such purpose.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Albert Klimek
<Albert.Klimek@WE
LTBILD.COM> To
Sent by: IBM IBM-...@BAMA.UA.EDU
Mainframe cc
Discussion List
<IBM-...@BAMA.UA Subject
.EDU> RMF Spreadsheet Reporter Overview


07/19/2007 04:54
AM


Please respond to
IBM Mainframe
Discussion List
<IBM-...@BAMA.UA
.EDU>

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to list...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

[Albert...@ibm-main.lst]

RMF is not my main topic. Therefore I use the RMF Spreadsheet Reporter to
investigate our LPAR performance.
But a sorted SMF dataset is mandatory for reports and overviews. I assumed
the Spreadsheet Reporter handles this automatically.

[mai...@de.ibm.com]

Hi,
if you have SMF data only from one system,a sort step is usually not
required (because the SMF records are stored in the right sequence in
the SMF dataset). Within the Spreadsheet Reporter, check the Settings-
>Options->General : Sort SMF Datasets option (check it to enable the
sort).
To ensure that the SMF input dataset contains data for the complete
day, you may either create a SUMMARY report, or use the RMF Utility
SYS1.SERBSCLS(ERBSCAN) to check the SMF data (timestamp of the SMF
records - CPU data is stored in SMF 70.1).

regards,
Peter Mailand, RMF Team

[mai...@de.ibm.com]

Little typo:The REXX exec is stored in SYS1.SERBCLS(ERBSCAN)

regards, Peter Mailand (RMF Team)