Hi, OK, I got it done (partially). I took Chris example and tried some other things. Here are my statements so far. But I have a few questions.
OPTION COPY INCLUDE COND=(((12,3,Y2U,EQ,Y'12212'),AND,(7,4,BI,GE,3600000,AND,7,4,BI,LE,3960000)),OR,((12,3,Y2U,EQ,Y'12213'),AND,(7,4,BI,GE,3600000,AND,7,4,BI,LE,3960000))) SORT FIELDS=(11,4,PD,A,7,4,BI,A) Question 1: Is it possible and how to check a SMF date column in the format YYYYMMDD rather than YYDDD Question 2: Is it possible and how to check a SMF time column in the format HHMM But the most important question is that I want to check the RMFDATE & -TIME and those columns are at on offset. Let me try to explain what I mean. Question 3: "Look in an SMF70 record" in field "SMF70PRS" (offset to product section) take this number, use it and calculate offsets for "SMF70IST" and " SMF70DAT". I would like to check date & time against those fields. Question 4: The sort statement doesn't seem to work. The records keep unsorted. ?????? Q1 & Q2 is nice to have but Q3 is a must ! Thx in advance for any help. Cheers, Uwe -----Ursprüngliche Nachricht----- Von: IBM Mainframe Discussion List [mailto:[email protected]] Im Auftrag von Blaicher, Christopher Y. Gesendet: Dienstag, 28. August 2012 19:32 An: [email protected] Betreff: Re: Exclude SMF Records by date&time with DFSORT Uwe, There are numerous ways to solve the problem you have outlined. One way you can do it is using an INCLUDE or OMIT statement. Every SMF record has the same format header portion that has the type (offset 5, sort column 6), time (offset 6, sort column 7) and date (offset 10, sort column 11) in it. Depending on your needs and the number of different time groups you want to include or exclude will determine if you use INCLUDE or OMIT. Let's say you only want SMF data from 10:00AM to 11:00AM and 1:00pm to 2:00PM and only type 14 and 15 records. INCLUDE COND=(((6,1,BI,EQ,14,OR,6,1,BI,EQ,15),AND, (7,4,BI,GT,3600000,AND,7,4,BI,LT,3960000)),OR, ((6,1,BI,EQ,14,OR,6,1,BI,EQ,15),AND, (7,4,BI,GT,4680000,AND,7,4,BI,LT,5040000))) As you can see, INCLUDE/OMIT can get quite complicated. I suggest that you use parentheses to insure you get what you want rather than base things on the precedence of operators. Chris Blaicher Senior Software Engineer, Software Services Syncsort Incorporated 50 Tice Boulevard, Woodcliff Lake, NJ 07677 P: 201-930-8260 | M: 512-627-3803 E: [email protected] -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of Williamson, James R Sent: Tuesday, August 28, 2012 10:09 AM To: [email protected] Subject: Re: Exclude SMF Records by date&time with DFSORT You can also select date and time ranges with the IBM program IFASMFDP //DUMP EXEC PGM=IFASMFDP //DUMPIN DD DISP=SHR,DSN=SYS1.MANX //* //DUMPOUT DD DSN= ,DISP=(,CATLG), // DCB=(LRECL=32760,RECFM=VBS,BLKSIZE=0), // SPACE=(CYL,(1999,99),RLSE),UNIT=SYSDA //SYSPRINT DD SYSOUT=* //SYSIN DD * OUTDD(DUMPOUT,TYPE(0:255)) INDD(DUMPIN,OPTIONS(DUMP)) START(0900) END(1000) SID(MVSP) DATE(2009022,2009022) /* // -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of Uwe Oswald Sent: Tuesday, August 28, 2012 10:05 AM To: [email protected] Subject: Exclude SMF Records by date&time with DFSORT Hi, has somebody ever tried to exclude (!) SMF records from a dataset with DFSORT? My interest is especially to exclude several (more than one) date and time ranges. Has someone an example for me, please? Thx in advance. Cheers, Uwe ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN ATTENTION: ----- The information contained in this message (including any files transmitted with this message) may contain proprietary, trade secret or other confidential and/or legally privileged information. Any pricing information contained in this message or in any files transmitted with this message is always confidential and cannot be shared with any third parties without prior written approval from Syncsort. This message is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any use, disclosure, copying or distribution of this message, in any form, is strictly prohibited. If you have received this message in error, please immediately notify the sender and/or Syncsort and destroy all copies of this message in your possession, custody or control. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
