Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Processing SMF Records

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> SYNCSORT
View previous topic :: :: View next topic  
Author Message
Sherril Johnson

New User


Joined: 05 Jan 2015
Posts: 4
Location: USA

PostPosted: Fri Jan 30, 2015 12:11 am    Post subject: Processing SMF Records
Reply with quote

I would like a quick and dirty way to process SMF Type 119, Subtype 2 records (TCP termination) with the following results. I want to

1) Filter on only Type 119, Subtype 2 records for a specific date.

INCLUDE COND=((6,1,BI,EQ,X'77',AND,24,1,BIEQ,X'02'),AND,(11,4,PD,EQ,115015)

This part works fine.

2) I want the output to be only one record with two fields, the sum of location 205, 8 bytes binary the sum of location 218, 8 bytes binary. These are the Inbound and Outbound byte counts for each connection.

I cannot get the SUM FIELDS to yield just one output record.
Back to top
View user's profile Send private message

vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1445
Location: Azeroth

PostPosted: Fri Jan 30, 2015 1:01 am    Post subject:
Reply with quote

Hi,

I think this
Code:
AND,24,1,BIEQ,X'02'),
is supposed to be
Code:
AND,23,1,BI,EQ,X'02'),

To filter only subtype 2 records.

check here http://www.pacsys.com/smf/smf119_subtype02.htm for the layout.
Back to top
View user's profile Send private message
Sherril Johnson

New User


Joined: 05 Jan 2015
Posts: 4
Location: USA

PostPosted: Fri Jan 30, 2015 1:19 am    Post subject:
Reply with quote

Thanks for your reply.

The mapping from pacsys.com uses offsets, not starting location. The first field, SMF119LEN, is offset 0, but is at byte 1. Hence why I used 6 instead of 5 for type and 24 instead of 23 for subtype. i have verified that the selection criteria is correct by copying 200 records.

My problem is getting the single record output.
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1445
Location: Azeroth

PostPosted: Fri Jan 30, 2015 1:30 am    Post subject:
Reply with quote

Hello,
If you look at the PACSYS link, the offset is actually 22.
So I am guessing you need to read the field from position 23.

Could you check again?
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1445
Location: Azeroth

PostPosted: Fri Jan 30, 2015 2:48 am    Post subject:
Reply with quote

BTW.. Do you have SAS? If yes then there is an awesome wonderful swaggeleasously simple solution to this :-)

Else we could do it with SORT
Back to top
View user's profile Send private message
Sherril Johnson

New User


Joined: 05 Jan 2015
Posts: 4
Location: USA

PostPosted: Fri Jan 30, 2015 2:50 am    Post subject:
Reply with quote

Unfortunately, SAS is not available on all of the systems I have to process.
Back to top
View user's profile Send private message
Sherril Johnson

New User


Joined: 05 Jan 2015
Posts: 4
Location: USA

PostPosted: Fri Jan 30, 2015 2:54 am    Post subject:
Reply with quote

Also subtype is a 2 byte field and I only check the second byte. That is why I used 24 instead of 23.
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1445
Location: Azeroth

PostPosted: Fri Jan 30, 2015 3:10 am    Post subject:
Reply with quote

Reading only the 2nd byte makes sense.
I am at home, will try out a solution tomorrow.

Meanwhile if you could post the exact sum fields card & the error message
that you are getting, then someone would be able to help you much easier.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7223

PostPosted: Fri Jan 30, 2015 4:29 am    Post subject: Reply to: Processing SMF Records
Reply with quote

Use OUTFIL reporting features, NODETAIL,REMOVECC,TRAILER1 with TOT/TOTAL for each of your fields.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> SYNCSORT All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to split the records using the am... vnktrrd DFSORT/ICETOOL 24 Fri Oct 28, 2016 7:33 pm
No new posts Sort records based on numeric field. Alks SYNCSORT 2 Wed Oct 19, 2016 10:14 pm
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm
No new posts Run stats processing on zIIP Engine Virendra Shambharkar DB2 9 Fri Oct 14, 2016 10:24 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us