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
