View previous topic :: View next topic
|
Author |
Message |
Sherril Johnson
New User
Joined: 05 Jan 2015 Posts: 4 Location: USA
|
|
|
|
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 |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
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 |
|
|
Sherril Johnson
New User
Joined: 05 Jan 2015 Posts: 4 Location: USA
|
|
|
|
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 |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
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 |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
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 |
|
|
Sherril Johnson
New User
Joined: 05 Jan 2015 Posts: 4 Location: USA
|
|
|
|
Unfortunately, SAS is not available on all of the systems I have to process. |
|
Back to top |
|
|
Sherril Johnson
New User
Joined: 05 Jan 2015 Posts: 4 Location: USA
|
|
|
|
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 |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
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 |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Use OUTFIL reporting features, NODETAIL,REMOVECC,TRAILER1 with TOT/TOTAL for each of your fields. |
|
Back to top |
|
|
|