IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Processing SMF Records


IBM Mainframe Forums -> SYNCSORT
Post new topic   Reply to topic
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
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: 1689
Location: Tiruppur, India

PostPosted: Fri Jan 30, 2015 1:01 am
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 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
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: 1689
Location: Tiruppur, India

PostPosted: Fri Jan 30, 2015 1:30 am
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: 1689
Location: Tiruppur, India

PostPosted: Fri Jan 30, 2015 2:48 am
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
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
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: 1689
Location: Tiruppur, India

PostPosted: Fri Jan 30, 2015 3:10 am
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

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7311
Location: Inside the Matrix

PostPosted: Fri Jan 30, 2015 4:29 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> SYNCSORT

 


Similar Topics
Topic Forum Replies
No new posts Merging more than two records DFSORT/ICETOOL 15
No new posts Matching and non matching records usi... DFSORT/ICETOOL 11
No new posts REMOVE DUPLICATE RECORDS BASED ON A S... DFSORT/ICETOOL 4
No new posts Using sort on VB records based on off... DFSORT/ICETOOL 6
No new posts Inserting records into the empty segm... IMS DB/DC 1
Search our Forums:

Back to Top