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) > //SYSIN DD * > 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 the archives at http://bama.ua.edu/archives/ibm-main.html > > ==================== > 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
***************************************************************************** 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
