RMF Spreadsheet Reporter from z/OS 2.4
Attempting to create a working set, and I get the error messages below. I cannot find the error messages in the RMF Messages manual, under the top of RMF Spreadsheet Reporter. Anyone have ideas? RMF Spreadsheet Reporter V5.4.41 z/OS Copyright (c) 1994-2020, IBM Corporation - all rights reserved Copyright (c) 2020, 2022, Rocket Software, Inc. - all rights reserved CMD: C:\Users\Pinionr\Documents\RMF Spreadsheet Reporter\RMF2SC\rmf2scw.exe /q /nw /f C:\Users\Pinionr\AppData\Roaming\RMF\RMF Spreadsheet Reporter\WorkingSets\Rpt.SC10.D020.T112423\Q084.RPT /l C:\Users\Pinionr\AppData\Roaming\RMF\RMF Spreadsheet Reporter\WorkingSets\Rpt.SC10.D020.T112423\Q084.XLS /o C:\Users\Pinionr\AppData\Roaming\RMF\RMF Spreadsheet Reporter\WorkingSets\Rpt.SC10.D020.T112423\ /xcel ERB9042A PWS: Expected a flag, found Spreadsheet, RC=1 Fri Jan 20 11:25:40 2023 ERB9042A PWS: Expected a flag, found Reporter\WorkingSets\Rpt.SC10.D020.T112423\, RC=1 Fri Jan 20 11:25:40 2023 RMF2SC- V5.4.41 RMF z/OS - Sent with [Proton Mail](https://proton.me/) secure email. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: AW: RMF Spreadsheet Reporter
One other thought. This list and the email address provided may not resolve your issue quickly. The best path is always to open an ETR/SR with IBM for quicker resolution. Lizette > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Lizette Koehler > Sent: Friday, July 18, 2014 3:42 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: AW: RMF Spreadsheet Reporter > > I totally understand the pretty picture stuff. > > And sometimes what is no cost solutions have challenges. > > There is Intellimagic products https://www.intellimagic.net/home > > I do not have them at my shop, but I hear they are very good products. > > Create pretty charts for all sorts of RMF/SMF functions. > > When we were doing DASD Analysis (how much do we need if we go to a specific > storage array), this is what IBM used. > > Lizette > > > > -Original Message- > > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] > > On Behalf Of Christian Birr > > Sent: Friday, July 18, 2014 3:34 AM > > To: IBM-MAIN@LISTSERV.UA.EDU > > Subject: AW: AW: RMF Spreadsheet Reporter > > > > I did indeed, Lizette. Either the mail got lost or the group had no > > time > yet to > > investigate and answer my questions. Management of one of my customers > > stumbled into RMF PP & PM, and they love nice pictures and charts ;) > > And I > can't > > tell the simply : this IBM software is broken > > Thanks, > > Christian > > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
AW: AW: RMF Spreadsheet Reporter
I know, and Shane pointed me to another product, and for sure, there are many others. But guess what the answer would be? "There's money involved? No way" Well, it's Friday at last Christian -Ursprüngliche Nachricht- Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] Im Auftrag von Lizette Koehler Gesendet: Freitag, 18. Juli 2014 12:42 An: IBM-MAIN@LISTSERV.UA.EDU Betreff: Re: AW: RMF Spreadsheet Reporter I totally understand the pretty picture stuff. And sometimes what is no cost solutions have challenges. There is Intellimagic products https://www.intellimagic.net/home I do not have them at my shop, but I hear they are very good products. Create pretty charts for all sorts of RMF/SMF functions. When we were doing DASD Analysis (how much do we need if we go to a specific storage array), this is what IBM used. Lizette > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Christian Birr > Sent: Friday, July 18, 2014 3:34 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: AW: AW: RMF Spreadsheet Reporter > > I did indeed, Lizette. Either the mail got lost or the group had no time yet to > investigate and answer my questions. Management of one of my customers > stumbled into RMF PP & PM, and they love nice pictures and charts ;) And I can't > tell the simply : this IBM software is broken > Thanks, > Christian > > -Ursprüngliche Nachricht- > Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] Im > Auftrag von Lizette Koehler > Gesendet: Freitag, 18. Juli 2014 12:23 > An: IBM-MAIN@LISTSERV.UA.EDU > Betreff: Re: AW: RMF Spreadsheet Reporter > > Did you send the request to the email address I provided? > Try sending a request to this email address r...@de.ibm.com > > Or did you open an SR to IBM RMF? > > IBM groups to not necessarily monitor the various Lists on the internet. > > Lizette > > > > -Original Message- > > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] > > On Behalf Of Christian Birr > > Sent: Friday, July 18, 2014 2:40 AM > > To: IBM-MAIN@LISTSERV.UA.EDU > > Subject: AW: AW: RMF Spreadsheet Reporter > > > > Thanks Roger, I'd love to but the FTP dialog is generated internally > > by > RMF PP. The > > workaround is retrieving the reports manually. Still don't understand > > why > the RMF > > group has no answer for this... > > Regards, > > Christian > > -Ursprüngliche Nachricht----- > > Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] > > Im Auftrag von Roger Bolan > > Gesendet: Freitag, 18. Juli 2014 01:26 > > An: IBM-MAIN@LISTSERV.UA.EDU > > Betreff: Re: AW: RMF Spreadsheet Reporter > > > > Since 'BIRR.' is already your working directory, what happens if you > > use > RETR > > D196.T145616.LISTING instead of RETR 'BIRR.D196.T145616.LISTING' > > > > Regards, > > --Roger > > > > > > On Wed, Jul 16, 2014 at 11:51 AM, Christian Birr < > > christian.b...@birrconsulting.de> wrote: > > > > > Miklos, > > > I can't tell you, the FTP process is build internally and I suspect > > > that the process is generated before the job has finished, there is > > > no possibility on RMF PP side to switch on a trace but as I > > > understand, the host FTP is used so I might be able to switch it on > > > there, no messages in SYSLOG either. > > > Michael had a similar problem and described the path he did go to > > > avoid it (Thanks Michael). Maybe raising the timeout limit on host > > > side would solve the problem. I'll give it a try tomorrow. > > > One last word on RMF PP - btw RMF PM works fine - : even if it's "free" > > > software I would expect that the code works (I don't want to start a > > > new discussion about "Freebie" software). Someone in the RMF team > > > could answer those questions, still awaiting a reply. > > > Christian > > > > > > -Ursprüngliche Nachricht- > > > Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] > > > Im Auftrag von Miklos Szigetvari > > > Gesendet: Mittwoch, 16. Juli 2014 17:08 > > > An: IBM-MAIN@LISTSERV.UA.EDU > > > Betreff: Re: AW: RMF Spreadsheet Reporter > > > > > > HI > > > > > > Some questions: > > > 1) Are you sure the input dataset is cataloged at the time of the > > > FTP > get ? > > > > > > 2)If it is a su
Re: AW: RMF Spreadsheet Reporter
I totally understand the pretty picture stuff. And sometimes what is no cost solutions have challenges. There is Intellimagic products https://www.intellimagic.net/home I do not have them at my shop, but I hear they are very good products. Create pretty charts for all sorts of RMF/SMF functions. When we were doing DASD Analysis (how much do we need if we go to a specific storage array), this is what IBM used. Lizette > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Christian Birr > Sent: Friday, July 18, 2014 3:34 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: AW: AW: RMF Spreadsheet Reporter > > I did indeed, Lizette. Either the mail got lost or the group had no time yet to > investigate and answer my questions. Management of one of my customers > stumbled into RMF PP & PM, and they love nice pictures and charts ;) And I can't > tell the simply : this IBM software is broken > Thanks, > Christian > > -Ursprüngliche Nachricht- > Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] Im > Auftrag von Lizette Koehler > Gesendet: Freitag, 18. Juli 2014 12:23 > An: IBM-MAIN@LISTSERV.UA.EDU > Betreff: Re: AW: RMF Spreadsheet Reporter > > Did you send the request to the email address I provided? > Try sending a request to this email address r...@de.ibm.com > > Or did you open an SR to IBM RMF? > > IBM groups to not necessarily monitor the various Lists on the internet. > > Lizette > > > > -Original Message- > > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] > > On Behalf Of Christian Birr > > Sent: Friday, July 18, 2014 2:40 AM > > To: IBM-MAIN@LISTSERV.UA.EDU > > Subject: AW: AW: RMF Spreadsheet Reporter > > > > Thanks Roger, I'd love to but the FTP dialog is generated internally > > by > RMF PP. The > > workaround is retrieving the reports manually. Still don't understand > > why > the RMF > > group has no answer for this... > > Regards, > > Christian > > -Ursprüngliche Nachricht----- > > Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] > > Im Auftrag von Roger Bolan > > Gesendet: Freitag, 18. Juli 2014 01:26 > > An: IBM-MAIN@LISTSERV.UA.EDU > > Betreff: Re: AW: RMF Spreadsheet Reporter > > > > Since 'BIRR.' is already your working directory, what happens if you > > use > RETR > > D196.T145616.LISTING instead of RETR 'BIRR.D196.T145616.LISTING' > > > > Regards, > > --Roger > > > > > > On Wed, Jul 16, 2014 at 11:51 AM, Christian Birr < > > christian.b...@birrconsulting.de> wrote: > > > > > Miklos, > > > I can't tell you, the FTP process is build internally and I suspect > > > that the process is generated before the job has finished, there is > > > no possibility on RMF PP side to switch on a trace but as I > > > understand, the host FTP is used so I might be able to switch it on > > > there, no messages in SYSLOG either. > > > Michael had a similar problem and described the path he did go to > > > avoid it (Thanks Michael). Maybe raising the timeout limit on host > > > side would solve the problem. I'll give it a try tomorrow. > > > One last word on RMF PP - btw RMF PM works fine - : even if it's "free" > > > software I would expect that the code works (I don't want to start a > > > new discussion about "Freebie" software). Someone in the RMF team > > > could answer those questions, still awaiting a reply. > > > Christian > > > > > > -Ursprüngliche Nachricht- > > > Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] > > > Im Auftrag von Miklos Szigetvari > > > Gesendet: Mittwoch, 16. Juli 2014 17:08 > > > An: IBM-MAIN@LISTSERV.UA.EDU > > > Betreff: Re: AW: RMF Spreadsheet Reporter > > > > > > HI > > > > > > Some questions: > > > 1) Are you sure the input dataset is cataloged at the time of the > > > FTP > get ? > > > > > > 2)If it is a submitted job, it can be that the dataset is not yet > > > exits in the time of the FTP. Is it possible to set some delay > > > before the FTP get ? > > > > > > 3)You can switch on the FTP trace > > > > > > 4)Any console message about this FTP GET ? > > > > > > On 16.07.2014 13:09, Christian Birr wrote: > > > > No, not at all. And I don't agree with Shane, report selection an
AW: AW: RMF Spreadsheet Reporter
I did indeed, Lizette. Either the mail got lost or the group had no time yet to investigate and answer my questions. Management of one of my customers stumbled into RMF PP & PM, and they love nice pictures and charts ;) And I can't tell the simply : this IBM software is broken Thanks, Christian -Ursprüngliche Nachricht- Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] Im Auftrag von Lizette Koehler Gesendet: Freitag, 18. Juli 2014 12:23 An: IBM-MAIN@LISTSERV.UA.EDU Betreff: Re: AW: RMF Spreadsheet Reporter Did you send the request to the email address I provided? Try sending a request to this email address r...@de.ibm.com Or did you open an SR to IBM RMF? IBM groups to not necessarily monitor the various Lists on the internet. Lizette > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Christian Birr > Sent: Friday, July 18, 2014 2:40 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: AW: AW: RMF Spreadsheet Reporter > > Thanks Roger, I'd love to but the FTP dialog is generated internally by RMF PP. The > workaround is retrieving the reports manually. Still don't understand why the RMF > group has no answer for this... > Regards, > Christian > -Ursprüngliche Nachricht- > Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] Im > Auftrag von Roger Bolan > Gesendet: Freitag, 18. Juli 2014 01:26 > An: IBM-MAIN@LISTSERV.UA.EDU > Betreff: Re: AW: RMF Spreadsheet Reporter > > Since 'BIRR.' is already your working directory, what happens if you use RETR > D196.T145616.LISTING instead of RETR 'BIRR.D196.T145616.LISTING' > > Regards, > --Roger > > > On Wed, Jul 16, 2014 at 11:51 AM, Christian Birr < > christian.b...@birrconsulting.de> wrote: > > > Miklos, > > I can't tell you, the FTP process is build internally and I suspect > > that the process is generated before the job has finished, there is no > > possibility on RMF PP side to switch on a trace but as I understand, > > the host FTP is used so I might be able to switch it on there, no > > messages in SYSLOG either. > > Michael had a similar problem and described the path he did go to > > avoid it (Thanks Michael). Maybe raising the timeout limit on host > > side would solve the problem. I'll give it a try tomorrow. > > One last word on RMF PP - btw RMF PM works fine - : even if it's "free" > > software I would expect that the code works (I don't want to start a > > new discussion about "Freebie" software). Someone in the RMF team > > could answer those questions, still awaiting a reply. > > Christian > > > > -Ursprüngliche Nachricht- > > Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] > > Im Auftrag von Miklos Szigetvari > > Gesendet: Mittwoch, 16. Juli 2014 17:08 > > An: IBM-MAIN@LISTSERV.UA.EDU > > Betreff: Re: AW: RMF Spreadsheet Reporter > > > > HI > > > > Some questions: > > 1) Are you sure the input dataset is cataloged at the time of the FTP get ? > > > > 2)If it is a submitted job, it can be that the dataset is not yet > > exits in the time of the FTP. Is it possible to set some delay before > > the FTP get ? > > > > 3)You can switch on the FTP trace > > > > 4)Any console message about this FTP GET ? > > > > On 16.07.2014 13:09, Christian Birr wrote: > > > No, not at all. And I don't agree with Shane, report selection and > > > JCL > > run fine and after retrieving the reports manually with FTP everything > > works perfect in RMF PP. The only culprit is the internal FTP not working. > > > Here is an extract of the FTP log: > > > > > > SENT: USER BIRR > > > 331 Send password please. > > > SENT: PASS (*hidden*) > > > 230 BIRR is logged on. Working directory is "BIRR.". > > > SENT: SYST > > > 215 MVS is the operating system of this server. FTP Server is > > > running on > > z/OS. > > > SENT: PWD > > > 257 "'BIRR.'" is working directory. > > > SENT: CWD 'BIRR' > > > 250 "BIRR." is the working directory name prefix. > > > SENT: PWD > > > 257 "'BIRR.'" is working directory. > > > SENT: site retpd > > > 200 SITE command was accepted > > > SENT: site autorecall > > > 200 SITE command was accepted > > > SENT: TYPE A > > > 200 Representation type is Ascii NonPrint > > > SENT: SITE noasatrans > > > 200 SITE com
Re: AW: RMF Spreadsheet Reporter
Did you send the request to the email address I provided? Try sending a request to this email address r...@de.ibm.com Or did you open an SR to IBM RMF? IBM groups to not necessarily monitor the various Lists on the internet. Lizette > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Christian Birr > Sent: Friday, July 18, 2014 2:40 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: AW: AW: RMF Spreadsheet Reporter > > Thanks Roger, I'd love to but the FTP dialog is generated internally by RMF PP. The > workaround is retrieving the reports manually. Still don't understand why the RMF > group has no answer for this... > Regards, > Christian > -Ursprüngliche Nachricht- > Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] Im > Auftrag von Roger Bolan > Gesendet: Freitag, 18. Juli 2014 01:26 > An: IBM-MAIN@LISTSERV.UA.EDU > Betreff: Re: AW: RMF Spreadsheet Reporter > > Since 'BIRR.' is already your working directory, what happens if you use RETR > D196.T145616.LISTING instead of RETR 'BIRR.D196.T145616.LISTING' > > Regards, > --Roger > > > On Wed, Jul 16, 2014 at 11:51 AM, Christian Birr < > christian.b...@birrconsulting.de> wrote: > > > Miklos, > > I can't tell you, the FTP process is build internally and I suspect > > that the process is generated before the job has finished, there is no > > possibility on RMF PP side to switch on a trace but as I understand, > > the host FTP is used so I might be able to switch it on there, no > > messages in SYSLOG either. > > Michael had a similar problem and described the path he did go to > > avoid it (Thanks Michael). Maybe raising the timeout limit on host > > side would solve the problem. I'll give it a try tomorrow. > > One last word on RMF PP - btw RMF PM works fine - : even if it's "free" > > software I would expect that the code works (I don't want to start a > > new discussion about "Freebie" software). Someone in the RMF team > > could answer those questions, still awaiting a reply. > > Christian > > > > -Ursprüngliche Nachricht- > > Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] > > Im Auftrag von Miklos Szigetvari > > Gesendet: Mittwoch, 16. Juli 2014 17:08 > > An: IBM-MAIN@LISTSERV.UA.EDU > > Betreff: Re: AW: RMF Spreadsheet Reporter > > > > HI > > > > Some questions: > > 1) Are you sure the input dataset is cataloged at the time of the FTP get ? > > > > 2)If it is a submitted job, it can be that the dataset is not yet > > exits in the time of the FTP. Is it possible to set some delay before > > the FTP get ? > > > > 3)You can switch on the FTP trace > > > > 4)Any console message about this FTP GET ? > > > > On 16.07.2014 13:09, Christian Birr wrote: > > > No, not at all. And I don't agree with Shane, report selection and > > > JCL > > run fine and after retrieving the reports manually with FTP everything > > works perfect in RMF PP. The only culprit is the internal FTP not working. > > > Here is an extract of the FTP log: > > > > > > SENT: USER BIRR > > > 331 Send password please. > > > SENT: PASS (*hidden*) > > > 230 BIRR is logged on. Working directory is "BIRR.". > > > SENT: SYST > > > 215 MVS is the operating system of this server. FTP Server is > > > running on > > z/OS. > > > SENT: PWD > > > 257 "'BIRR.'" is working directory. > > > SENT: CWD 'BIRR' > > > 250 "BIRR." is the working directory name prefix. > > > SENT: PWD > > > 257 "'BIRR.'" is working directory. > > > SENT: site retpd > > > 200 SITE command was accepted > > > SENT: site autorecall > > > 200 SITE command was accepted > > > SENT: TYPE A > > > 200 Representation type is Ascii NonPrint > > > SENT: SITE noasatrans > > > 200 SITE command was accepted > > > SENT: PORT 192,168,16,38,4,194 > > > 200 Port request OK. > > > SENT: RETR 'BIRR.D196.T145616.LISTING' > > > 550 Data set BIRR.D196.T145616.LISTING not found FTP Get failed > > > 550 Data set BIRR.D196.T145616.LISTING not found > > > > > > Christian > > > > > > -Ursprüngliche Nachricht- > > > Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] > > > Im > > Auftrag von Boris Lenz > > > Gesendet: Mittwoch, 16. Juli 2014 11:49 > > > An: IBM-MAIN@LISTSERV.UA.EDU > > > Betreff: Re: RMF Spreadsheet Reporter > > > > > > Any special characters like $ @ # in the userid? > > > > > > Regards, > > > Boris > > > > > > > > > On Tue, July 15, 2014 21:02, Christian Birr wrote: > > >> I'll do that tomorrow; I'm on CET and on duty since 5:00, need some > > sleep. > > >> My hope was that someone of RMF/Böblingen would chime in. > > >> Thanks > > >> Christian -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
AW: AW: RMF Spreadsheet Reporter
Thanks Roger, I'd love to but the FTP dialog is generated internally by RMF PP. The workaround is retrieving the reports manually. Still don't understand why the RMF group has no answer for this... Regards, Christian -Ursprüngliche Nachricht- Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] Im Auftrag von Roger Bolan Gesendet: Freitag, 18. Juli 2014 01:26 An: IBM-MAIN@LISTSERV.UA.EDU Betreff: Re: AW: RMF Spreadsheet Reporter Since 'BIRR.' is already your working directory, what happens if you use RETR D196.T145616.LISTING instead of RETR 'BIRR.D196.T145616.LISTING' Regards, --Roger On Wed, Jul 16, 2014 at 11:51 AM, Christian Birr < christian.b...@birrconsulting.de> wrote: > Miklos, > I can't tell you, the FTP process is build internally and I suspect that > the process is generated before the job has finished, there is no > possibility on RMF PP side to switch on a trace but as I understand, the > host FTP is used so I might be able to switch it on there, no messages in > SYSLOG either. > Michael had a similar problem and described the path he did go to avoid it > (Thanks Michael). Maybe raising the timeout limit on host side would solve > the problem. I'll give it a try tomorrow. > One last word on RMF PP - btw RMF PM works fine - : even if it's "free" > software I would expect that the code works (I don't want to start a new > discussion about "Freebie" software). Someone in the RMF team could answer > those questions, still awaiting a reply. > Christian > > -Ursprüngliche Nachricht- > Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] Im > Auftrag von Miklos Szigetvari > Gesendet: Mittwoch, 16. Juli 2014 17:08 > An: IBM-MAIN@LISTSERV.UA.EDU > Betreff: Re: AW: RMF Spreadsheet Reporter > > HI > > Some questions: > 1) Are you sure the input dataset is cataloged at the time of the FTP get ? > > 2)If it is a submitted job, it can be that the dataset is not yet exits > in the time of the FTP. Is it possible to set some delay before the FTP > get ? > > 3)You can switch on the FTP trace > > 4)Any console message about this FTP GET ? > > On 16.07.2014 13:09, Christian Birr wrote: > > No, not at all. And I don't agree with Shane, report selection and JCL > run fine and after retrieving the reports manually with FTP everything > works perfect in RMF PP. The only culprit is the internal FTP not working. > > Here is an extract of the FTP log: > > > > SENT: USER BIRR > > 331 Send password please. > > SENT: PASS (*hidden*) > > 230 BIRR is logged on. Working directory is "BIRR.". > > SENT: SYST > > 215 MVS is the operating system of this server. FTP Server is running on > z/OS. > > SENT: PWD > > 257 "'BIRR.'" is working directory. > > SENT: CWD 'BIRR' > > 250 "BIRR." is the working directory name prefix. > > SENT: PWD > > 257 "'BIRR.'" is working directory. > > SENT: site retpd > > 200 SITE command was accepted > > SENT: site autorecall > > 200 SITE command was accepted > > SENT: TYPE A > > 200 Representation type is Ascii NonPrint > > SENT: SITE noasatrans > > 200 SITE command was accepted > > SENT: PORT 192,168,16,38,4,194 > > 200 Port request OK. > > SENT: RETR 'BIRR.D196.T145616.LISTING' > > 550 Data set BIRR.D196.T145616.LISTING not found > > FTP Get failed > > 550 Data set BIRR.D196.T145616.LISTING not found > > > > Christian > > > > -Ursprüngliche Nachricht- > > Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] Im > Auftrag von Boris Lenz > > Gesendet: Mittwoch, 16. Juli 2014 11:49 > > An: IBM-MAIN@LISTSERV.UA.EDU > > Betreff: Re: RMF Spreadsheet Reporter > > > > Any special characters like $ @ # in the userid? > > > > Regards, > > Boris > > > > > > On Tue, July 15, 2014 21:02, Christian Birr wrote: > >> I'll do that tomorrow; I'm on CET and on duty since 5:00, need some > sleep. > >> My hope was that someone of RMF/Böblingen would chime in. > >> Thanks > >> Christian > > -- > > 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 IB
Re: AW: RMF Spreadsheet Reporter
Since 'BIRR.' is already your working directory, what happens if you use RETR D196.T145616.LISTING instead of RETR 'BIRR.D196.T145616.LISTING' Regards, --Roger On Wed, Jul 16, 2014 at 11:51 AM, Christian Birr < christian.b...@birrconsulting.de> wrote: > Miklos, > I can't tell you, the FTP process is build internally and I suspect that > the process is generated before the job has finished, there is no > possibility on RMF PP side to switch on a trace but as I understand, the > host FTP is used so I might be able to switch it on there, no messages in > SYSLOG either. > Michael had a similar problem and described the path he did go to avoid it > (Thanks Michael). Maybe raising the timeout limit on host side would solve > the problem. I'll give it a try tomorrow. > One last word on RMF PP - btw RMF PM works fine - : even if it's "free" > software I would expect that the code works (I don't want to start a new > discussion about "Freebie" software). Someone in the RMF team could answer > those questions, still awaiting a reply. > Christian > > -Ursprüngliche Nachricht- > Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] Im > Auftrag von Miklos Szigetvari > Gesendet: Mittwoch, 16. Juli 2014 17:08 > An: IBM-MAIN@LISTSERV.UA.EDU > Betreff: Re: AW: RMF Spreadsheet Reporter > > HI > > Some questions: > 1) Are you sure the input dataset is cataloged at the time of the FTP get ? > > 2)If it is a submitted job, it can be that the dataset is not yet exits > in the time of the FTP. Is it possible to set some delay before the FTP > get ? > > 3)You can switch on the FTP trace > > 4)Any console message about this FTP GET ? > > On 16.07.2014 13:09, Christian Birr wrote: > > No, not at all. And I don't agree with Shane, report selection and JCL > run fine and after retrieving the reports manually with FTP everything > works perfect in RMF PP. The only culprit is the internal FTP not working. > > Here is an extract of the FTP log: > > > > SENT: USER BIRR > > 331 Send password please. > > SENT: PASS (*hidden*) > > 230 BIRR is logged on. Working directory is "BIRR.". > > SENT: SYST > > 215 MVS is the operating system of this server. FTP Server is running on > z/OS. > > SENT: PWD > > 257 "'BIRR.'" is working directory. > > SENT: CWD 'BIRR' > > 250 "BIRR." is the working directory name prefix. > > SENT: PWD > > 257 "'BIRR.'" is working directory. > > SENT: site retpd > > 200 SITE command was accepted > > SENT: site autorecall > > 200 SITE command was accepted > > SENT: TYPE A > > 200 Representation type is Ascii NonPrint > > SENT: SITE noasatrans > > 200 SITE command was accepted > > SENT: PORT 192,168,16,38,4,194 > > 200 Port request OK. > > SENT: RETR 'BIRR.D196.T145616.LISTING' > > 550 Data set BIRR.D196.T145616.LISTING not found > > FTP Get failed > > 550 Data set BIRR.D196.T145616.LISTING not found > > > > Christian > > > > -Ursprüngliche Nachricht- > > Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] Im > Auftrag von Boris Lenz > > Gesendet: Mittwoch, 16. Juli 2014 11:49 > > An: IBM-MAIN@LISTSERV.UA.EDU > > Betreff: Re: RMF Spreadsheet Reporter > > > > Any special characters like $ @ # in the userid? > > > > Regards, > > Boris > > > > > > On Tue, July 15, 2014 21:02, Christian Birr wrote: > >> I'll do that tomorrow; I'm on CET and on duty since 5:00, need some > sleep. > >> My hope was that someone of RMF/Böblingen would chime in. > >> Thanks > >> Christian > > -- > > 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 > > > > > > -- > 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 > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
AW: AW: RMF Spreadsheet Reporter
Miklos, I can't tell you, the FTP process is build internally and I suspect that the process is generated before the job has finished, there is no possibility on RMF PP side to switch on a trace but as I understand, the host FTP is used so I might be able to switch it on there, no messages in SYSLOG either. Michael had a similar problem and described the path he did go to avoid it (Thanks Michael). Maybe raising the timeout limit on host side would solve the problem. I'll give it a try tomorrow. One last word on RMF PP - btw RMF PM works fine - : even if it's "free" software I would expect that the code works (I don't want to start a new discussion about "Freebie" software). Someone in the RMF team could answer those questions, still awaiting a reply. Christian -Ursprüngliche Nachricht- Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] Im Auftrag von Miklos Szigetvari Gesendet: Mittwoch, 16. Juli 2014 17:08 An: IBM-MAIN@LISTSERV.UA.EDU Betreff: Re: AW: RMF Spreadsheet Reporter HI Some questions: 1) Are you sure the input dataset is cataloged at the time of the FTP get ? 2)If it is a submitted job, it can be that the dataset is not yet exits in the time of the FTP. Is it possible to set some delay before the FTP get ? 3)You can switch on the FTP trace 4)Any console message about this FTP GET ? On 16.07.2014 13:09, Christian Birr wrote: > No, not at all. And I don't agree with Shane, report selection and JCL run > fine and after retrieving the reports manually with FTP everything works > perfect in RMF PP. The only culprit is the internal FTP not working. > Here is an extract of the FTP log: > > SENT: USER BIRR > 331 Send password please. > SENT: PASS (*hidden*) > 230 BIRR is logged on. Working directory is "BIRR.". > SENT: SYST > 215 MVS is the operating system of this server. FTP Server is running on z/OS. > SENT: PWD > 257 "'BIRR.'" is working directory. > SENT: CWD 'BIRR' > 250 "BIRR." is the working directory name prefix. > SENT: PWD > 257 "'BIRR.'" is working directory. > SENT: site retpd > 200 SITE command was accepted > SENT: site autorecall > 200 SITE command was accepted > SENT: TYPE A > 200 Representation type is Ascii NonPrint > SENT: SITE noasatrans > 200 SITE command was accepted > SENT: PORT 192,168,16,38,4,194 > 200 Port request OK. > SENT: RETR 'BIRR.D196.T145616.LISTING' > 550 Data set BIRR.D196.T145616.LISTING not found > FTP Get failed > 550 Data set BIRR.D196.T145616.LISTING not found > > Christian > > -Ursprüngliche Nachricht- > Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] Im > Auftrag von Boris Lenz > Gesendet: Mittwoch, 16. Juli 2014 11:49 > An: IBM-MAIN@LISTSERV.UA.EDU > Betreff: Re: RMF Spreadsheet Reporter > > Any special characters like $ @ # in the userid? > > Regards, > Boris > > > On Tue, July 15, 2014 21:02, Christian Birr wrote: >> I'll do that tomorrow; I'm on CET and on duty since 5:00, need some sleep. >> My hope was that someone of RMF/Böblingen would chime in. >> Thanks >> Christian > -- > 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 > > -- 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: AW: RMF Spreadsheet Reporter
When I submitted a job, RMFSR wanted to sit there and wait for the submitted job to get done. Eventually it times out because the job could take up to 20 minutes or more. So my process was to (and I'm going from memory since my mainframe is gone): 1. Click on the Remote SMF Dump Data folder and select an SMF dataset (if you haven't set up one, right click on the blank area and select NEW) 2. Click the Create Overview Record button on the toolbar 3. On the Create Overview Record window, copy the Remote dataset name 4. Press the RUN button (progress meter goes active) 5. Wait a couple of seconds to make sure the job makes it to the mainframe. 6. Press the CANCEL button 7. Select the Remote Overview Records folder on the resources tab. 8. Right click the blank area and select NEW 9. Where it says to enter Name, paste the remote dataset name that was copied in step 1 10. Repeat process When the job finally finishes on the mainframe, then I would: 1. Select the entry created in steps 6-7 from above. 2. Press the FTP toolbar button 3. Change the LOCAL name to something more descriptive (for later selection in charts) 4. Press the RUN button After the FTP finishes: 1. Select the Local Overview Records folder on the resources tab. 2. Select an overview record entry 3. Click the Create Working Set button on the toolbar Once the conversion process is finished, you will have an entry in the Local Working Sets folder that can be used to input in various spreadsheet charts. That was the process I used every month for 10 years to create monthly charts and yearly trends charts using Overview Records. Hopefully that will shed some light on your issue. Mike Schmutzok Sr Systems Programmer UF & SHands HealthCare -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Miklos Szigetvari Sent: Wednesday, July 16, 2014 11:08 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: AW: RMF Spreadsheet Reporter HI Some questions: 1) Are you sure the input dataset is cataloged at the time of the FTP get ? 2)If it is a submitted job, it can be that the dataset is not yet exits in the time of the FTP. Is it possible to set some delay before the FTP get ? 3)You can switch on the FTP trace 4)Any console message about this FTP GET ? On 16.07.2014 13:09, Christian Birr wrote: > No, not at all. And I don't agree with Shane, report selection and JCL run > fine and after retrieving the reports manually with FTP everything works > perfect in RMF PP. The only culprit is the internal FTP not working. > Here is an extract of the FTP log: > > SENT: USER BIRR > 331 Send password please. > SENT: PASS (*hidden*) > 230 BIRR is logged on. Working directory is "BIRR.". > SENT: SYST > 215 MVS is the operating system of this server. FTP Server is running on z/OS. > SENT: PWD > 257 "'BIRR.'" is working directory. > SENT: CWD 'BIRR' > 250 "BIRR." is the working directory name prefix. > SENT: PWD > 257 "'BIRR.'" is working directory. > SENT: site retpd > 200 SITE command was accepted > SENT: site autorecall > 200 SITE command was accepted > SENT: TYPE A > 200 Representation type is Ascii NonPrint > SENT: SITE noasatrans > 200 SITE command was accepted > SENT: PORT 192,168,16,38,4,194 > 200 Port request OK. > SENT: RETR 'BIRR.D196.T145616.LISTING' > 550 Data set BIRR.D196.T145616.LISTING not found FTP Get failed > 550 Data set BIRR.D196.T145616.LISTING not found > > Christian > > -Ursprüngliche Nachricht- > Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] > Im Auftrag von Boris Lenz > Gesendet: Mittwoch, 16. Juli 2014 11:49 > An: IBM-MAIN@LISTSERV.UA.EDU > Betreff: Re: RMF Spreadsheet Reporter > > Any special characters like $ @ # in the userid? > > Regards, > Boris > > > On Tue, July 15, 2014 21:02, Christian Birr wrote: >> I'll do that tomorrow; I'm on CET and on duty since 5:00, need some sleep. >> My hope was that someone of RMF/Böblingen would chime in. >> Thanks >> Christian > -- > 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 > > -- 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: AW: RMF Spreadsheet Reporter
HI Some questions: 1) Are you sure the input dataset is cataloged at the time of the FTP get ? 2)If it is a submitted job, it can be that the dataset is not yet exits in the time of the FTP. Is it possible to set some delay before the FTP get ? 3)You can switch on the FTP trace 4)Any console message about this FTP GET ? On 16.07.2014 13:09, Christian Birr wrote: No, not at all. And I don't agree with Shane, report selection and JCL run fine and after retrieving the reports manually with FTP everything works perfect in RMF PP. The only culprit is the internal FTP not working. Here is an extract of the FTP log: SENT: USER BIRR 331 Send password please. SENT: PASS (*hidden*) 230 BIRR is logged on. Working directory is "BIRR.". SENT: SYST 215 MVS is the operating system of this server. FTP Server is running on z/OS. SENT: PWD 257 "'BIRR.'" is working directory. SENT: CWD 'BIRR' 250 "BIRR." is the working directory name prefix. SENT: PWD 257 "'BIRR.'" is working directory. SENT: site retpd 200 SITE command was accepted SENT: site autorecall 200 SITE command was accepted SENT: TYPE A 200 Representation type is Ascii NonPrint SENT: SITE noasatrans 200 SITE command was accepted SENT: PORT 192,168,16,38,4,194 200 Port request OK. SENT: RETR 'BIRR.D196.T145616.LISTING' 550 Data set BIRR.D196.T145616.LISTING not found FTP Get failed 550 Data set BIRR.D196.T145616.LISTING not found Christian -Ursprüngliche Nachricht- Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] Im Auftrag von Boris Lenz Gesendet: Mittwoch, 16. Juli 2014 11:49 An: IBM-MAIN@LISTSERV.UA.EDU Betreff: Re: RMF Spreadsheet Reporter Any special characters like $ @ # in the userid? Regards, Boris On Tue, July 15, 2014 21:02, Christian Birr wrote: I'll do that tomorrow; I'm on CET and on duty since 5:00, need some sleep. My hope was that someone of RMF/Böblingen would chime in. Thanks Christian -- 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 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
AW: RMF Spreadsheet Reporter
No, not at all. And I don't agree with Shane, report selection and JCL run fine and after retrieving the reports manually with FTP everything works perfect in RMF PP. The only culprit is the internal FTP not working. Here is an extract of the FTP log: SENT: USER BIRR 331 Send password please. SENT: PASS (*hidden*) 230 BIRR is logged on. Working directory is "BIRR.". SENT: SYST 215 MVS is the operating system of this server. FTP Server is running on z/OS. SENT: PWD 257 "'BIRR.'" is working directory. SENT: CWD 'BIRR' 250 "BIRR." is the working directory name prefix. SENT: PWD 257 "'BIRR.'" is working directory. SENT: site retpd 200 SITE command was accepted SENT: site autorecall 200 SITE command was accepted SENT: TYPE A 200 Representation type is Ascii NonPrint SENT: SITE noasatrans 200 SITE command was accepted SENT: PORT 192,168,16,38,4,194 200 Port request OK. SENT: RETR 'BIRR.D196.T145616.LISTING' 550 Data set BIRR.D196.T145616.LISTING not found FTP Get failed 550 Data set BIRR.D196.T145616.LISTING not found Christian -Ursprüngliche Nachricht- Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] Im Auftrag von Boris Lenz Gesendet: Mittwoch, 16. Juli 2014 11:49 An: IBM-MAIN@LISTSERV.UA.EDU Betreff: Re: RMF Spreadsheet Reporter Any special characters like $ @ # in the userid? Regards, Boris On Tue, July 15, 2014 21:02, Christian Birr wrote: > I'll do that tomorrow; I'm on CET and on duty since 5:00, need some sleep. > My hope was that someone of RMF/Böblingen would chime in. > Thanks > Christian -- 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 Reporter
Any special characters like $ @ # in the userid? Regards, Boris On Tue, July 15, 2014 21:02, Christian Birr wrote: > I'll do that tomorrow; I'm on CET and on duty since 5:00, need some sleep. > My hope was that someone of RMF/Böblingen would chime in. > Thanks > Christian -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: AW: RMF Spreadsheet Reporter
On Tue, 15 Jul 2014 19:21:36 +0200, Christian Birr wrote: >Thanks Lizette >Yes, I did, that's where I got the error msgs from. I'm on the latest release >(on both sides). I simply have no clue where to look else. I've being working >on that for a couple of days now. No messages in syslog on z/OS, no RACF >messages either, the jobs are submitted and run, the output file is created >and then the reported errors, so the communication between WS and z/OS should >be ok. The RMF spreadsheet reporter package is broken - simple as that. We seem to get these threads every 18 months or so - and all the sites that have working setups can't understand why new environments don't work just like theirs. You *cannot* just use the GUI to build the JCL and expect it to work. Yes I know it seems that's what the thing is supposed to be for - amongst other things. Last site I was at I gave up and we decided EasySMF was a better option. Comes with a free trial, and the developer is a subscriber here. Shane ... -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
AW: RMF Spreadsheet Reporter
I'll do that tomorrow; I'm on CET and on duty since 5:00, need some sleep. My hope was that someone of RMF/Böblingen would chime in. Thanks Christian -Ursprüngliche Nachricht- Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] Im Auftrag von Lizette Koehler Gesendet: Dienstag, 15. Juli 2014 20:13 An: IBM-MAIN@LISTSERV.UA.EDU Betreff: Re: RMF Spreadsheet Reporter Try sending a request to this email address r...@de.ibm.com Lizette > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Christian Birr > Sent: Tuesday, July 15, 2014 10:22 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: AW: RMF Spreadsheet Reporter > > Thanks Lizette > Yes, I did, that's where I got the error msgs from. I'm on the latest release (on both > sides). I simply have no clue where to look else. I've being working on that for a > couple of days now. No messages in syslog on z/OS, no RACF messages either, > the jobs are submitted and run, the output file is created and then the reported > errors, so the communication between WS and z/OS should be ok. > Christian > > -Ursprüngliche Nachricht- > Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] Im > Auftrag von Lizette Koehler > Gesendet: Dienstag, 15. Juli 2014 17:49 > An: IBM-MAIN@LISTSERV.UA.EDU > Betreff: Re: RMF Spreadsheet Reporter > > There should be an FTP Log on the Java app. Did you check that? > > Lizette > > > > -Original Message- > > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] > > On Behalf Of Christian Birr > > Sent: Tuesday, July 15, 2014 8:08 AM > > To: IBM-MAIN@LISTSERV.UA.EDU > > Subject: RMF Spreadsheet Reporter > > > > Hi list, > > I do have difficulties to FTP resulting output dataset from z/OS back > > to > my > > workstation. The postprocessor und reports are just running fine and > > the > listing > > dataset is created. But when trying to retrieve the dataset back to my > workstation, I > > get 505 RETR 'userid.D.T.LISTING', dataset not found and 505 > > GET error. What am I missing? Are there any special ports to be opened > > on my > WinXp > > workstation firewall? Docs contain no hints and a manual FTP just > > works > fine. TIA > > Christian > > > -- 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 Reporter
Try sending a request to this email address r...@de.ibm.com Lizette > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Christian Birr > Sent: Tuesday, July 15, 2014 10:22 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: AW: RMF Spreadsheet Reporter > > Thanks Lizette > Yes, I did, that's where I got the error msgs from. I'm on the latest release (on both > sides). I simply have no clue where to look else. I've being working on that for a > couple of days now. No messages in syslog on z/OS, no RACF messages either, > the jobs are submitted and run, the output file is created and then the reported > errors, so the communication between WS and z/OS should be ok. > Christian > > -Ursprüngliche Nachricht- > Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] Im > Auftrag von Lizette Koehler > Gesendet: Dienstag, 15. Juli 2014 17:49 > An: IBM-MAIN@LISTSERV.UA.EDU > Betreff: Re: RMF Spreadsheet Reporter > > There should be an FTP Log on the Java app. Did you check that? > > Lizette > > > > -Original Message- > > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] > > On Behalf Of Christian Birr > > Sent: Tuesday, July 15, 2014 8:08 AM > > To: IBM-MAIN@LISTSERV.UA.EDU > > Subject: RMF Spreadsheet Reporter > > > > Hi list, > > I do have difficulties to FTP resulting output dataset from z/OS back > > to > my > > workstation. The postprocessor und reports are just running fine and > > the > listing > > dataset is created. But when trying to retrieve the dataset back to my > workstation, I > > get 505 RETR 'userid.D.T.LISTING', dataset not found and 505 > > GET error. What am I missing? Are there any special ports to be opened > > on my > WinXp > > workstation firewall? Docs contain no hints and a manual FTP just > > works > fine. TIA > > Christian > > > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
AW: RMF Spreadsheet Reporter
Thanks Lizette Yes, I did, that's where I got the error msgs from. I'm on the latest release (on both sides). I simply have no clue where to look else. I've being working on that for a couple of days now. No messages in syslog on z/OS, no RACF messages either, the jobs are submitted and run, the output file is created and then the reported errors, so the communication between WS and z/OS should be ok. Christian -Ursprüngliche Nachricht- Von: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] Im Auftrag von Lizette Koehler Gesendet: Dienstag, 15. Juli 2014 17:49 An: IBM-MAIN@LISTSERV.UA.EDU Betreff: Re: RMF Spreadsheet Reporter There should be an FTP Log on the Java app. Did you check that? Lizette > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Christian Birr > Sent: Tuesday, July 15, 2014 8:08 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: RMF Spreadsheet Reporter > > Hi list, > I do have difficulties to FTP resulting output dataset from z/OS back to my > workstation. The postprocessor und reports are just running fine and the listing > dataset is created. But when trying to retrieve the dataset back to my workstation, I > get 505 RETR 'userid.D.T.LISTING', dataset not found and 505 GET > error. What am I missing? Are there any special ports to be opened on my WinXp > workstation firewall? Docs contain no hints and a manual FTP just works fine. TIA > Christian > -- 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 Reporter
There should be an FTP Log on the Java app. Did you check that? Lizette > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Christian Birr > Sent: Tuesday, July 15, 2014 8:08 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: RMF Spreadsheet Reporter > > Hi list, > I do have difficulties to FTP resulting output dataset from z/OS back to my > workstation. The postprocessor und reports are just running fine and the listing > dataset is created. But when trying to retrieve the dataset back to my workstation, I > get 505 RETR 'userid.D.T.LISTING', dataset not found and 505 GET > error. What am I missing? Are there any special ports to be opened on my WinXp > workstation firewall? Docs contain no hints and a manual FTP just works fine. TIA > Christian > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
RMF Spreadsheet Reporter
Hi list, I do have difficulties to FTP resulting output dataset from z/OS back to my workstation. The postprocessor und reports are just running fine and the listing dataset is created. But when trying to retrieve the dataset back to my workstation, I get 505 RETR 'userid.D.T.LISTING', dataset not found and 505 GET error. What am I missing? Are there any special ports to be opened on my WinXp workstation firewall? Docs contain no hints and a manual FTP just works fine. TIA Christian -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: rmf spreadsheet reporter v1 r12 and microsoft excel 2010?
I have no problems using the RMF Spreadsheet Reporter with Excel 2010. Mike Schmutzok Sr. z/OS Systems Programmer UF & Shands HealthCare -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Kenneth Klein (TEMA TPC) Sent: Monday, February 25, 2013 2:13 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: rmf spreadsheet reporter v1 r12 and microsoft excel 2010? Is excel 2007 the highest level that the spreadsheet reporter supports? -- 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
rmf spreadsheet reporter v1 r12 and microsoft excel 2010?
Is excel 2007 the highest level that the spreadsheet reporter supports? -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: RMF Spreadsheet Reporter
well---found problem... went back to just select from weekly files I had.. found a weekly that was corrupted ... think there may have been a rerun and no one said anything.. took 5wk's into sort using below...then took that output as input to creating working set...and it worked.. INCLUDE COND=(06,1,BI,GE,X'46',AND,06,1,BI,LE,X'4F') SORT FIELDS=(11,4,CH,A,7,4,CH,A),EQUALS MODS E15=(ERBPPE15,36000,,N),E35=(ERBPPE35,3000,,N) my next question and hopefully someone has already done this...so recreating a wheel is not necessary... jcl(batch) to create the files needed for working sets and ovr files... as well where to ftp them into---DIR's? as for what reports to generaterather get all of them...and select what I don't want later From: Elardus Engelbrecht To: IBM-MAIN@LISTSERV.UA.EDU Date: 12/04/2012 01:15 AM Subject: Re: RMF Spreadsheet Reporter Sent by:IBM Mainframe Discussion List Ron Wells wrote: > DATE(11012012,11302012) > RTOD(,2400) > ETOD(,2400) > STOD(,2400) > DINTV(0800) Please post the dates, quantity and type of records read as collected. >putting sort smf in place...not sure what it does...hoping will put in seq. and elim. any bad recs.. Please post the SORT job and results. RMF is absolutely very picky about the correct sequence of its input. >using the orig. month files that gave me problems... One or many LPARs? On what z/OS level are you? Groete / Greetings Elardus Engelbrecht -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Email Disclaimer This E-mail contains confidential information belonging to the sender, which may be legally privileged information. This information is intended only for the use of the individual or entity addressed above. If you are not the intended recipient, or an employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on the contents of the E-mail or attached files is strictly prohibited. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: RMF Spreadsheet Reporter
Found problem...had a week/rmf tape that was bad sorted using the sort parm's INCLUDE COND=(06,1,BI,GE,X'46',AND,06,1,BI,LE,X'4F') SORT FIELDS=(11,4,CH,A,7,4,CH,A),EQUALS MODS E15=(ERBPPE15,36000,,N),E35=(ERBPPE35,3000,,N) took output (batch) into run and able to get the data.. next question.. anyone have batch run to generate all the reports? seems time consuming to keep asking for reports...think they should default all reports and default input without needing to keep putting in same file/smf-rmf as input.. option to change---sure--but jumping around not making sense.. maybe just me... lol From: Elardus Engelbrecht To: IBM-MAIN@LISTSERV.UA.EDU Date: 12/04/2012 01:15 AM Subject: Re: RMF Spreadsheet Reporter Sent by:IBM Mainframe Discussion List Ron Wells wrote: > DATE(11012012,11302012) > RTOD(,2400) > ETOD(,2400) > STOD(,2400) > DINTV(0800) Please post the dates, quantity and type of records read as collected. >putting sort smf in place...not sure what it does...hoping will put in seq. and elim. any bad recs.. Please post the SORT job and results. RMF is absolutely very picky about the correct sequence of its input. >using the orig. month files that gave me problems... One or many LPARs? On what z/OS level are you? Groete / Greetings Elardus Engelbrecht -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Email Disclaimer This E-mail contains confidential information belonging to the sender, which may be legally privileged information. This information is intended only for the use of the individual or entity addressed above. If you are not the intended recipient, or an employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on the contents of the E-mail or attached files is strictly prohibited. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: RMF Spreadsheet Reporter
Ron Wells wrote: > DATE(11012012,11302012) > RTOD(,2400) > ETOD(,2400) > STOD(,2400) > DINTV(0800) Please post the dates, quantity and type of records read as collected. >putting sort smf in place...not sure what it does...hoping will put in seq. >and elim. any bad recs.. Please post the SORT job and results. RMF is absolutely very picky about the correct sequence of its input. >using the orig. month files that gave me problems... One or many LPARs? On what z/OS level are you? Groete / Greetings Elardus Engelbrecht -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: RMF Spreadsheet Reporter
Steve 1,2,3,4th ?? <> did each week smf tape separately.. report listing showed follwing.. (wk(0) has 11/24-30 wk(-1) has 11/17-24 wk(-2) has 11/10-17 wk(-3) has 11/3-4 wk(-4) has 11/3-4?? wk(-5) has no Nov data>> according to rmfpp... ran test with -5 -4 -2 -1 and (0) as inputbatch >> it ran ok and seems all data there...at least date wise..per the report listing putting sort smf in place...not sure what it does...hoping will put in seq. and elim. any bad recs.. using the orig. month files that gave me problems... let ya know what gives.. From: Steve Conway To: IBM-MAIN@LISTSERV.UA.EDU Date: 12/03/2012 01:13 PM Subject:Re: RMF Spreadsheet Reporter Sent by:IBM Mainframe Discussion List Hi, Ron. Which days are you getting? I mean, it IS the 3rd of December. :-) I would verify which dates I was specifying, and what dates the data are on the input files. Cheers,,,Steve Steven F. Conway, CISSP LA Systems z/OS Systems Support Phone: 703.295.1926 steve_con...@ao.uscourts.gov From: Ron Wells To: IBM-MAIN@LISTSERV.UA.EDU Date: 12/03/2012 11:59 AM Subject:Re: RMF Spreadsheet Reporter Sent by:IBM Mainframe Discussion List something strange going on... trying to select from my monthly rmf..whole month...only getting 4days ?? not seeing anything in doc I need to cleanup anything..delete.. I have called all my datasets/local and remote diff. names just incase...same results... went back against my weekly rmf..same results there too... ? From: Lizette Koehler To: IBM-MAIN@LISTSERV.UA.EDU Date: 11/28/2012 08:36 AM Subject:Re: RMF Spreadsheet Reporter Sent by:IBM Mainframe Discussion List I have not followed this thread as well as I should, so I apologize if this information has been covered Have the Share Presentations on RMF Spreadsheet Reporter been of any assistance? For example http://www-03.ibm.com/support/techdocs/atsmastr.nsf/c6192fb3a432612485256d97 0082de57/fbfd446e23654daf862576f60075f401/%24FILE/RMF%20Overview%20Records%2 0and%20Use%20with%20the%20RMF%20Spreadsheet%20Reporter.pdf or Tiny URL http://tinyurl.com/chbd3zj Or this link: https://share.confex.com/share/115/webprogram/Handout/Session7763/Latest&Gre atest.pdf Lizette > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf > Of Ron Wells > Sent: Sunday, November 25, 2012 11:27 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: RMF Spreadsheet Reporter > > tks for reply...sent ya another---questions ... workload/seervice reporting...who > too's..and altering duration of reporting ..red book sort of helpful but missing setup or > something to change either.. > > > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Email Disclaimer This E-mail contains confidential information belonging to the sender, which may be legally privileged information. This information is intended only for the use of the individual or entity addressed above. If you are not the intended recipient, or an employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on the contents of the E-mail or attached files is strictly prohibited. -- 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 -- Email Disclaimer This E-mail contains confidential information belonging to the sender, which may be legally privileged information. This information is intended only for the use of the individual or entity addressed above. If you are not the intended recipient, or an employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on the contents of the E-mail or attached files is strictly prohibited. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: RMF Spreadsheet Reporter
Hi, Ron. Which days are you getting? I mean, it IS the 3rd of December. :-) I would verify which dates I was specifying, and what dates the data are on the input files. Cheers,,,Steve Steven F. Conway, CISSP LA Systems z/OS Systems Support Phone: 703.295.1926 steve_con...@ao.uscourts.gov From: Ron Wells To: IBM-MAIN@LISTSERV.UA.EDU Date: 12/03/2012 11:59 AM Subject:Re: RMF Spreadsheet Reporter Sent by:IBM Mainframe Discussion List something strange going on... trying to select from my monthly rmf..whole month...only getting 4days ?? not seeing anything in doc I need to cleanup anything..delete.. I have called all my datasets/local and remote diff. names just incase...same results... went back against my weekly rmf..same results there too... ? From: Lizette Koehler To: IBM-MAIN@LISTSERV.UA.EDU Date: 11/28/2012 08:36 AM Subject:Re: RMF Spreadsheet Reporter Sent by:IBM Mainframe Discussion List I have not followed this thread as well as I should, so I apologize if this information has been covered Have the Share Presentations on RMF Spreadsheet Reporter been of any assistance? For example http://www-03.ibm.com/support/techdocs/atsmastr.nsf/c6192fb3a432612485256d97 0082de57/fbfd446e23654daf862576f60075f401/%24FILE/RMF%20Overview%20Records%2 0and%20Use%20with%20the%20RMF%20Spreadsheet%20Reporter.pdf or Tiny URL http://tinyurl.com/chbd3zj Or this link: https://share.confex.com/share/115/webprogram/Handout/Session7763/Latest&Gre atest.pdf Lizette > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf > Of Ron Wells > Sent: Sunday, November 25, 2012 11:27 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: RMF Spreadsheet Reporter > > tks for reply...sent ya another---questions ... workload/seervice reporting...who > too's..and altering duration of reporting ..red book sort of helpful but missing setup or > something to change either.. > > > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Email Disclaimer This E-mail contains confidential information belonging to the sender, which may be legally privileged information. This information is intended only for the use of the individual or entity addressed above. If you are not the intended recipient, or an employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on the contents of the E-mail or attached files is strictly prohibited. -- 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 Reporter
something strange going on... trying to select from my monthly rmf..whole month...only getting 4days ?? not seeing anything in doc I need to cleanup anything..delete.. I have called all my datasets/local and remote diff. names just incase...same results... went back against my weekly rmf..same results there too... ? From: Lizette Koehler To: IBM-MAIN@LISTSERV.UA.EDU Date: 11/28/2012 08:36 AM Subject:Re: RMF Spreadsheet Reporter Sent by:IBM Mainframe Discussion List I have not followed this thread as well as I should, so I apologize if this information has been covered Have the Share Presentations on RMF Spreadsheet Reporter been of any assistance? For example http://www-03.ibm.com/support/techdocs/atsmastr.nsf/c6192fb3a432612485256d97 0082de57/fbfd446e23654daf862576f60075f401/%24FILE/RMF%20Overview%20Records%2 0and%20Use%20with%20the%20RMF%20Spreadsheet%20Reporter.pdf or Tiny URL http://tinyurl.com/chbd3zj Or this link: https://share.confex.com/share/115/webprogram/Handout/Session7763/Latest&Gre atest.pdf Lizette > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf > Of Ron Wells > Sent: Sunday, November 25, 2012 11:27 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: RMF Spreadsheet Reporter > > tks for reply...sent ya another---questions ... workload/seervice reporting...who > too's..and altering duration of reporting ..red book sort of helpful but missing setup or > something to change either.. > > > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Email Disclaimer This E-mail contains confidential information belonging to the sender, which may be legally privileged information. This information is intended only for the use of the individual or entity addressed above. If you are not the intended recipient, or an employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on the contents of the E-mail or attached files is strictly prohibited. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: RMF Spreadsheet Reporter
tks for reply... was asking question as to how you did the batch... like where the parm's/control card info was stored...see the batch it submits..gather it is getting the info from somewhere.. From: Shane Ginnane To: IBM-MAIN@LISTSERV.UA.EDU Date: 11/28/2012 03:51 AM Subject: Re: RMF Spreadsheet Reporter Sent by:IBM Mainframe Discussion List Sorry Ron, are you making a statement or asking a question ?. As it happens I didn't progress much, despite trying several iterations of (z/OS) batch machinations, both before and after that post of mine you quoted. Interesting that this client has a working monthly report - modifying that caused it to break also ... I needed to put something in place that would be useful when I left. The reporter just doesn't cut it any more IMHO. I suspect Andrew may have a new customer soon. Shane ... On Tue, 27 Nov 2012 06:59:54 -0600, Ron Wells wrote: >Shane >you have an example of what ys did for batch processing...as what is >needed and not needed from all the jcl and STUFF generated.. >gather the rmfpp parms can then be altered without jumping around in the >gui mess. > >yes...seems strange the way it is setup...would be nice to reclac the >intervals for weekly/monthly roll up reporting by the service classes -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Email Disclaimer This E-mail contains confidential information belonging to the sender, which may be legally privileged information. This information is intended only for the use of the individual or entity addressed above. If you are not the intended recipient, or an employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on the contents of the E-mail or attached files is strictly prohibited. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: RMF Spreadsheet Reporter
Sorry Ron, are you making a statement or asking a question ?. As it happens I didn't progress much, despite trying several iterations of (z/OS) batch machinations, both before and after that post of mine you quoted. Interesting that this client has a working monthly report - modifying that caused it to break also ... I needed to put something in place that would be useful when I left. The reporter just doesn't cut it any more IMHO. I suspect Andrew may have a new customer soon. Shane ... On Tue, 27 Nov 2012 06:59:54 -0600, Ron Wells wrote: >Shane >you have an example of what ys did for batch processing...as what is >needed and not needed from all the jcl and STUFF generated.. >gather the rmfpp parms can then be altered without jumping around in the >gui mess. > >yes...seems strange the way it is setup...would be nice to reclac the >intervals for weekly/monthly roll up reporting by the service classes -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: RMF Spreadsheet Reporter
Shane you have an example of what ys did for batch processing...as what is needed and not needed from all the jcl and STUFF generated.. gather the rmfpp parms can then be altered without jumping around in the gui mess. yes...seems strange the way it is setup...would be nice to reclac the intervals for weekly/monthly roll up reporting by the service classes From: Shane Ginnane To: IBM-MAIN@LISTSERV.UA.EDU Date: 11/21/2012 02:53 AM Subject:Re: RMF Spreadsheet Reporter Sent by:IBM Mainframe Discussion List Having spent several hours trying to make this product work, the only conclusion I can come to is it is an absolute farce. Totally and utterly unuseable as shipped nowadays. I, like many others on the list, have used this in the past and managed to get some graphs out after floundering around in excel. Not any more. You still get to flounder around, but the result is always the mentioned zero length file. *IF* you get that far. I set aside some time to try and get this finally working so I could publish some graphs for the masses. The GUI is useless - I was unable to ever get it to produce a batch job that was of any use at all. Period. Eventually I went for the (as in MSDOS) "batch option". Update some options, kick it off, publish the graphs. Right ... At least you get some OVW sysin that happens to produce the output you need to generate the worksheet. If you don't blow the ridiculously small space on the generated JCL, and you don't want to use date/time environment variables in filenames (as MSDOS output) ... An MSDOS bat file that goes off and calls java that produces a file to be separately fed into excel. Hello ... who thinks this stuff up ?. Lots of "fun", but I think I can get what I need sometime tomorrow. Maybe. I wouldn't even call this "broken as designed" Shane ... On Sun, 30 Sep 2012 13:58:42 +0530, saurabh khandelwal wrote: >Hello, > I am trying to create overview record using Create >option. But I am getting below error > >*The returned File has zero Length. Check the remote dataset or review the >Post processor for Parameter for detail. >Please refer to RMF postprocessor Message for detail.* > >When I tried checking postprocessor job log, I didnt find any issue. But >After the Job run, I don't see any dataset created RMF.D273.T220125.OVWREC. > >I dont suspect the SMF dump dataset is corrupted. Please suggest. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Email Disclaimer This E-mail contains confidential information belonging to the sender, which may be legally privileged information. This information is intended only for the use of the individual or entity addressed above. If you are not the intended recipient, or an employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on the contents of the E-mail or attached files is strictly prohibited. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: RMF Spreadsheet Reporter
On Fri, 23 Nov 2012 16:40:13 +1100, Andrew Rowley wrote: >If you don't already have a SMF reporting product, EasySMF will provide >a lot of useful information and could be all you need. If you currently >use MXG or a similar product, EasySMF will hopefully also provide a lot >of useful information, but I do not claim it is a direct replacement for >your current product. Andrew can sell his own product, but it certainly looks o.k. on my brief usage. Has some wrinkles, but what software doesn't. Shane ... -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: RMF Spreadsheet Reporter
On 23/11/2012 7:52 PM, Cobe Xu wrote: Hi Andrew, I may propose to my management for a EasySMF for my PC. Is that I should go for single user/PC key? Any limitation on managed/processed LPARs SMF? As I have several z-boxes, which running over 50 Lpars. In this case, still $595/year? If you are the only person who would be using it, yes it is $595 per year. However with 50 LPARs you might find that you have more than one person who would find it useful, and a single license might be false economy. 5 user and 10 user licenses are available at a reduced price per user. Feel free to contact me off-list for more information, or see the pricing details on the website: https://www.blackhillsoftware.com/order-easysmf.html Regards Andrew Rowley -- and...@blackhillsoftware.com +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
Re: RMF Spreadsheet Reporter
mean how too's ... nimble fingers... From: Ron Wells To: IBM-MAIN@LISTSERV.UA.EDU Date: 11/25/2012 12:27 PM Subject: Re: RMF Spreadsheet Reporter Sent by:IBM Mainframe Discussion List tks for reply...sent ya another---questions ... workload/seervice reporting...who too's..and altering duration of reporting ..red book sort of helpful but missing setup or something to change either.. From: Ed Finnell To: IBM-MAIN@LISTSERV.UA.EDU Date: 11/21/2012 01:34 PM Subject: Re: RMF Spreadsheet Reporter Sent by:IBM Mainframe Discussion List Yeah I just glommed the generated JCL and ran a pre-STEP to filter only the RMF records(type70-79) and XMITIP'd it to my ownself. Very folder centric so save it in the Reports folder and do the conversion. The HELP was very useful. In a message dated 11/21/2012 11:20:18 A.M. Central Standard Time, ron.we...@slfs.com writes: you happen to try and work jcl to do this creating working set(s) from batch instead of all the hopping around..in menus?? -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Email Disclaimer This E-mail contains confidential information belonging to the sender, which may be legally privileged information. This information is intended only for the use of the individual or entity addressed above. If you are not the intended recipient, or an employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on the contents of the E-mail or attached files is strictly prohibited. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Email Disclaimer This E-mail contains confidential information belonging to the sender, which may be legally privileged information. This information is intended only for the use of the individual or entity addressed above. If you are not the intended recipient, or an employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on the contents of the E-mail or attached files is strictly prohibited. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: RMF Spreadsheet Reporter
tks for reply...sent ya another---questions ... workload/seervice reporting...who too's..and altering duration of reporting ..red book sort of helpful but missing setup or something to change either.. From: Ed Finnell To: IBM-MAIN@LISTSERV.UA.EDU Date: 11/21/2012 01:34 PM Subject: Re: RMF Spreadsheet Reporter Sent by:IBM Mainframe Discussion List Yeah I just glommed the generated JCL and ran a pre-STEP to filter only the RMF records(type70-79) and XMITIP'd it to my ownself. Very folder centric so save it in the Reports folder and do the conversion. The HELP was very useful. In a message dated 11/21/2012 11:20:18 A.M. Central Standard Time, ron.we...@slfs.com writes: you happen to try and work jcl to do this creating working set(s) from batch instead of all the hopping around..in menus?? -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Email Disclaimer This E-mail contains confidential information belonging to the sender, which may be legally privileged information. This information is intended only for the use of the individual or entity addressed above. If you are not the intended recipient, or an employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on the contents of the E-mail or attached files is strictly prohibited. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: RMF Spreadsheet Reporter
Hi Andrew, I may propose to my management for a EasySMF for my PC. Is that I should go for single user/PC key? Any limitation on managed/processed LPARs SMF? As I have several z-boxes, which running over 50 Lpars. In this case, still $595/year? On Fri, Nov 23, 2012 at 1:40 PM, Andrew Rowley wrote: > On 23/11/2012 4:06 AM, Ed Finnell wrote: > >> Is there a cost comparison vs SAS/MXG on PC? >> > > The cost of EasySMF is $595 per user or $795 per LPAR for a site license, > for a 12 month subscription. In both cases there are discounts for multiple > licenses. No other software is required (except for Windows itself). MXG I > think publish their price on their website. I don't know the cost of SAS. > > However, EasySMF is different to MXG and I don't claim it is a replacement > for MXG. Unless you are only a light MXG user you would probably find that > it didn't have MXG functions you were used to. > > The idea behind EasySMF was to create a product that would be valuable > even if you already have MXG or similar software, and to make SMF data > accessible outside the groups that traditionally have the MXG and SAS > skills. > > At every site I have worked there have been groups that would have found > SMF information useful, but had no way to use it either due to no tools or > no SAS skills. Ops analysts/schedulers, storage management and even systems > programmers. > > EasySMF is designed with more of a focus on problem solving than capacity > planning. It is designed to help answer questions, and follow a thread > through your SMF data where initially you may not know exactly what you are > looking for. If you are investigating a problem you can move from one > report to another without having to break your train of thought to code up > a different report. > > For example, you might look at all service classes, then details for a > particular service class, a specific job in the service class, the history > of that job, the datasets it used etc. As you move to different reports > from different record types the filtering (service class, job etc.) is > maintained. > > If you don't already have a SMF reporting product, EasySMF will provide a > lot of useful information and could be all you need. If you currently use > MXG or a similar product, EasySMF will hopefully also provide a lot of > useful information, but I do not claim it is a direct replacement for your > current product. > > "A replacement for MXG & SAS" is probably a simpler marketing message, but > I think it would result in less satisfied customers. > > Regards > > Andrew Rowley > > > -- > and...@blackhillsoftware.com > +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 > -- Cobe Xu Best Regards --- z/OS Performance & Capacity Analyst z/OS System Programmer Email: cob...@gmail.com --- -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: RMF Spreadsheet Reporter
On 23/11/2012 4:06 AM, Ed Finnell wrote: Is there a cost comparison vs SAS/MXG on PC? The cost of EasySMF is $595 per user or $795 per LPAR for a site license, for a 12 month subscription. In both cases there are discounts for multiple licenses. No other software is required (except for Windows itself). MXG I think publish their price on their website. I don't know the cost of SAS. However, EasySMF is different to MXG and I don't claim it is a replacement for MXG. Unless you are only a light MXG user you would probably find that it didn't have MXG functions you were used to. The idea behind EasySMF was to create a product that would be valuable even if you already have MXG or similar software, and to make SMF data accessible outside the groups that traditionally have the MXG and SAS skills. At every site I have worked there have been groups that would have found SMF information useful, but had no way to use it either due to no tools or no SAS skills. Ops analysts/schedulers, storage management and even systems programmers. EasySMF is designed with more of a focus on problem solving than capacity planning. It is designed to help answer questions, and follow a thread through your SMF data where initially you may not know exactly what you are looking for. If you are investigating a problem you can move from one report to another without having to break your train of thought to code up a different report. For example, you might look at all service classes, then details for a particular service class, a specific job in the service class, the history of that job, the datasets it used etc. As you move to different reports from different record types the filtering (service class, job etc.) is maintained. If you don't already have a SMF reporting product, EasySMF will provide a lot of useful information and could be all you need. If you currently use MXG or a similar product, EasySMF will hopefully also provide a lot of useful information, but I do not claim it is a direct replacement for your current product. "A replacement for MXG & SAS" is probably a simpler marketing message, but I think it would result in less satisfied customers. Regards Andrew Rowley -- and...@blackhillsoftware.com +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
Re: RMF Spreadsheet Reporter
Is there a cost comparison vs SAS/MXG on PC? In a message dated 11/22/2012 2:17:16 A.M. Central Standard Time, ibm-m...@tpg.com.au writes: Thanks Andrew, you saved me a search. I've seen your previous posts, but never had a need to look at it till now -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: RMF Spreadsheet Reporter
On Thu, 22 Nov 2012 10:20:33 +1100, Andrew Rowley wrote: >You might be interested in EasySMF: Thanks Andrew, you saved me a search. I've seen your previous posts, but never had a need to look at it till now. Shane ... -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: RMF Spreadsheet Reporter
On 22/11/2012 3:20 PM, Cobe Xu wrote: EasySMF, a good name make me excite for 10 sec, until I see '30 day trial'.. It's not free, if that is what you are suggesting, but not many people can afford to work for free. It is not expensive - at systems programmer rates it probably pays for itself if it saves a day of fiddling around trying to get the information some other way. And if you can get all you need in the 30 day trial period, it is effectively free. The 30 day trial means you can download it and try it out now, without registering for an account, talking to a salesman etc. Assuming you can install software on your PC, you can be using it in minutes. Not a bad thing - but perhaps unusual in the z/OS world. Regards Andrew Rowley -- and...@blackhillsoftware.com +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
Re: RMF Spreadsheet Reporter
EasySMF, a good name make me excite for 10 sec, until I see '30 day trial'.. On Thu, Nov 22, 2012 at 7:20 AM, Andrew Rowley wrote: > You might be interested in EasySMF: > http://www.smfreports.com > > You can view charts on your PC without going through the rigmarole of RMF > Spreadsheet Reporter. Right click on the charts to copy to the clipboard > and paste into other applications. > > I haven't used RMF Spreadsheet Reporter (I tried a long time ago, but the > process seemed so convoluted I was sure there was something I didn't > understand) but EasySMF has a few features that I don't think RMF > Spreadsheet reporter can do: > - Click through many of the reports to see related or more detailed > information > - Drag on charts to zoom in and get a more detailed view of interesting > time periods > - Use type 30 records to show you what was running on the system or in > particular service classes at the time. > > You can download a 30 day trial from: > http://www.smfreports.com/**download.html<http://www.smfreports.com/download.html> > > Regards > > Andrew Rowley > EasySMF Developer > > > > On 21/11/2012 7:34 PM, Shane Ginnane wrote: > >> Having spent several hours trying to make this product work, the only >> conclusion I can come to is it is an absolute farce. >> Totally and utterly unuseable as shipped nowadays. >> >> I, like many others on the list, have used this in the past and managed >> to get some graphs out after floundering around in excel. Not any more. You >> still get to flounder around, but the result is always the mentioned zero >> length file. >> *IF* you get that far. >> >> I set aside some time to try and get this finally working so I could >> publish some graphs for the masses. >> The GUI is useless - I was unable to ever get it to produce a batch job >> that was of any use at all. Period. >> Eventually I went for the (as in MSDOS) "batch option". Update some >> options, kick it off, publish the graphs. >> Right ... >> At least you get some OVW sysin that happens to produce the output you >> need to generate the worksheet. If you don't blow the ridiculously small >> space on the generated JCL, and you don't want to use date/time environment >> variables in filenames (as MSDOS output) ... >> An MSDOS bat file that goes off and calls java that produces a file to be >> separately fed into excel. Hello ... who thinks this stuff up ?. >> >> Lots of "fun", but I think I can get what I need sometime tomorrow. >> Maybe. >> >> I wouldn't even call this "broken as designed" >> >> Shane ... >> > > > > -- > and...@blackhillsoftware.com > +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 > -- Cobe Xu Best Regards --- z/OS Performance & Capacity Analyst z/OS System Programmer Email: cob...@gmail.com --- -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: RMF Spreadsheet Reporter
You might be interested in EasySMF: http://www.smfreports.com You can view charts on your PC without going through the rigmarole of RMF Spreadsheet Reporter. Right click on the charts to copy to the clipboard and paste into other applications. I haven't used RMF Spreadsheet Reporter (I tried a long time ago, but the process seemed so convoluted I was sure there was something I didn't understand) but EasySMF has a few features that I don't think RMF Spreadsheet reporter can do: - Click through many of the reports to see related or more detailed information - Drag on charts to zoom in and get a more detailed view of interesting time periods - Use type 30 records to show you what was running on the system or in particular service classes at the time. You can download a 30 day trial from: http://www.smfreports.com/download.html Regards Andrew Rowley EasySMF Developer On 21/11/2012 7:34 PM, Shane Ginnane wrote: Having spent several hours trying to make this product work, the only conclusion I can come to is it is an absolute farce. Totally and utterly unuseable as shipped nowadays. I, like many others on the list, have used this in the past and managed to get some graphs out after floundering around in excel. Not any more. You still get to flounder around, but the result is always the mentioned zero length file. *IF* you get that far. I set aside some time to try and get this finally working so I could publish some graphs for the masses. The GUI is useless - I was unable to ever get it to produce a batch job that was of any use at all. Period. Eventually I went for the (as in MSDOS) "batch option". Update some options, kick it off, publish the graphs. Right ... At least you get some OVW sysin that happens to produce the output you need to generate the worksheet. If you don't blow the ridiculously small space on the generated JCL, and you don't want to use date/time environment variables in filenames (as MSDOS output) ... An MSDOS bat file that goes off and calls java that produces a file to be separately fed into excel. Hello ... who thinks this stuff up ?. Lots of "fun", but I think I can get what I need sometime tomorrow. Maybe. I wouldn't even call this "broken as designed" Shane ... -- and...@blackhillsoftware.com +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
Re: RMF Spreadsheet Reporter
Yeah I just glommed the generated JCL and ran a pre-STEP to filter only the RMF records(type70-79) and XMITIP'd it to my ownself. Very folder centric so save it in the Reports folder and do the conversion. The HELP was very useful. In a message dated 11/21/2012 11:20:18 A.M. Central Standard Time, ron.we...@slfs.com writes: you happen to try and work jcl to do this creating working set(s) from batch instead of all the hopping around..in menus?? -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: RMF Spreadsheet Reporter
you happen to try and work jcl to do this creating working set(s) from batch instead of all the hopping around..in menus?? t From: Shane Ginnane To: IBM-MAIN@LISTSERV.UA.EDU Date: 11/21/2012 02:53 AM Subject:Re: RMF Spreadsheet Reporter Sent by:IBM Mainframe Discussion List Having spent several hours trying to make this product work, the only conclusion I can come to is it is an absolute farce. Totally and utterly unuseable as shipped nowadays. I, like many others on the list, have used this in the past and managed to get some graphs out after floundering around in excel. Not any more. You still get to flounder around, but the result is always the mentioned zero length file. *IF* you get that far. I set aside some time to try and get this finally working so I could publish some graphs for the masses. The GUI is useless - I was unable to ever get it to produce a batch job that was of any use at all. Period. Eventually I went for the (as in MSDOS) "batch option". Update some options, kick it off, publish the graphs. Right ... At least you get some OVW sysin that happens to produce the output you need to generate the worksheet. If you don't blow the ridiculously small space on the generated JCL, and you don't want to use date/time environment variables in filenames (as MSDOS output) ... An MSDOS bat file that goes off and calls java that produces a file to be separately fed into excel. Hello ... who thinks this stuff up ?. Lots of "fun", but I think I can get what I need sometime tomorrow. Maybe. I wouldn't even call this "broken as designed" Shane ... On Sun, 30 Sep 2012 13:58:42 +0530, saurabh khandelwal wrote: >Hello, > I am trying to create overview record using Create >option. But I am getting below error > >*The returned File has zero Length. Check the remote dataset or review the >Post processor for Parameter for detail. >Please refer to RMF postprocessor Message for detail.* > >When I tried checking postprocessor job log, I didnt find any issue. But >After the Job run, I don't see any dataset created RMF.D273.T220125.OVWREC. > >I dont suspect the SMF dump dataset is corrupted. Please suggest. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Email Disclaimer This E-mail contains confidential information belonging to the sender, which may be legally privileged information. This information is intended only for the use of the individual or entity addressed above. If you are not the intended recipient, or an employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on the contents of the E-mail or attached files is strictly prohibited. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: RMF Spreadsheet Reporter
Having spent several hours trying to make this product work, the only conclusion I can come to is it is an absolute farce. Totally and utterly unuseable as shipped nowadays. I, like many others on the list, have used this in the past and managed to get some graphs out after floundering around in excel. Not any more. You still get to flounder around, but the result is always the mentioned zero length file. *IF* you get that far. I set aside some time to try and get this finally working so I could publish some graphs for the masses. The GUI is useless - I was unable to ever get it to produce a batch job that was of any use at all. Period. Eventually I went for the (as in MSDOS) "batch option". Update some options, kick it off, publish the graphs. Right ... At least you get some OVW sysin that happens to produce the output you need to generate the worksheet. If you don't blow the ridiculously small space on the generated JCL, and you don't want to use date/time environment variables in filenames (as MSDOS output) ... An MSDOS bat file that goes off and calls java that produces a file to be separately fed into excel. Hello ... who thinks this stuff up ?. Lots of "fun", but I think I can get what I need sometime tomorrow. Maybe. I wouldn't even call this "broken as designed" Shane ... On Sun, 30 Sep 2012 13:58:42 +0530, saurabh khandelwal wrote: >Hello, > I am trying to create overview record using Create >option. But I am getting below error > >*The returned File has zero Length. Check the remote dataset or review the >Post processor for Parameter for detail. >Please refer to RMF postprocessor Message for detail.* > >When I tried checking postprocessor job log, I didnt find any issue. But >After the Job run, I don't see any dataset created RMF.D273.T220125.OVWREC. > >I dont suspect the SMF dump dataset is corrupted. Please suggest. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: RMF Spreadsheet Reporter Issue
Hello, I tried using Sample.Lis to create to working dataset and it worked fine. But when I try with real data, it always gives me error that not able to locate file in specified address as below. I have report listing name of MVS.RMF.D234.lis in local resource and file is placed in C:\Documents and Settings\saukhand\Application Data\RMF\RMF Spreadsheet Reporter\rmflistings. Please suggest. On Sun, Sep 30, 2012 at 1:56 AM, Ed Finnell wrote: > The Help is pretty good for each process. Back when we were running this, > new versions got pretty slack. Last time I tried it the File transfer thing > never would work and I couldn't get enough information to fix it(I think > Bob Shannon reported similar observations). The whole process is 'folder > based'. So once I got the sample thingy to work I just FTP'd the MVS > report > into the correct folder and everything was happy. I forget the limits of > EXCEL > but it runs out pretty quickly in a moderately sized environment. > > > In a message dated 9/29/2012 11:27:55 A.M. Central Daylight Time, > sourabhkhandelwal...@gmail.com writes: > > The underlying window says 'Transferring the Report Listing' and the > progress bar keeps cycling from blank to full. When I click on OK the > message changes to 'Process failed' > > > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- Thanks & Regards Saurabh Khandelwal -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: RMF Spreadsheet Reporter Issue
The Help is pretty good for each process. Back when we were running this, new versions got pretty slack. Last time I tried it the File transfer thing never would work and I couldn't get enough information to fix it(I think Bob Shannon reported similar observations). The whole process is 'folder based'. So once I got the sample thingy to work I just FTP'd the MVS report into the correct folder and everything was happy. I forget the limits of EXCEL but it runs out pretty quickly in a moderately sized environment. In a message dated 9/29/2012 11:27:55 A.M. Central Daylight Time, sourabhkhandelwal...@gmail.com writes: The underlying window says 'Transferring the Report Listing' and the progress bar keeps cycling from blank to full. When I click on OK the message changes to 'Process failed' -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
RMF Spreadsheet Reporter Issue
Hello Group, Does anyone know the solution to this problem? I've created a listing dataset on the host and when I try to create a working set from it I get a message window which says : Report for specified options cannot be found in Report Listing ... The underlying window says 'Transferring the Report Listing' and the progress bar keeps cycling from blank to full. When I click on OK the message changes to 'Process failed' I have noticed that same problem has been posted in IBM main before but not solution has been provided. Please suggest. -- Thanks & Regards Saurabh Khandelwal -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: RMF Spreadsheet Reporter
hired too many pc people only...have to give them something to do...to justify there positions. and all the education they have from MS U... From: Shane Ginnane To: IBM-MAIN@LISTSERV.UA.EDU Date: 09/26/2012 06:18 AM Subject:Re: RMF Spreadsheet Reporter Sent by:IBM Mainframe Discussion List H ... I must admit to a relationship with the reporter that swung from "ho-hum" to WTF . The current version is now a you-beaut java all-new-and-shiny interface. Rigt ... Having recently attempted a re-acquaintance with this tool, all I can say is not much has become more intuitive - in contrast to the claims of mentioned manual. Supposedly the tool can do it all for you now. But do as Al says, and run the batch PP job, and manually upload the data to your workstation. Then it may work. Surely IBM can come up with something better than a raft of excel macros - they even publish RMF APIs for gawds sake ... ! Shane ... On Tue, 25 Sep 2012 12:31:40 +, Staller, Allan wrote: >There is not much to configure here. It is pretty much canned. > >1) Download the current version from http://www-03.ibm.com/systems/z/os/zos/features/rmf/ >2) Run an RMF Post processor report and create overview records. >3) Download records and feed to Spreadsheet Reporter. > >Additional information here: >Chapter 7 topic 7.2 (watch the wrap) -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Email Disclaimer This E-mail contains confidential information belonging to the sender, which may be legally privileged information. This information is intended only for the use of the individual or entity addressed above. If you are not the intended recipient, or an employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on the contents of the E-mail or attached files is strictly prohibited. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: RMF Spreadsheet Reporter
H ... I must admit to a relationship with the reporter that swung from "ho-hum" to WTF . The current version is now a you-beaut java all-new-and-shiny interface. Rigt ... Having recently attempted a re-acquaintance with this tool, all I can say is not much has become more intuitive - in contrast to the claims of mentioned manual. Supposedly the tool can do it all for you now. But do as Al says, and run the batch PP job, and manually upload the data to your workstation. Then it may work. Surely IBM can come up with something better than a raft of excel macros - they even publish RMF APIs for gawds sake ... ! Shane ... On Tue, 25 Sep 2012 12:31:40 +, Staller, Allan wrote: >There is not much to configure here. It is pretty much canned. > >1) Download the current version from >http://www-03.ibm.com/systems/z/os/zos/features/rmf/ >2) Run an RMF Post processor report and create overview records. >3) Download records and feed to Spreadsheet Reporter. > >Additional information here: >Chapter 7 topic 7.2 (watch the wrap) -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: RMF Spreadsheet Reporter
I forgot, If you include SHARE at the front SHARE RMF SPREADSHEET REPORTER it should be some of the Share Presentations to the top. They should be very helpful. Lizette > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf > Of Lizette Koehler > > If you do an internet search for RMF SPREADSHEET REPORTER you should find many > links that can assist you > > Lizette > > > > -Original Message- > > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] > > On > Behalf > > Of Jake anderson > > Sent: Tuesday, September 25, 2012 4:42 AM > > To: IBM-MAIN@LISTSERV.UA.EDU > > Subject: RMF Spreadsheet Reporter > > > > Dear Group, > > I am looking for Sysplex resources (CF & > Structure) utilization report > > and for doing this I am trying to configure RMF Spread sheet reporter. > > I > tried > > following RMF user guide to configure but it didnt help me much as I > > am > new with this > > product. Till now I have filled my Mainframe host detail, for which > > I > want to get > > detail.Could someone please help shed some light on the above . > > > > Jake > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: RMF Spreadsheet Reporter
If you do an internet search for RMF SPREADSHEET REPORTER you should find many links that can assist you Lizette > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf > Of Jake anderson > Sent: Tuesday, September 25, 2012 4:42 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: RMF Spreadsheet Reporter > > Dear Group, > I am looking for Sysplex resources (CF & Structure) utilization report > and for doing this I am trying to configure RMF Spread sheet reporter. I tried > following RMF user guide to configure but it didnt help me much as I am new with this > product. Till now I have filled my Mainframe host detail, for which I want to get > detail.Could someone please help shed some light on the above . > > Jake -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: RMF Spreadsheet Reporter
There is not much to configure here. It is pretty much canned. 1) Download the current version from http://www-03.ibm.com/systems/z/os/zos/features/rmf/ 2) Run an RMF Post processor report and create overview records. 3) Download records and feed to Spreadsheet Reporter. Additional information here: http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ERBZUGB0/CCONTENTS?SHELF=erbzbkb0&DN=SC33-7990-19&DT=20110615130737 Chapter 7 topic 7.2 (watch the wrap) HTH, I am looking for Sysplex resources (CF & Structure) utilization report and for doing this I am trying to configure RMF Spread sheet reporter. I tried following RMF user guide to configure but it didnt help me much as I am new with this product. Till now I have filled my Mainframe host detail, for which I want to get detail.Could someone please help shed some light on the above . -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
RMF Spreadsheet Reporter
Dear Group, I am looking for Sysplex resources (CF & Structure) utilization report and for doing this I am trying to configure RMF Spread sheet reporter. I tried following RMF user guide to configure but it didnt help me much as I am new with this product. Till now I have filled my Mainframe host detail, for which I want to get detail.Could someone please help shed some light on the above . Jake -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
