Extracting SMF records with IFASMFDP
I am attempting to extract a subset of a subset of SMF data for a time period from 00:00 to 14:00 on 8/9/2014 (2014221): //SMFDPTAP EXEC PGM=IFASMFDP //SYSPRINT DD SYSOUT=* //DUMPINDD DSN=SE.EN.X02.SCRT.DATA.G2871V00,DISP=SHR //DUMPOUT DD DSN=TECH.SCRT.PART2, // DISP=(,CATLG,DELETE), // UNIT=SYSALLDA, // SPACE=(CYL,(5,1),,CONTIG), // DCB=D.SMF //SYSIN DD * INDD(DUMPIN,OPTIONS(DUMP)) OUTDD(DUMPOUT,TYPE(0:255)) DATE(2014221,2014221) START() END(1400) // When the job runs, I receive this report: IFA010I SMF DUMP PARAMETERS IFA010I END(1400) -- SYSIN IFA010I START() -- SYSIN IFA010I DATE(2014221,2014221) -- SYSIN IFA010I OUTDD(DUMPOUT,TYPE(0:255)) -- SYSIN IFA010I INDD(DUMPIN,OPTIONS(DUMP)) -- SYSIN IFA020I DUMPOUT -- TECH.SCRT.PART2 IFA020I DUMPIN -- SE.EN.X02.SCRT.DATA.G2871V00 SUMMARY ACTIVITY REPORT START DATE-TIME 08/01/2014-00:30:00 END DATE-TIME 08/10/2014-00:00:00 RECORD RECORDS PERCENT AVG. RECORD MIN. RECORD MAX. RECORD RECORDS TYPE READOF TOTAL LENGTHLENGTH LENGTH WRITTEN 2 1 .10 %18.0018 18 1 3 1 .10 %18.0018 18 1 70 454 45.58 % 1,950.03 172 3,916 270 89 540 54.22 % 3,403.50 326 8,490 329 TOTAL996 100 % 2,734.1818 8,490 601 NUMBER OF RECORDS IN ERROR 0 The input data set only contains data for 8/9/14 - 2014221. So, why does the report says the Start Date is 08/01/2014? And the end data is 8/10/24? I have specified a Start Date of 8/9/2014. Why does the End Date become 8/10/2014 and the end time is 00:00:00 when I have specified an end time of 14:00 and a End Date of 2014221 - 8/9/2014? -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Extracting SMF records with IFASMFDP
Try running the extract again, using TECH.SCRT.PART2 as your input and see what dates you get. I think it MIGHT be giving you the beginning and ending dates of the data it found in the input report. Rex -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Mark Yuhas Sent: Wednesday, August 13, 2014 4:48 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Extracting SMF records with IFASMFDP I am attempting to extract a subset of a subset of SMF data for a time period from 00:00 to 14:00 on 8/9/2014 (2014221): //SMFDPTAP EXEC PGM=IFASMFDP //SYSPRINT DD SYSOUT=* //DUMPINDD DSN=SE.EN.X02.SCRT.DATA.G2871V00,DISP=SHR //DUMPOUT DD DSN=TECH.SCRT.PART2, // DISP=(,CATLG,DELETE), // UNIT=SYSALLDA, // SPACE=(CYL,(5,1),,CONTIG), // DCB=D.SMF //SYSIN DD * INDD(DUMPIN,OPTIONS(DUMP)) OUTDD(DUMPOUT,TYPE(0:255)) DATE(2014221,2014221) START() END(1400) // When the job runs, I receive this report: IFA010I SMF DUMP PARAMETERS IFA010I END(1400) -- SYSIN IFA010I START() -- SYSIN IFA010I DATE(2014221,2014221) -- SYSIN IFA010I OUTDD(DUMPOUT,TYPE(0:255)) -- SYSIN IFA010I INDD(DUMPIN,OPTIONS(DUMP)) -- SYSIN IFA020I DUMPOUT -- TECH.SCRT.PART2 IFA020I DUMPIN -- SE.EN.X02.SCRT.DATA.G2871V00 SUMMARY ACTIVITY REPORT START DATE-TIME 08/01/2014-00:30:00 END DATE-TIME 08/10/2014-00:00:00 RECORD RECORDS PERCENT AVG. RECORD MIN. RECORD MAX. RECORD RECORDS TYPE READOF TOTAL LENGTHLENGTH LENGTH WRITTEN 2 1 .10 %18.0018 18 1 3 1 .10 %18.0018 18 1 70 454 45.58 % 1,950.03 172 3,916 270 89 540 54.22 % 3,403.50 326 8,490 329 TOTAL996 100 % 2,734.1818 8,490 601 NUMBER OF RECORDS IN ERROR 0 The input data set only contains data for 8/9/14 - 2014221. So, why does the report says the Start Date is 08/01/2014? And the end data is 8/10/24? I have specified a Start Date of 8/9/2014. Why does the End Date become 8/10/2014 and the end time is 00:00:00 when I have specified an end time of 14:00 and a End Date of 2014221 - 8/9/2014? -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN The information contained in this message is confidential, protected from disclosure and may be legally privileged. If the reader of this message is not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, distribution, copying, or any action taken or action omitted in reliance on it, is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to this message and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Extracting SMF records with IFASMFDP
Correct. The report shows the START and END timestamps of the input data - not the output requested. Jay Campbell IBM OS Support Section -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@listserv.ua.edu] On Behalf Of Pommier, Rex Sent: Wednesday, August 13, 2014 5:58 PM To: IBM-MAIN@listserv.ua.edu Subject: Re: Extracting SMF records with IFASMFDP Try running the extract again, using TECH.SCRT.PART2 as your input and see what dates you get. I think it MIGHT be giving you the beginning and ending dates of the data it found in the input report. Rex -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Mark Yuhas Sent: Wednesday, August 13, 2014 4:48 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Extracting SMF records with IFASMFDP I am attempting to extract a subset of a subset of SMF data for a time period from 00:00 to 14:00 on 8/9/2014 (2014221): //SMFDPTAP EXEC PGM=IFASMFDP //SYSPRINT DD SYSOUT=* //DUMPINDD DSN=SE.EN.X02.SCRT.DATA.G2871V00,DISP=SHR //DUMPOUT DD DSN=TECH.SCRT.PART2, // DISP=(,CATLG,DELETE), // UNIT=SYSALLDA, // SPACE=(CYL,(5,1),,CONTIG), // DCB=D.SMF //SYSIN DD * INDD(DUMPIN,OPTIONS(DUMP)) OUTDD(DUMPOUT,TYPE(0:255)) DATE(2014221,2014221) START() END(1400) // When the job runs, I receive this report: IFA010I SMF DUMP PARAMETERS IFA010I END(1400) -- SYSIN IFA010I START() -- SYSIN IFA010I DATE(2014221,2014221) -- SYSIN IFA010I OUTDD(DUMPOUT,TYPE(0:255)) -- SYSIN IFA010I INDD(DUMPIN,OPTIONS(DUMP)) -- SYSIN IFA020I DUMPOUT -- TECH.SCRT.PART2 IFA020I DUMPIN -- SE.EN.X02.SCRT.DATA.G2871V00 SUMMARY ACTIVITY REPORT START DATE-TIME 08/01/2014-00:30:00 END DATE-TIME 08/10/2014-00:00:00 RECORD RECORDS PERCENT AVG. RECORD MIN. RECORD MAX. RECORD RECORDS TYPE READOF TOTAL LENGTHLENGTH LENGTH WRITTEN 2 1 .10 %18.0018 18 1 3 1 .10 %18.0018 18 1 70 454 45.58 % 1,950.03 172 3,916 270 89 540 54.22 % 3,403.50 326 8,490 329 TOTAL996 100 % 2,734.1818 8,490 601 NUMBER OF RECORDS IN ERROR 0 The input data set only contains data for 8/9/14 - 2014221. So, why does the report says the Start Date is 08/01/2014? And the end data is 8/10/24? I have specified a Start Date of 8/9/2014. Why does the End Date become 8/10/2014 and the end time is 00:00:00 when I have specified an end time of 14:00 and a End Date of 2014221 - 8/9/2014? -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN The information contained in this message is confidential, protected from disclosure and may be legally privileged. If the reader of this message is not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, distribution, copying, or any action taken or action omitted in reliance on it, is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to this message and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- 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: Extracting SMF records with IFASMFDP
Campbell Jay wrote: >Correct. The report shows the START and END timestamps of the input data - not >the output requested. Yes, and since the OP is extracting record type 89, you can do a quick check on the output whether the date/time selection works as advertised. Something like this: //SMF89EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSOUT=* //VLSHCNTL DD * OPTION COPY,VLSHRT INCLUDE COND=(6,1,BI,EQ,X'59') /* //RAWSMF DD DISP=SHR,DSN=.. //SORTSMF DD DISP=(NEW,DELETE,DELETE),SPACE=(CYL,(50,50,0)) //VREPTDD SYSOUT=* //TOOLIN DD * SORT FROM(RAWSMF) TO(SORTSMF) USING(VLSH) DISPLAY FROM(SORTSMF) LIST(VREPT) - HEADER('SMFTYP') ON(6,1,BI) - HEADER('DATE')ON(11,4,DT1,E'/99/99') - HEADER('TIME')ON(7,4,TM1,E'99:99:99') - HEADER('SYSTEM') ON(15,4,CH) 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: Extracting SMF records with IFASMFDP
Using the JCL provide by Mr. Engelbrecht, I discovered that the extract worked as coded. What I also learned was that one of test LPARs was down for an extended period of time. When the LPAR was IPLd, the latent SMF data was copied to the input of the extract. Thus, the Type 80 for the first of the month was encountered in the input phase. Thank you for this JCL which I will use again and again. Mr. Mr. Engelbrecht wrote: >Yes, and since the OP is extracting record type 89, you can do a quick check >on the output whether the date/time selection works as >advertised. >Something like this: //SMF89EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSOUT=* //VLSHCNTL DD * OPTION COPY,VLSHRT INCLUDE COND=(6,1,BI,EQ,X'59') /* //RAWSMF DD DISP=SHR,DSN=.. //SORTSMF DD DISP=(NEW,DELETE,DELETE),SPACE=(CYL,(50,50,0)) //VREPTDD SYSOUT=* //TOOLIN DD * SORT FROM(RAWSMF) TO(SORTSMF) USING(VLSH) DISPLAY FROM(SORTSMF) LIST(VREPT) - HEADER('SMFTYP') ON(6,1,BI) - HEADER('DATE')ON(11,4,DT1,E'/99/99') - HEADER('TIME')ON(7,4,TM1,E'99:99:99') - HEADER('SYSTEM') ON(15,4,CH) -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Extracting SMF records with IFASMFDP
Mark Yuhas wrote: >Using the JCL provide by Mr. Engelbrecht, I discovered that the extract worked >as coded. I'm glad for your part. >Thank you for this JCL which I will use again and again. You are most welcome! But I cannot take credits alone. Actually all credits and thanks must go to the very kind and bright/brilliant/fantastic DFSORT people who created these nice job and the ability to display packed fields in various formats. There are more from DFSORT at http://www-01.ibm.com/support/docview.wss?uid=isg3T793 :-D 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