Re: RMF Spreadsheet report 4 hour rolling MSU

2019-02-04 Thread Martin Packer
If I told you the relevant fields were SMF70LAC, SMF70LACM, SMF70LACA, 
SMF70LACB would that help? The last two are almost certainly zero, 
SMF70LACM also zero if not using Mobile Workload Pricing the "new" way.

Those names are what they're called in the raw SMF record mapping; TDS 
might call them something else.

Cheers, Martin

Martin Packer

zChampion, Systems Investigator & Performance Troubleshooter, IBM

+44-7802-245-584

email: martin_pac...@uk.ibm.com

Twitter / Facebook IDs: MartinPacker

Blog: 
https://www.ibm.com/developerworks/mydeveloperworks/blogs/MartinPacker

Podcast Series (With Marna Walle): https://developer.ibm.com/tv/mpt/or 
  
https://itunes.apple.com/gb/podcast/mainframe-performance-topics/id1127943573?mt=2


Youtube channel: https://www.youtube.com/channel/UCu_65HaYgksbF6Q8SQ4oOvA



From:   Tirad Pass 
To: IBM-MAIN@LISTSERV.UA.EDU
Date:   04/02/2019 09:39
Subject:    Re: RMF Spreadsheet report 4 hour rolling MSU
Sent by:IBM Mainframe Discussion List 



Hi John,

I got this email when I was looking for ways to produce RMF spreadsheets
with CPU, Memory etc usage. I cannot use the RMF Spreadheet reporting
because of FTP connection access issues. Can you please kindly send me 
also
the codes you've mentioned.

Gregorio Tirona
zOS support
IBM

On Wed, Oct 12, 2016 at 1:31 PM John Zoppetti  wrote:

> Jorge,
>
> If you have the Tivoli Decision Support product (MVS Performance
> Management Component), I have coding and reporting I can share with you.
> It provides me with daily reporting on hourly MSU usage and 4-hour 
rolling
> average MSU's by LPAR and by mainframe.  The reporting matches the SCRT
> reports that I send IBM each month.  I use the reports during the month 
to
> monitor MSU usage and also to validate the monthly SCRT reports.
>
> John Zoppetti
> Mainframe Support
> U. S. Steel
>
> --
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
>

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN




Unless stated otherwise above:
IBM United Kingdom Limited - Registered in England and Wales with number 
741598. 
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN


Re: RMF Spreadsheet report 4 hour rolling MSU

2019-02-04 Thread Tirad Pass
Hi John,

I got this email when I was looking for ways to produce RMF spreadsheets
with CPU, Memory etc usage. I cannot use the RMF Spreadheet reporting
because of FTP connection access issues. Can you please kindly send me also
the codes you've mentioned.

Gregorio Tirona
zOS support
IBM

On Wed, Oct 12, 2016 at 1:31 PM John Zoppetti  wrote:

> Jorge,
>
> If you have the Tivoli Decision Support product (MVS Performance
> Management Component), I have coding and reporting I can share with you.
> It provides me with daily reporting on hourly MSU usage and 4-hour rolling
> average MSU's by LPAR and by mainframe.  The reporting matches the SCRT
> reports that I send IBM each month.  I use the reports during the month to
> monitor MSU usage and also to validate the monthly SCRT reports.
>
> John Zoppetti
> Mainframe Support
> U. S. Steel
>
> --
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
>

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN


Re: RMF Spreadsheet report 4 hour rolling MSU

2016-10-14 Thread John Zoppetti
John, an email with the info is on the way to you.  Let me know how successful 
it is.

John Zoppetti
Mainframe Support
U. S. Steel

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN


Re: RMF Spreadsheet report 4 hour rolling MSU

2016-10-14 Thread Jorge Garcia
Hi all,

 Peter Mailand, from RMF IBM team, answers me. This value is available with the 
overview statement LACS,LACSM,LACSA,LACSB and you obtain overview records. Then 
you can process with Generic Overview Report Spreadsheet .

Regards

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN


Re: RMF Spreadsheet report 4 hour rolling MSU

2016-10-13 Thread John Wallin
Hello John,
I do have TDS.  May I get a copy of your query and reports?
Regards,
John

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN


Re: RMF Spreadsheet report 4 hour rolling MSU

2016-10-13 Thread Jorge Garcia
Hi John,

 I don't have Tivoli Decision Support. 

Regards

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN


Re: RMF Spreadsheet report 4 hour rolling MSU

2016-10-12 Thread John Zoppetti
Jorge,

If you have the Tivoli Decision Support product (MVS Performance Management 
Component), I have coding and reporting I can share with you.  It provides me 
with daily reporting on hourly MSU usage and 4-hour rolling average MSU's by 
LPAR and by mainframe.  The reporting matches the SCRT reports that I send IBM 
each month.  I use the reports during the month to monitor MSU usage and also 
to validate the monthly SCRT reports.

John Zoppetti
Mainframe Support
U. S. Steel

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN


Re: RMF Spreadsheet report 4 hour rolling MSU

2016-10-10 Thread Andrew Rowley

Hi Jorge,

I don't know how to get these reports from the RMF spreadsheet reporter, 
but EasySMF has 4 hour average MSU reports, including calculated 4 hour 
values by service/report class and largest jobs:

http://www.blackhillsoftware.com/docs/easysmf/4_hour_service_reports.htm

If you are interested you can use it for free for 30 days with a 30 day 
trial:

http://www.blackhillsoftware.com/30-day-trial/

Regards

Andrew Rowley


On 10/10/2016 8:07 PM, Jorge Garcia wrote:

Hi all,
  
  We try to obtain a RMF spreadsheet report to show 4 hour avg MSU. I can only obtain with OVW statement Actual number of consumed MSUs but we're interesting in GCMSUACT OVW statement Actual MSU consumption for the capacity

group and in 4 hour avg MSU, but there isn't OVW statement available for this 
metric.
Is there any spreadsheet report available for obtain these values?
How can we specified the GCMSUACT OVW statement in postprocessor STEP?
Are the default RMF spreadsheet macros available to process this OVW statement?

Regards

Jorge Garcia Juanino
Gerente sistemas z/OS
ACTP – DIAC – Operación y Soporte EMEA
MAPFRE
Avenida del Talgo 100-103 – 3ª Planta
CP 28023 Madrid
Tel. 91 581 27 34, Movil 618333559
jgarc...@mapfre.com

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN



--
Andrew Rowley
Black Hill Software
+61 413 302 386

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN


RMF Spreadsheet report 4 hour rolling MSU

2016-10-10 Thread Jorge Garcia
Hi all,
 
 We try to obtain a RMF spreadsheet report to show 4 hour avg MSU. I can only 
obtain with OVW statement Actual number of consumed MSUs but we're interesting 
in GCMSUACT OVW statement Actual MSU consumption for the capacity
group and in 4 hour avg MSU, but there isn't OVW statement available for this 
metric.
Is there any spreadsheet report available for obtain these values?
How can we specified the GCMSUACT OVW statement in postprocessor STEP?
Are the default RMF spreadsheet macros available to process this OVW statement?

Regards

Jorge Garcia Juanino
Gerente sistemas z/OS
ACTP – DIAC – Operación y Soporte EMEA
MAPFRE 
Avenida del Talgo 100-103 – 3ª Planta
CP 28023 Madrid
Tel. 91 581 27 34, Movil 618333559 
jgarc...@mapfre.com

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN