RMF Spreadsheet Reporter
Hi folks I tried using RMF Spreadsheet Reporter today after having not used it for a month or two, and it's hanging on the FTP connection. This used to work before, so I can't understand what's going on. I have four LPARs I can connect to, all with exactly the same results. I know that at least two of the LPARs have not had any configuration changes whatsoever since last July. The FTP log shows: 220-FTPD1 IBM FTP CS V1R4 at NODE, 16:32:44 on 2005-12-14. 220 Connection will close if idle for more than 15 minutes. SENT: USER BRIAN 331 Send password please. SENT: PASS 230 BRIAN is logged on. Working directory is "BRIAN.". SENT: SYST 215 MVS is the operating system of this server. FTP Server is running on z/OS. SENT: PWD 257 "'BRIAN.'" is working directory. SENT: PORT 192,168,2,1,6,190 200 Port request OK. SENT: LIST java.net.SocketTimeoutException: Read timed out The read time out message is then repeated every 10 seconds or so until I cancel. It seems to be the LIST command, but I can't understand why this is being issued, where from, or why it wasn't issued/failing when I last used this. Anyone got any ideas? Anyone seen this before? Cheers Brian - This e-mail message is for the sole use of the intended recipient(s)and may contain confidential and privileged information of Transaction NetworkServices. Any unauthorized review, use, disclosure or distribution isprohibited. If you are not the intended recipient, please contact thesender by reply e-mail and destroy all copies of the original message. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
RMF Spreadsheet Reporter
Hello, I'm trying to get the RMF Spreadsheet reporter working and I am quite stumped. This is on Windows XP, Excel 2003. I have downloaded and installed the latest version of the reporter. It starts up OK, I define my SMF dump datasets. I Select Create->Workingset. The job runs successfully. The workingset shows up in the working sets folder on the local side. Then I select an excel spreadsheet to open. In the spreadsheet, click the button to 'Select Working Set and process Data...'.Then I get an error message box stating: 'No Working Set selected or no Working Set available'. Does anybody have any ideas what might be going on here? I can see the working sets in the correct directory, but I can't convince Excel that they are there... Thanks Dana -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
RMF Spreadsheet Reporter
Hello Listers, Does anyone know the string of options that should be passed when opening the Reporter with the following command: "C:\Program Files\RMF\RMF Spreadsheet Reporter\Ibmjava\jre\bin\javaws.exe" Regards, Dennis -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
RMF Spreadsheet Reporter
Hi all !!! Anybody know about to use the RMF Spreadsheet Reporter in windows and Host.I need to make a graphical reports based in RMF of CPU, DASD, STORAGE, PAGING and so on... Thanks any help Arueira /Barnack Support Team z/OS -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
RMF Spreadsheet Reporter
I am trying to run the RMF Spreadsheet Reporter for the first time in a while. I started by installing version 5.2.7 to my PC. I then defined a system and an SMF dataset. Then I'm trying to user the product to submit a job from my workstation to the mainframe. The job gets to the mainframe OK. However, there is no step in the job to sort the input SMF data even though there is one in the skeleton JCL in C:/Program Files/RMF/RMF Spreadsheet Reporter/Connect/RMFPP1.JCL on my workstation. Has anyone else run into a problem with RMF Spreadsheet Reporter dropping the sort step when it sends the job to the mainframe? Does anyone know what I might need to do to get the sort step included? Without it the RMF Post Processor just prints the message "ERB478I PPS: SMF RECORDS NOT SORTED" and terminates, so I get no reports, and then I get an error at the workstation end. Tom Kelman Enterprise Capacity Planner Commerce Bank of Kansas City (816) 760-7632 * If you wish to communicate securely with Commerce Bank and its affiliates, you must log into your account under Online Services at http://www.commercebank.com or use the Commerce Bank Secure Email Message Center at https://securemail.commercebank.com NOTICE: This electronic mail message and any attached files are confidential. The information is exclusively for the use of the individual or entity intended as the recipient. If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited. If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. * -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: RMF Spreadsheet Reporter
On Wed, 2005-12-14 at 16:56 +, Perryman, Brian wrote: > The FTP log shows: > SENT: LIST > java.net.SocketTimeoutException: Read timed out I've seen this happen if either (a) there's a MTU mismatch (see your plumbers about this), or (b) you're using an active (rather than passive) ftp connection. For the latter, try to insert a LOCSITE FWF in the command stream, which enables passive ftp. -- David Andrews A. Duda and Sons, Inc. [EMAIL PROTECTED] -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: RMF Spreadsheet Reporter
On 14 Dec 2005 08:56:49 -0800, [EMAIL PROTECTED] (Perryman, Brian) wrote: >I tried using RMF Spreadsheet Reporter today after having not used it for a >month or two, and it's hanging on the FTP connection. This used to work >before, so I can't understand what's going on. I have four LPARs I can connect >to, all with exactly the same results. I know that at least two of the LPARs >have not had any configuration changes whatsoever since last July. > >The FTP log shows: > >220-FTPD1 IBM FTP CS V1R4 at NODE, 16:32:44 on 2005-12-14. >220 Connection will close if idle for more than 15 minutes. > >SENT: USER BRIAN >331 Send password please. >SENT: PASS >230 BRIAN is logged on. Working directory is "BRIAN.". >SENT: SYST >215 MVS is the operating system of this server. FTP Server is running on z/OS. >SENT: PWD >257 "'BRIAN.'" is working directory. >SENT: PORT 192,168,2,1,6,190 >200 Port request OK. >SENT: LIST >java.net.SocketTimeoutException: Read timed out I don't know much about "RMF Spreadsheet Reporter" (I've never used it), but I'm assuming that it's some sort of package you run on a workstation, and uses FTP to retrieve data from the mainframe. The PORT command indicates that the FTP client (192.168.2.1) is waiting for a connection *from* the FTP server. This connection will be used to send the results of the LIST command back to the FTP client. Most likely, some sort of firewall on your workstation (or perhaps somewhere upstream of your workstation) is blocking inbound counnections into your workstation. You may need to try and configure the FTP client to use passive mode for data transfers. Have you installed any new security packages on your workstation (Norton Internet Security, McAfee, etc.???) Eric -- Eric Chevalier E-mail: [EMAIL PROTECTED] Web: www.tulsagrammer.com Is that call really worth your child's life? HANG UP AND DRIVE! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: RMF Spreadsheet Reporter
..one thing that might be relevant, the (first four) numbers in the PORT statement below do not match my target FTP server.. How do I interpret that line in the log please? SENT: PORT 192,168,2,1,6,190 200 Port request OK. Cheers Brian - This e-mail message is for the sole use of the intended recipient(s)and may contain confidential and privileged information of Transaction NetworkServices. Any unauthorized review, use, disclosure or distribution isprohibited. If you are not the intended recipient, please contact thesender by reply e-mail and destroy all copies of the original message. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: RMF Spreadsheet Reporter
Hello Does it time out the same number of minutes eg. 10 minutes. Your message is exactly the message I had gotten earlier this year. "java.net.SocketTimeoutException: Read timed out" I had a similar problem when retrieving large amounts of SMF records which caused the submitting job to run longer than 10 minutes. I needed to increase the FTP timeout interval from the default of 10 minutes. The default parameter coded below is the default, which may time you out after 10 minutes. JESPUTGETTO 600 Increasing this value should get you working. Rich Lopez -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] Behalf Of David Andrews Sent: Wednesday, December 14, 2005 12:19 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: RMF Spreadsheet Reporter On Wed, 2005-12-14 at 16:56 +, Perryman, Brian wrote: > The FTP log shows: > SENT: LIST > java.net.SocketTimeoutException: Read timed out I've seen this happen if either (a) there's a MTU mismatch (see your plumbers about this), or (b) you're using an active (rather than passive) ftp connection. For the latter, try to insert a LOCSITE FWF in the command stream, which enables passive ftp. -- David Andrews A. Duda and Sons, Inc. [EMAIL PROTECTED] -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: RMF Spreadsheet Reporter
On 14 Dec 2005 09:42:34 -0800, [EMAIL PROTECTED] (Perryman, Brian) wrote: >.one thing that might be relevant, the (first four) numbers in the >PORT statement below do not match my target FTP server.. How do I >interpret that line in the log please? > >SENT: PORT 192,168,2,1,6,190 >200 Port request OK. The IP address in the PORT command is the IP address of the FTP *client* (your workstation), *not* the FTP server (the mainframe). The FTP client (your workstation) has opened a socket on port 6190 in the workstation's TCP/IP stack and is listening for a connection *from* the FTP server. The purpose of the PORT command (sent by the FTP client) is to give the server the IP address and port number that it (the server) needs to connect to in order to transfer the results of the LIST command. Again, you might want to see if the FTP client being used can support passive-mode data transfers. Eric -- Eric Chevalier E-mail: [EMAIL PROTECTED] Web: www.tulsagrammer.com Is that call really worth your child's life? HANG UP AND DRIVE! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: RMF Spreadsheet Reporter
Check with your firewall people. Something could have changed. -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] Behalf Of Eric Chevalier Sent: Wednesday, December 14, 2005 2:24 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: RMF Spreadsheet Reporter On 14 Dec 2005 09:42:34 -0800, [EMAIL PROTECTED] (Perryman, Brian) wrote: >.one thing that might be relevant, the (first four) numbers in the >PORT statement below do not match my target FTP server.. How do I >interpret that line in the log please? > >SENT: PORT 192,168,2,1,6,190 >200 Port request OK. The IP address in the PORT command is the IP address of the FTP *client* (your workstation), *not* the FTP server (the mainframe). The FTP client (your workstation) has opened a socket on port 6190 in the workstation's TCP/IP stack and is listening for a connection *from* the FTP server. The purpose of the PORT command (sent by the FTP client) is to give the server the IP address and port number that it (the server) needs to connect to in order to transfer the results of the LIST command. Again, you might want to see if the FTP client being used can support passive-mode data transfers. Eric -- Eric Chevalier E-mail: [EMAIL PROTECTED] Web: www.tulsagrammer.com Is that call really worth your child's life? HANG UP AND DRIVE! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: RMF Spreadsheet Reporter
Eric Chevalier wrote: On 14 Dec 2005 09:42:34 -0800, [EMAIL PROTECTED] (Perryman, Brian) wrote: .one thing that might be relevant, the (first four) numbers in the PORT statement below do not match my target FTP server.. How do I interpret that line in the log please? SENT: PORT 192,168,2,1,6,190 200 Port request OK. The IP address in the PORT command is the IP address of the FTP *client* (your workstation), *not* the FTP server (the mainframe). The FTP client (your workstation) has opened a socket on port 6190 in the workstation's TCP/IP stack and is listening for a connection *from* the FTP server. The purpose of the PORT command (sent by the FTP client) is to give the server the IP address and port number that it (the server) needs to connect to in order to transfer the results of the LIST command. Are you sure about this Eric? Shouldn't it be port 1726 (6*256 + 190)? -- - | Edward E. Jaffe|| | Mgr, Research & Development| [EMAIL PROTECTED]| | Phoenix Software International | Tel: (310) 338-0400 x318 | | 5200 W Century Blvd, Suite 800 | Fax: (310) 338-0801| | Los Angeles, CA 90045 | http://www.phoenixsoftware.com | - -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: RMF Spreadsheet Reporter
On 14 Dec 2005 10:37:12 -0800, [EMAIL PROTECTED] (Edward E. Jaffe) wrote: >Are you sure about this Eric? Shouldn't it be port 1726 (6*256 + 190)? Oops! I stand corrected; you're right! Eric -- Eric Chevalier E-mail: [EMAIL PROTECTED] Web: www.tulsagrammer.com Is that call really worth your child's life? HANG UP AND DRIVE! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: RMF Spreadsheet Reporter
You know what, this is exactly why I love all you guys.. (and gals!) You've all given me loads of avenues to explore there that I hadn't thought of (because I just automatically assumed that I was at fault) in particular I like the McAfee policy update suggestion, because on Monday I had problems doing command-line FTP client connections to absolutely The Whole World, which 'they' (The Network Powers That Be Who Are A Law Unto Themselves) told me was due to a McAfee policy roll-out blocking port 21.. However that got fixed and I can 'native' FTP now. I'm surprised to see that 192.168.2.1 address in there - that is NOT my workstation, that is some 172.17.xxx.xxx address. So where has that 192 one come from? Is McAfee routing it through some sort of proxy, I wonder? Time for a chat with The Network Boys in the morning (it's 11:30pm here in the 51st State at the moment), I suspect though, I think I *know* how the conversation is going to go.. something along the lines of "..Changed? No, nothing's changed.. ..Nah, nothing we would do would affect you in *that* way.." etc Thanks again folks for all the pointers and suggestions of which way to go. At least I know I'm not going mad. Unless we all are.. Brian - This e-mail message is for the sole use of the intended recipient(s)and may contain confidential and privileged information of Transaction NetworkServices. Any unauthorized review, use, disclosure or distribution isprohibited. If you are not the intended recipient, please contact thesender by reply e-mail and destroy all copies of the original message. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: RMF Spreadsheet Reporter
I think it depends on what spreadsheet/report you are opening, some are empty, because there's no correspond smf record.. If all are not working, that's a problem. On Wed, Sep 16, 2009 at 2:19 AM, Dana Mitchell wrote: > Hello, > I'm trying to get the RMF Spreadsheet reporter working and I am quite > stumped. > > This is on Windows XP, Excel 2003. I have downloaded and installed the > latest version of the reporter. It starts up OK, I define my SMF dump > datasets. I Select Create->Workingset. The job runs successfully. The > workingset shows up in the working sets folder on the local side. Then I > select an excel spreadsheet to open. In the spreadsheet, click the button > to 'Select Working Set and process Data...'.Then I get an error message > box stating: 'No Working Set selected or no Working Set available'. > > Does anybody have any ideas what might be going on here? I can see the > working sets in the correct directory, but I can't convince Excel that > they are > there... > > Thanks > Dana > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO > Search the archives at http://bama.ua.edu/archives/ibm-main.html > -- Cobe Xu Best Regards --- zOS Performance & Capacity Analyst E2E Performance Analyst Email: cob...@gmail.com --- -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: RMF Spreadsheet Reporter
I've never created the working set directly from the SMF data. I create the overview records first and then create the working set from that. e.g.: 1) Select SMF data set 2) Create overview records (submits batch job) 3) Retrieve the overview file from mainframe 4) Select the overview file and create working set I create monthly charts/reports using this process >>> Dana Mitchell 9/15/2009 2:19 PM >>> Hello, I'm trying to get the RMF Spreadsheet reporter working and I am quite stumped. This is on Windows XP, Excel 2003. I have downloaded and installed the latest version of the reporter. It starts up OK, I define my SMF dump datasets. I Select Create->Workingset. The job runs successfully. The workingset shows up in the working sets folder on the local side. Then I select an excel spreadsheet to open. In the spreadsheet, click the button to 'Select Working Set and process Data...'.Then I get an error message box stating: 'No Working Set selected or no Working Set available'. Does anybody have any ideas what might be going on here? I can see the working sets in the correct directory, but I can't convince Excel that they are there... Thanks Dana -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: RMF Spreadsheet Reporter
hi Michael, I have questions, in one of our shops, client limits FTP, or because we connect to the host via sine(ie. Aventail),thus we can not submit batch job from PC(RMF Spreadsheet reporter). Q1: So I copy the JCL to the host and submit manually, then download the "listing" file from host via ISPF.6. However, when I try to create working set from the this "listing" file, it comes up error saying " report options are not setting..can not process "the listing file path..." what's wrong? Q2: Can you share some sample control statements, if I want to produce workload CPU usage chart, by service class. Is this controlled in the overview file you specify in "SYSTEM OPTIONS" ? many thanks..! On Fri, Sep 18, 2009 at 10:56 PM, Michael Schmutzok wrote: > I've never created the working set directly from the SMF data. I create the > overview records first and then create the working set from that. e.g.: > > 1) Select SMF data set > 2) Create overview records (submits batch job) > 3) Retrieve the overview file from mainframe > 4) Select the overview file and create working set > > I create monthly charts/reports using this process > > > > > >>> Dana Mitchell 9/15/2009 2:19 PM >>> > Hello, > I'm trying to get the RMF Spreadsheet reporter working and I am quite > stumped. > > This is on Windows XP, Excel 2003. I have downloaded and installed the > latest version of the reporter. It starts up OK, I define my SMF dump > datasets. I Select Create->Workingset. The job runs successfully. The > workingset shows up in the working sets folder on the local side. Then I > select an excel spreadsheet to open. In the spreadsheet, click the button > to 'Select Working Set and process Data...'.Then I get an error message > box stating: 'No Working Set selected or no Working Set available'. > > Does anybody have any ideas what might be going on here? I can see the > working sets in the correct directory, but I can't convince Excel that > they are > there... > > Thanks > Dana > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO > Search the archives at http://bama.ua.edu/archives/ibm-main.html > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO > Search the archives at http://bama.ua.edu/archives/ibm-main.html > -- Cobe Xu Best Regards --- zOS Performance & Capacity Analyst E2E Performance Analyst Email: cob...@gmail.com --- -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: RMF Spreadsheet Reporter
Cobe, Your upload/download process should work OK as far as I know. The FTP is just a transport mechanism in this case. To assist in defining the Overview Control Statements, look at the HELP tab in the Workload Overview Report spreadsheet. There is a button that opens the Create Overview Control Statements Spreadsheet to define Workload Overview Records. Also, in the DEFINE tab, you can rename the workload names to something more descriptive. >From the Help for RMF Spreadsheet Reporter: Collect:When you create remote Report Listings or Overview Records, a Postprocessor job is generated and submitted on the host system. Download:When you create local Report Listings or Overview Records, the download of the remote Postprocessor output is performed in addition to the Collect task. Generate:When you generate a Working Set from Report Listings or Overview Records, the extraction and conversion of the relevant data is performed . Display:When you start a spreadsheet macro, you need to feed this macro with a selected Working Set to get the graphical display of the contained performance measurements. I understand there is a way to create the working sets from report listings, but I've never used that process. It sounds like you're doing the Collect and Download steps ok. Are you doing the Generate step also? Attached: Workload Trend.txt - Sample JCL and overview control statements I use to create yearly trending charts. This job creates the overview record file which I then use as input to generate the working set file. Monthly Overview.txt - Sample overview control statements I use to create my monthly System Overview charts. Again, the overview record file created is used as input to generate the working set file. Michael Schmutzok Systems Programmer, Shands HelathCare >>> Cobe Xu 9/19/2009 11:59 PM >>> hi Michael, I have questions, in one of our shops, client limits FTP, or because we connect to the host via sine(ie. Aventail),thus we can not submit batch job from PC(RMF Spreadsheet reporter). Q1: So I copy the JCL to the host and submit manually, then download the "listing" file from host via ISPF.6. However, when I try to create working set from the this "listing" file, it comes up error saying " report options are not setting..can not process "the listing file path..." what's wrong? Q2: Can you share some sample control statements, if I want to produce workload CPU usage chart, by service class. Is this controlled in the overview file you specify in "SYSTEM OPTIONS" ? many thanks..! On Fri, Sep 18, 2009 at 10:56 PM, Michael Schmutzok wrote: > I've never created the working set directly from the SMF data. I create the > overview records first and then create the working set from that. e.g.: > > 1) Select SMF data set > 2) Create overview records (submits batch job) > 3) Retrieve the overview file from mainframe > 4) Select the overview file and create working set > > I create monthly charts/reports using this process > > > > > >>> Dana Mitchell 9/15/2009 2:19 PM >>> > Hello, > I'm trying to get the RMF Spreadsheet reporter working and I am quite > stumped. > > This is on Windows XP, Excel 2003. I have downloaded and installed the > latest version of the reporter. It starts up OK, I define my SMF dump > datasets. I Select Create->Workingset. The job runs successfully. The > workingset shows up in the working sets folder on the local side. Then I > select an excel spreadsheet to open. In the spreadsheet, click the button > to 'Select Working Set and process Data...'.Then I get an error message > box stating: 'No Working Set selected or no Working Set available'. > > Does anybody have any ideas what might be going on here? I can see the > working sets in the correct directory, but I can't convince Excel that > they are > there... > > Thanks > Dana > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO > Search the archives at http://bama.ua.edu/archives/ibm-main.html > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO > Search the archives at http://bama.ua.edu/archives/ibm-main.html > -- Cobe Xu Best Regards --- zOS Performance & Capacity Analyst E2E Performance Analyst Email: cob...@gmail.com --
Re: RMF Spreadsheet Reporter
In a message dated 9/21/2009 9:08:47 A.M. Central Daylight Time, sch...@shands.ufl.edu writes: >From the Help for RMF Spreadsheet Reporter: Collect:When you create remote Report Listings or Overview Records, a Postprocessor job is generated and submitted on the host system. Download:When you create local Report Listings or Overview Records, the download of the remote Postprocessor output is performed in addition to the Collect task. Generate:When you generate a Working Set from Report Listings or Overview Records, the extraction and conversion of the relevant data is performed . Display:When you start a spreadsheet macro, you need to feed this macro with a selected Working Set to get the graphical display of the contained performance measurements. I understand there is a way to create the working sets from report listings, but I've never used that process. It sounds like you're doing the Collect and Download steps ok. Are you doing the Generate step also? >> Good summary. Think I frontend the collection with RMF stripper to only pass the 70-79 records to the collector. Think it cut about 40% off elapsed time. The SAMPLE spreadsheet is pretty good and the tutorial from the ICONs is a good overview. Pay particular attention to FOLDER names and placements when downloading. If you're doing Overviews or Listings you need to be in that folder when you do the RECEIVEs or make arrangements to copy them to the respective locations. Once it clicks in it's pretty straight forward. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: RMF Spreadsheet Reporter
My startup command looks like this: "D:\Program Files\RMF\pm390\ibmjava\jre\bin\javaw.exe" -jar gpm.jar >>> Dennis McCarthy 10/28/2009 10:37 AM >>> Hello Listers, Does anyone know the string of options that should be passed when opening the Reporter with the following command: "C:\Program Files\RMF\RMF Spreadsheet Reporter\Ibmjava\jre\bin\javaws.exe" Regards, Dennis -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: RMF Spreadsheet Reporter
Thanks to those who replied. I found my command string. In case anyone is interested, mine looks like this: "C:\Program Files\RMF\RMF Spreadsheet Reporter\Ibmjava\jre\bin\javaw.exe" - cp rmfsrhelp.jar;jhall.jar -jar rmfsr.jar -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: RMF Spreadsheet Reporter
Hi, You can find the tool at http://www-03.ibm.com/servers/eserver/zseries/zos/rmf/tools/. You can review the tutorial if you click on "overview" mid-way down the page. It will not work with Xcel 2007. Good luck. "Jorge Arueira Campos" <[EMAIL PROTECTED]> wrote in message news: <[EMAIL PROTECTED]>... > Hi all !!! > > Anybody know about to use the RMF Spreadsheet Reporter in windows and > Host.I need to make a graphical reports based in RMF of CPU, DASD, > STORAGE, PAGING and so on... > > Thanks any help > > Arueira /Barnack > Support Team z/OS > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: RMF Spreadsheet Reporter
In a message dated 9/11/2008 5:01:01 P.M. Central Daylight Time, [EMAIL PROTECTED] writes: You can review the tutorial if you click on "overview" mid-way down the page. It will not work with Xcel 2007. >> Right. It's just a series of EXCEL or LOTUS macros defined to do RMF window of a few days(?) maybe. I always had better luck filtering the RMF out first then running the RMF reporter on the host to produce the files for RFMPP. The little GUI has a pretty good help and tutorial. Folder names are critical. Always had trouble getting the auto FTP to work and would end up doing manual downloads to correct places. There's a JAVA version too, but under Windoze it's pretty awful. **Pt...Have you heard the news? There's a new fashion blog, plus the latest fall trends and hair styles at StyleList.com. (http://www.stylelist.com/trends?ncid=aolsty000514) -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: RMF Spreadsheet Reporter
HI it is quite easy to use this. Download the program and make the PERFDESKS. Only problem I have now is that i can Only make 10 Perfdesk, creating #11 ist not possible, Giovanni SAntuz SYSPROG BG-PHOENICS Munich Germany Original-Nachricht > Datum: Thu, 11 Sep 2008 18:11:21 -0300 > Von: Jorge Arueira Campos <[EMAIL PROTECTED]> > An: IBM-MAIN@BAMA.UA.EDU > Betreff: RMF Spreadsheet Reporter > Hi all !!! > > Anybody know about to use the RMF Spreadsheet Reporter in windows and > Host.I need to make a graphical reports based in RMF of CPU, DASD, > STORAGE, PAGING and so on... > > Thanks any help > > Arueira /Barnack > Support Team z/OS > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO > Search the archives at http://bama.ua.edu/archives/ibm-main.html -- M f G. Giovanni Santuz +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: RMF Spreadsheet Reporter
Hi Tom, There is a checkbox under the menu item Settings : Options "Sort SMF Datasets". If unchecked you don't get the SORT step built. I leave it unchecked and always used sorted input. Typically if I need to build this adhoc I use this job //* //* COPY SOME RMF RECORDS TO MY NORMAL WORKING DATA SET //* SORT WITH RMF EXITS IS USED SO INPUT MAY BE SORTED OR UNSORTED //* AND MAY CONTAIN NON-RMF SMF RECORDS WHICH WILL BE DISCARDED //* //CA11RMS EXEC UCC7RMS,TYPRUN='F' RE-RUN MANAGER //* //SORT EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD DSN=DSS.DISK.SMF.ASYS.MANX, // DISP=SHR // DD DSN=DSS.DISK.SMF.CSYS.MANX, // DISP=SHR // DD DSN=DSS.DISK.SMF.DSYS.MANX, // DISP=SHR //*ORTIN DD DISP=SHR,DSN=T06.TAPE.SMF.WEEKLY.G0516V00.RMF //*ORTIN DD DISP=SHR,DSN=DSS.DISK.SMF.DAILY(-00) //SORTOUT DD DSN=T06.DISK.SMF.NOW.RMF, //DISP=(,CATLG,DELETE), //MGMTCLAS=MCSM, //DATACLAS=COMPRESS, //SPACE=(CYL,(4000,100),RLSE),VOL=(,,,59), //DCB=(GEICO.MODELDCB,RECFM=VBS,BLKSIZE=27998, //LRECL=32760,DSORG=PS) //SYSINDD * 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,500,,N),E35=(ERBPPE35,500,,N) END /* Best Regards, Sam Knutson, GEICO Performance and Availability Management mailto:[EMAIL PROTECTED] (office) 301.986.3574 "Think big, act bold, start simple, grow fast..." -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Kelman, Tom Sent: Wednesday, October 08, 2008 11:45 AM To: IBM-MAIN@BAMA.UA.EDU Subject: RMF Spreadsheet Reporter I am trying to run the RMF Spreadsheet Reporter for the first time in a while. I started by installing version 5.2.7 to my PC. I then defined a system and an SMF dataset. Then I'm trying to user the product to submit a job from my workstation to the mainframe. The job gets to the mainframe OK. However, there is no step in the job to sort the input SMF data even though there is one in the skeleton JCL in C:/Program Files/RMF/RMF Spreadsheet Reporter/Connect/RMFPP1.JCL on my workstation. Has anyone else run into a problem with RMF Spreadsheet Reporter dropping the sort step when it sends the job to the mainframe? Does anyone know what I might need to do to get the sort step included? Without it the RMF Post Processor just prints the message "ERB478I PPS: SMF RECORDS NOT SORTED" and terminates, so I get no reports, and then I get an error at the workstation end. Tom Kelman Enterprise Capacity Planner Commerce Bank of Kansas City (816) 760-7632 * If you wish to communicate securely with Commerce Bank and its affiliates, you must log into your account under Online Services at http://www.commercebank.com or use the Commerce Bank Secure Email Message Center at https://securemail.commercebank.com NOTICE: This electronic mail message and any attached files are confidential. The information is exclusively for the use of the individual or entity intended as the recipient. If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited. If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. * -- For IBM-MAIN subscribe / signoff / archive access instructions, send ema
Re: RMF Spreadsheet Reporter
Tom On the Settings->Options/General section, right at the bottom you should see a check box "Sort SMF Datasets". Maybe worth checking that. Brian -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Kelman, Tom Sent: 08 October 2008 16:45 To: IBM-MAIN@BAMA.UA.EDU Subject: RMF Spreadsheet Reporter I am trying to run the RMF Spreadsheet Reporter for the first time in a while. I started by installing version 5.2.7 to my PC. I then defined a system and an SMF dataset. Then I'm trying to user the product to submit a job from my workstation to the mainframe. The job gets to the mainframe OK. However, there is no step in the job to sort the input SMF data even though there is one in the skeleton JCL in C:/Program Files/RMF/RMF Spreadsheet Reporter/Connect/RMFPP1.JCL on my workstation. Has anyone else run into a problem with RMF Spreadsheet Reporter dropping the sort step when it sends the job to the mainframe? Does anyone know what I might need to do to get the sort step included? Without it the RMF Post Processor just prints the message "ERB478I PPS: SMF RECORDS NOT SORTED" and terminates, so I get no reports, and then I get an error at the workstation end. - Email sent from www.virginmedia.com/email Virus-checked using McAfee(R) Software and scanned for spam -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: RMF Spreadsheet Reporter
Thanks, Sam. That was it. Tom Kelman Enterprise Capacity Planner Commerce Bank of Kansas City (816) 760-7632 > -Original Message- > From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On > Behalf Of Knutson, Sam > Sent: Wednesday, October 08, 2008 10:54 AM > To: IBM-MAIN@BAMA.UA.EDU > Subject: Re: RMF Spreadsheet Reporter > > Hi Tom, > > There is a checkbox under the menu item Settings : Options "Sort SMF > Datasets". If unchecked you don't get the SORT step built. > > I leave it unchecked and always used sorted input. Typically if I need to > build this adhoc I use this job > > //* > //* COPY SOME RMF RECORDS TO MY NORMAL WORKING DATA SET > //* SORT WITH RMF EXITS IS USED SO INPUT MAY BE SORTED OR UNSORTED > //* AND MAY CONTAIN NON-RMF SMF RECORDS WHICH WILL BE DISCARDED > //* > //CA11RMS EXEC UCC7RMS,TYPRUN='F' RE-RUN MANAGER > //* > //SORT EXEC PGM=SORT > //SYSOUT DD SYSOUT=* > //SORTIN DD DSN=DSS.DISK.SMF.ASYS.MANX, > // DISP=SHR > // DD DSN=DSS.DISK.SMF.CSYS.MANX, > // DISP=SHR > // DD DSN=DSS.DISK.SMF.DSYS.MANX, > // DISP=SHR > //*ORTIN DD DISP=SHR,DSN=T06.TAPE.SMF.WEEKLY.G0516V00.RMF > //*ORTIN DD DISP=SHR,DSN=DSS.DISK.SMF.DAILY(-00) > //SORTOUT DD DSN=T06.DISK.SMF.NOW.RMF, > //DISP=(,CATLG,DELETE), > //MGMTCLAS=MCSM, > //DATACLAS=COMPRESS, > //SPACE=(CYL,(4000,100),RLSE),VOL=(,,,59), > //DCB=(GEICO.MODELDCB,RECFM=VBS,BLKSIZE=27998, > //LRECL=32760,DSORG=PS) > //SYSINDD * > 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,500,,N),E35=(ERBPPE35,500,,N) > END > /* > > Best Regards, > > Sam Knutson, GEICO > Performance and Availability Management > mailto:[EMAIL PROTECTED] > (office) 301.986.3574 > > "Think big, act bold, start simple, grow fast..." > > > -Original Message- > From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On > Behalf Of Kelman, Tom > Sent: Wednesday, October 08, 2008 11:45 AM > To: IBM-MAIN@BAMA.UA.EDU > Subject: RMF Spreadsheet Reporter > > I am trying to run the RMF Spreadsheet Reporter for the first time in a > while. I started by installing version 5.2.7 to my PC. I then defined > a system and an SMF dataset. Then I'm trying to user the product to > submit a job from my workstation to the mainframe. The job gets to the > mainframe OK. However, there is no step in the job to sort the input > SMF data even though there is one in the skeleton JCL in C:/Program > Files/RMF/RMF Spreadsheet Reporter/Connect/RMFPP1.JCL on my workstation. > Has anyone else run into a problem with RMF Spreadsheet Reporter > dropping the sort step when it sends the job to the mainframe? Does > anyone know what I might need to do to get the sort step included? > Without it the RMF Post Processor just prints the message "ERB478I PPS: > SMF RECORDS NOT SORTED" and terminates, so I get no reports, and then I > get an error at the workstation end. > > > > Tom Kelman > > Enterprise Capacity Planner > > Commerce Bank of Kansas City > > (816) 760-7632 > > > > > > ** > *** > If you wish to communicate securely with Commerce Bank and its > affiliates, you must log into your account under Online Services at > http://www.commercebank.com or use the Commerce Bank Secure > Email Message Center at https://securemail.commercebank.com > > NOTICE: This electronic mail message and any attached files are > confidential. The information is exclusively for the use of the > individual or entity intended as the recipient. If you are not > the intended recipient, any use, copying, printing, reviewing, > retention, disclosure, distribution or forwarding of the message > or any attached file is not authorized and is strictly prohibited. > If you have received this electronic mail message in error, please > advise the sender by reply electronic mail immediately and > permanently delete the original transmission, any attachments > and any copies of this message from your computer system. > ** > *** > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO > Search
RMF Spreadsheet Reporter Overview
I solved my problem. 'Sort SMF Datasets' must be selected in Settings/Options/General thanks Albert VERLAGSGRUPPE WELTBILD GMBH Sitz der Gesellschaft: Augsburg Handelsregister Augsburg HRB 6035 Ust-ID-Nr: DE 127501299 Geschäftsführung: Carel Halff (Vorsitzender), Dr. Klaus Driever, Werner Ortner, Herbert Zoch Vorsitzender des Aufsichtsrates: Dr. Klaus Donaubauer
RMF Spreadsheet Reporter Overview
Hi List I play around with the RMF Spreadsheet Reporter. I have created a report successfully. My problem: SMF input dataset contains one day ( 07/17/2007) If I create a overview, the first interval is 07/17/2007-21.15.00 // //*RMF POSTPROCESSING OPTIONS // //SYSINDD * DATE(07012007,07312007) NOSUMMARY OVERVIEW(RECORD) OVW(DEFMU2FM(WDEFL(MU2FMPW0))) OVW(ACTMU2FM(WACTL(MU2FMPW0))) OVW(MINMU2FM(WMINL(MU2FMPW0))) OVW(MAXMU2FM(WMAXL(MU2FMPW0))) OVW(NLDMU2FM(NLDEFL(MU2FMPW0))) OVW(NLAMU2FM(NLACTL(MU2FMPW0))) OVW(LBUMU2FM(LBUSYL(MU2FMPW0))) OVW(PBUMU2FM(PBUSYL(MU2FMPW0))) OVW(LDMMU2FM(LDEFMSU(MU2FMPW0))) OVW(LDAMU2FM(LACTMSU(MU2FMPW0))) OVW(CAPMU2FM(WCAPPER(MU2FMPW0))) OVW(NLDPHY(NLDEFL(PHYSICAL))) OVW(LBUPHY(LBUSYL(PHYSICAL))) OVW(PBUPHY(PBUSYL(PHYSICAL))) OVW(RMFX9CPC(PBUSYL(PHYSICAL))) OVW(LASTRNG(PBUSYL(PHYSICAL))) SYSOUT(H) What's my mistake. Many thanks Albert VERLAGSGRUPPE WELTBILD GMBH Sitz der Gesellschaft: Augsburg Handelsregister Augsburg HRB 6035 Ust-ID-Nr: DE 127501299 Geschäftsführung: Carel Halff (Vorsitzender), Dr. Klaus Driever, Werner Ortner, Herbert Zoch Vorsitzender des Aufsichtsrates: Dr. Klaus Donaubauer
RMF Data & RMF Spreadsheet Reporter
Hi, I am just starting to get to grips with the RMF Spreadsheet Reporter. I need to do some analysis of some historical data that was created on a zOS 1.4 system on my current zOS 1.6 system. However, the RMF Post Processor is complaining about differing levels of Code & data. Is their a way to transform the zOS 1.4 data into something that RMFPP can process? Any help gratefully received. Kind Regards Mark Wilson Mobile: +44 (0) 7768 617006 Chairman GSE Large Systems Working Group eMail: [EMAIL PROTECTED] -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
RMF Spreadsheet Reporter Excel Error
Has anyone run into this Excel error when trying to use IBM's RMF Spreadsheet Reporter? I get a popup that reads: | Error Message | - | File access error occurred. | Additional information: You are attempting to open a file type that is | blocked by your registry policy setting. I've googled quit a bit on it and did some changes to my registry, but it didn't fix it. I was wondering if anyone else came upon this and figured out what to do about it. Kind regards, Lindy -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: RMF Spreadsheet Reporter Overview
Statistician's First Commandment: "Know your data and know it well" Have you empirically and independently proven beyond any doubt that the range of timestamps in the input dataset meets or exceeds all of the desired reporting interval? Does the date range in the data make more sense if you adjust it for GMT offset? This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. Albert Klimek <[EMAIL PROTECTED] LTBILD.COM>To Sent by: IBM IBM-MAIN@BAMA.UA.EDU Mainframe cc Discussion List <[EMAIL PROTECTED] Subject .EDU> RMF Spreadsheet Reporter Overview 07/19/2007 04:54 AM Please respond to IBM Mainframe Discussion List <[EMAIL PROTECTED] .EDU> Hi List I play around with the RMF Spreadsheet Reporter. I have created a report successfully. My problem: SMF input dataset contains one day ( 07/17/2007) If I create a overview, the first interval is 07/17/2007-21.15.00 // //*RMF POSTPROCESSING OPTIONS // //SYSINDD * DATE(07012007,07312007) NOSUMMARY OVERVIEW(RECORD) OVW(DEFMU2FM(WDEFL(MU2FMPW0))) OVW(ACTMU2FM(WACTL(MU2FMPW0))) OVW(MINMU2FM(WMINL(MU2FMPW0))) OVW(MAXMU2FM(WMAXL(MU2FMPW0))) OVW(NLDMU2FM(NLDEFL(MU2FMPW0))) OVW(NLAMU2FM(NLACTL(MU2FMPW0))) OVW(LBUMU2FM(LBUSYL(MU2FMPW0))) OVW(PBUMU2FM(PBUSYL(MU2FMPW0))) OVW(LDMMU2FM(LDEFMSU(MU2FMPW0))) OVW(LDAMU2FM(LACTMSU(MU2FMPW0))) OVW(CAPMU2FM(WCAPPER(MU2FMPW0))) OVW(NLDPHY(NLDEFL(PHYSICAL))) OVW(LBUPHY(LBUSYL(PHYSICAL))) OVW(PBUPHY(PBUSYL(PHYSICAL))) OVW(RMFX9CPC(PBUSYL(PHYSICAL))) OVW(LASTRNG(PBUSYL(PHYSICAL))) SYSOUT(H) What's my mistake. Many thanks Albert VERLAGSGRUPPE WELTBILD GMBH Sitz der Gesellschaft: Augsburg Handelsregister Augsburg HRB 6035 Ust-ID-Nr: DE 127501299 Geschäftsführung: Carel Halff (Vorsitzender), Dr. Klaus Driever, Werner Ortner, Herbert Zoch Vorsitzender des Aufsichtsrates: Dr. Klaus Donaubauer -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
RMF Spreadsheet Reporter Version 5.1.4
I noticed RMF Spreadsheet Reporter Version 5.1.4 is recently available. Abstract: The RMF Spreadsheet Reporter serves as a front-end to the RMF postprocessor on your z/OS system. With its graphics capabilities, RMF Spreadsheet Reporter allows you to analyze z/OS performance data through powerful graphical charts - right from your workstation. http://www.ibm.com/servers/eserver/zseries/zos/rmf/rmfhtmls/rmftools.htm Best Regards, Sam Knutson, GEICO Performance and Availability Management mailto:[EMAIL PROTECTED] (office) 301.986.3574 "Think big, act bold, start simple, grow fast..." <> This email/fax message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution of this email/fax is prohibited. If you are not the intended recipient, please destroy all paper and electronic copies of the original message. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: RMF Data & RMF Spreadsheet Reporter
--- snip --- Hi, I am just starting to get to grips with the RMF Spreadsheet Reporter. I need to do some analysis of some historical data that was created on a zOS 1.4 system on my current zOS 1.6 system. However, the RMF Post Processor is complaining about differing levels of Code & data. Is their a way to transform the zOS 1.4 data into something that RMFPP can process? --- snip --- You need to modify the PP JCL that is being generated. I believe that it is in RMFPPL.JCL. Add a Steplib to point to your z/OS 1.4 RMF Loadlib. Take a look at RMF Users Guide (SC33-7994). John -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: RMF Spreadsheet Reporter Excel Error
I didn't save the email, but the fine folks who support and maintain the RMF Spreadsheet Reporter pointed me to the Microsoft document on how to fix it. -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Lindy Mayfield Sent: Saturday, March 08, 2008 10:25 AM To: IBM-MAIN@BAMA.UA.EDU Subject: RMF Spreadsheet Reporter Excel Error Has anyone run into this Excel error when trying to use IBM's RMF Spreadsheet Reporter? I get a popup that reads: | Error Message | - | File access error occurred. | Additional information: You are attempting to open a file type that is | blocked by your registry policy setting. I've googled quit a bit on it and did some changes to my registry, but it didn't fix it. I was wondering if anyone else came upon this and figured out what to do about it. Kind regards, Lindy -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Antwort: Re: RMF Spreadsheet Reporter Overview
RMF is not my main topic. Therefore I use the RMF Spreadsheet Reporter to investigate our LPAR performance. But a sorted SMF dataset is mandatory for reports and overviews. I assumed the Spreadsheet Reporter handles this automatically. Albert VERLAGSGRUPPE WELTBILD GMBH Sitz der Gesellschaft: Augsburg Handelsregister Augsburg HRB 6035 Ust-ID-Nr: DE 127501299 Geschäftsführung: Carel Halff (Vorsitzender), Dr. Klaus Driever, Werner Ortner, Herbert Zoch Vorsitzender des Aufsichtsrates: Dr. Klaus Donaubauer
Re: RMF Spreadsheet Reporter Version 5.1.4
Sam, I liked the RMF Spreadhseet Reporter though the data transfer portion was slow and awkward. I found I could use ftp from within an excel macro and more quickly tranfer data than was possible with the RMF host download function. Paul Hanrahan -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Knutson, Sam Sent: Saturday, June 11, 2005 9:51 PM To: IBM-MAIN@BAMA.UA.EDU Subject: RMF Spreadsheet Reporter Version 5.1.4 I noticed RMF Spreadsheet Reporter Version 5.1.4 is recently available. Abstract: The RMF Spreadsheet Reporter serves as a front-end to the RMF postprocessor on your z/OS system. With its graphics capabilities, RMF Spreadsheet Reporter allows you to analyze z/OS performance data through powerful graphical charts - right from your workstation. http://www.ibm.com/servers/eserver/zseries/zos/rmf/rmfhtmls/rmftools.htm Best Regards, Sam Knutson, GEICO Performance and Availability Management mailto:[EMAIL PROTECTED] (office) 301.986.3574 "Think big, act bold, start simple, grow fast..." <> This email/fax message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution of this email/fax is prohibited. If you are not the intended recipient, please destroy all paper and electronic copies of the original message. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
RMF Spreadsheet Reporter Version 5.2.0 (31 March 2006)
New version of the RMF Spreadsheet Reporter appears to be available. Have fun! RMF Spreadsheet Reporter Version 5 for Windows 2000/XP and ME Abstract: The RMF Spreadsheet Reporter serves as a front-end to the RMF postprocessor on your z/OS system. With its graphics capabilities, RMF Spreadsheet Reporter allows you to analyze z/OS performance data through powerful graphical charts - right from your workstation. http://www.ibm.com/servers/eserver/zseries/zos/rmf/rmfhtmls/rmftools.htm l Best Regards, Sam Knutson, GEICO Performance and Availability Management mailto:[EMAIL PROTECTED] (office) 301.986.3574 "Think big, act bold, start simple, grow fast..." ][ This email/fax message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution of this email/fax is prohibited. If you are not the intended recipient, please destroy all paper and electronic copies of the original message. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: RMF Spreadsheet Reporter Version 5.2.0 (31 March 2006)
In a message dated 4/6/2006 9:44:13 A.M. Central Standard Time, [EMAIL PROTECTED] writes: New version of the RMF Spreadsheet Reporter appears to be available. Have fun! >> Could you get the auto-FTP to work??? -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
RMF Spreadsheet reporter - why is FTP deleting report listings
I'm trying to setup the RMF Spreadsheet reporter (V5.2.2) and it works fine the first time, but when I try to generate subsequent working sets it fails. Rather than retrieving the listing, which is successfully created on the host, it deletes it instead: SENT: USER P390 331 Send password please. SENT: PASS (*hidden*) 230 P390 is logged on. Working directory is "P390.". SENT: SYST 215 MVS is the operating system of this server. FTP Server is running on z/OS. SENT: PWD 257 "'P390.'" is working directory. SENT: CWD 'SMFDUMP.RMF.SR' 250 "SMFDUMP.RMF.SR." is the working directory name prefix. SENT: PWD 257 "'SMFDUMP.RMF.SR.'" is working directory. SENT: site retpd 200 SITE command was accepted SENT: site autorecall 200 SITE command was accepted SENT: DELE 'SMFDUMP.RMF.SR.D022.T113157.LISTING' 250 SMFDUMP.RMF.SR.D022.T113157.LISTING deleted. SENT: QUIT 221 Quit command received. Goodbye. Any idea why this is happening and how I can stop it. The first time I use the tool it does a RETR and works fine. Thanks in advance, William The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. If you are not the intended addressee please contact the sender and dispose of this e-mail. Thank you. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html