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: [email protected]
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
